Recent content by jrprogr

I have problem in the designing the tables......I had posted the issue in new post..

Denise, Does the user who execute the openrowset script should have bulk insert permission also... If NO how we do specify in the script to read the all files dynamically from the directory instead of one file(somefile) in the select script..

Please help in writing the query to get the output. Table1: Fld1 Fld2 Fld3 Fld4 ---------------------------------------------- 1 1988 5487 2004-08-05 00:00:00.000 1 1988 5675 2006-08-05 00:00:00.000 Table2: Fld1 Fld2 Fld3 -------------------- 2 1988 256 2 1988 250 Output...

I got the appropariate access.. Now i got the below error on executing the bulk insert.. Could not bulk insert because file 'mycomputername\\c:\test.txt' could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.). Executed Scripts...

Thanks Michael... Suggest me the other alternatives where i can't use DTS, BCP,Bulk insert..Since i dont have permissions execute on Master Db..Since i have to use Xp_shell commands for bulk insert.. and File system for DTS..

I dont have access to permission for bulk insert/bcp. Could please suggest other alternatives..

Please help me in writing a query to import the comma separated data in a text file to sqlserver 2000. Below is the sample data from the text file. 100,1,xx,yy,20030101 100,2,21,t4,20030101 100,3,2p,01,20030101 100,1,xx,yy,20030102 100,2,21,t5,20030102 100,3,2p,01,20030102 I want the output...

Thanks alex!! yr query works fine.. How about below query which also works but do yu see any problems with the below query select id = coalesce(a.id, b.id), a.emp, a.city, b.gender, b.age from tablea a full outer join tableb b on a.id = b.id

I have a written a query which is not producing the desired output.Please help me in getting the output. select b.id,emp,city,gender,age from tablea a full outer join tableb b on a.id=b.id Tablea ------ id emp city ------------ --------------------...

Please give me your valuable suggestions for the below sceniaro. We will get a flatfiles every day which i need to export the data into sqlserver 2000.The flat files which may contains more than 350 columns some of columns data may be nulls. What is the best way to address the above scenario...

Thanks for the response. I was told to design the data flow for the below sceniario.. We have Branch offices in different locations which will uses an application to create the raw data to flat file.Which BO(Branch office) in turn send the flat files (.csv) to our head office. What is the best...

I am designing a data flow archieture.I need the suggestions. What are the advantages of storing data of the flat files to sqlserver.

Thanks !! Incase of having nulls in the table EmpNo Empdate ----- ---------- 01 Null 01 06/28/2006 02 03/24/2006 03 Null 03 06/24/2006 04 09/27/2006 Output: EmpNo Empdate ----- ---------- 01...

I need help in getting the results: EmpNo Empdate ----- ---------- 01 06/23/2006 01 06/28/2006 02 03/24/2006 03 05/21/2006 03 06/24/2006 04 09/27/2006 Output: EmpNo Empdate ----- ---------- 01 06/28/2006 02 03/24/2006 03 06/24/2006 04...

I am getting the desired output with the below query.. select p1.Csid, p1.sid, prod2 = case when max(p3.prod3) = 'A1' then 'A1' when count(*) > 1 then '4' when max(p2.Prod2) = 'T5' then '1' when max(p2.Prod2) = 'T3' then '2' when max(p2.Prod2) = 'T1' then '5' else max(p2.Prod2) end ,p3.prod3...