not from the ssms.. wanted from the individual scripts.

Tried through DOS command.. Its done. Thanks a lot

any suggestions please?

oh its taking it as new line i guess..... /n

oh yes... it is "D:ew.bat" i missed it while posting it here... but i ma trying with D:ew.bat only

it's done. I added a Level column with 0 and 1 and ordered accordingly.

Thanks

ty so much. I tried your suggestion and got the result for all the months.

The final query after a CTE is -

select Month,Resource,DepDate,Increase,Proj_Bkd,Vol_Target,Difference_B_T,Difference_Proj_T,Perc_Bkd_Trgt,Final_Prev_Year,Booked_SDL,Perc_Booked_To_Final from temp

union all

select 'Total' ,null,null,sum(Increase),sum(Proj_Bkd),sum(Vol_Target),sum(Difference_B_T),sum(Difference_Proj_T),sum(Perc_Bkd_Trgt),sum(Final_Prev_Year),sum(Booked_SDL),sum(Perc_Booked_To_Final) from...

This will give only the four rows for which there is data... I need result for all the months

any suggestions, please?

will be making sure that there are only trusted connections.

Just wanted to check if i am missing something if i write the password.

thanks a lot. 🙂

yes. This is what i am stuck with.

I have to use bcp ulpoads in a proc.

like -

SET@JOBSTR = 'Exec master..xp_cmdshell' + ' ' + '''bcp' + '...

Please if anyone can suggest something...

Like I have got the user name from SYSTEM_USER. How do i get the password?

There was a confusion earlier. I had not seen this post of yours.

This gave the desired results. Thanks a lot.

Hey.. I didnt read this earlier.... It is working fine.. Giving the desired results 🙂 but seems to be a slow query. (taking 10 sec to process 1 lac records)....

Thanks.

So you think there can be some other options? As i have quite a few checks in where clauses for different tables and columns.

Or should i go with the...