Thank You Eugene Elutin....!

Thank you for your reply

The file is located in the server machine's D:\ drive

Another thing is that I am loging into SSMS in Client / Server through the same...

[font="Arial"]

I suggest you go thru PIVOT Tables once if you have time...

[/font]

IF the dates are constant you can frame up this way

select * from (

select...

Mr. Moden

I gave that statement bcoz Dave gave me some blog link to verify so i asked him and told him if you can solve...

select t3.* from table1 t1

inner join table2 t2 on t1.columnA = t2.columna

inner join table3 t3 on t2.columnb = t3.columnb and t3.columnc = t2.columnc

tan Q

try out this.....

select * from table1 t1

inner join table2 t2 on t1.columnA = t2.columna

inner join table3 t3 on t2.columnb = t3.columnb and t3.columnc = t2.columnc

i asked you for an update statement

not the select

need to update the same column which is generated by this select in the table with corresponding data

sorry buddy.............. if u r really talented enough jst solve it here itself

yah... really a good question and i got some info reading implicit transactions need 2 read jst think it to be the kick start

still u have this sort of...

hello....

if u dont mind plz let me knw how u are loading the data through a wizard or through some scripts like vb script or bulk insert ... etc

so that...

hello frnds....

wht ever it may be in order to run completely a block of t-sql code it should be syntax error free

i think there is no += operator...

Hi rookie

jst try out this.........

Select

case datepart(dw,RCPTDT)

when 1 then 'Sun'

when 2 then 'Mon'

when 3 then 'Tue'

when 4 then 'Wed'

when 5 then 'Thur'

when 6...

yaah...! thts right if you have a text or a image datatype column in the table and you try to trigger any action from trigger then you get that error...

Hi Rookie...

I didnt modified the entire code but just added ur requirement verify it once and if u want it in any other manner then tell me i will...