Thanks again for your reply, but I figured it out. I used CTE and Union to combine both queries. I know it's not best solution but don't have big dataset,...

Hi,

Thanks for reply but QtyReceived and QtyShipped are from totally different tables.

Actually it's for inventory calculation. First query give me purchases and I want to minus 2nd query which is sales. So basically what I want is Purchase(Query 1) - Sales...

Thank you Sean Lange. Your suggestion to comment out Execute statement and using select @sql helped. I fixed my problem. Now table is loaded.

Thanks again.

I did remove try/squelch block, and I did catch "C:/Linesheet/" error to. But Now I'm getting conversion error. First StyleID is "01511 bubble dress.JPG".

Here's the error:

Msg 102, Level 15, State...

Hello there, did you find solution to your problem? If you did can you pls share your solution?

Thanks

forgot to add code for update here it is:

UPDATE TB_HOSP_CORE

SET mon = AMONTH

FROM

hosp_core ss

INNER JOIN TB_HOSP_CORE tb

ON tb.PATIENT_ID = ss."key"

Thanks for the reply lowell, but just added a column to the table and want to populate it with data from hosp_core.

So I took advise and ran update statement...

Have you thought of using SSIS?

I haven't used vista so far but i have seen other ppl using it and what they were doing is they were opening application like SSMS as Administrator. Basically what...

Tried to add new column and then tried to reshuffle it to different order in the existing table, gave me warning that it would need to drop and recreate table....

hi i tried it on my machine it worked perfectly fine without any errors. by the way in the syntax given by Alex has an expiry date and not start...

Thanks for the document MANU.

Ok in that situation, my guess would be to create script to read data from remote database and update your database. Schedule to run that script every evening, so that...

You can do transactional replication. If you do search on sqlservercentral right side top corner you will find good articles about replication.