Can sqlcmd be invoked from SSMS

absolutey fantastic

thanks very much that works

Alan

ok guys this is what I have with an error, see error below

use TestData

go

Drop table lookuptable;

WITH cteDupeCheck

AS...

Hi Guys.

Thanks for all your comments. Anyway going back to the original question will it be a definate that I have to create the table first before selecting into as...

Hi Lynn

I have added a group by clause on the end like so which seems to work

insert into RefTable(software_name_raw,software_name_amended)

select

bt.software_name_raw,

'Needs Updating'

from

...

Hi Lynn

Yeah very close to the expected result but the RefTable has a primary key on it. so if it encounters a duplicate record from the other table it also...

Hi Jason.

Thanks for that its all working now. I just need to work on tidying my reports up and granting permissions to various users.

Thanks again

Alan

Hi Lynn

That sort of works but when I run just this part for the second time I get.

Msg 2627, Level 14, State 1, Line 2

Violation of PRIMARY KEY constraint 'PK__RefTable__6897329A11007AA7'....

ok I seem to have got a little further with the deploy thing past the permissions problem I am now facing another problem which is

Cannot deploy the report because the...

Thanks for that, that was a big help I am a little further. I have created the report and managed to pre-view it but once I go to delpoy it...

Hi Lynn

Yes thats right

regards

Alan

that was quick i was still mentioning the last thing lol

anyway the code you have just provided is perfect but I still wish to overwrite the first column in the...

Hi Lynn

just me again I forgot to mention that yes I want to insert data that does not already exist in the Target Table but if it does exist then...

Lynn

I just downloaded this sample code from a website and amended accordingly and your right I do not want to update data that already exists so thanks for pointing that...

right Lynn I will try again.

I have had a look at your merge statement which has been useful the only thing is i have one error from the query below.

Please...