Hi George,
One way of achieving this would be to create and define your temp table first and the insert into from the proc, for example -

declare

Thanks Paul, Passing the -W parameter did the trick.

Many Thanks

Hi,

Thanks for your reply. The reason why I added that was to remove the row count on the output of the CSV. However I removed the section as you suggested...

Hi, Sorry yes I am replacing <SERVERNAME>. Thanks

So the cmd looks like -

sqlcmd -S MyServerName -E -h -1 -d AdventureWorks -Q "SET NOCOUNT ON; SELECT U.[UserId] ,U.[UserName] ,U.[DateCreated] FROM dbo.Users...

Hi,

You can simply do a group by statement, unless I have misunderstood your request. See below example -

SELECT FirstName, LastName, MAX(DateCreated)

FROM dbo.Customer

GROUP BY FirstName, LastName