Hi

The SQL Service may have ended. Make sure under services it is running then try again.

Hi

If I understand this correctly he wants to retrieve all the duplicates in the table based on DocNo. If this is the case then the queery I provided above should...

Hi

Thanks for all the help so far. I'll have a look and give you some feedback. I'll also provide the precise error message asap.

Thanks

Hi

Is there a specific reason why you want to use a batch file to export the results produced to a csv? Why don't you use SSIS to generate the results...

Hi

I don't think MAX is going to work on the price field. If I understand correctly from the select statement that you provided the Price column contains the actual price....

Ok that makes sense.

I presume that you then just assign the EMailBody variable to the subject of the sendmail task and you're all sorted.

The main thing is that you...

Hi Jason

Do both of the files exist at the locations that you are referencing them from? The file I am talking about are "d:\sqlcode\backorder.sql" and "d:\sqlcode\backorder.sql"

If they do exist have...

No worries.

Would it be possible in SSIS to get the server name using an SQL task and then assigning it to a variable in SSIS which can then be used...

Hi

The way I discribed above is how one would do it in TSQL. To use the code in SSIS you can pop it in a Execute SQL Task.

How about creating a temp table to store the info that you want to export to the .csv file? In the temp table you make the column type of the...

Hi

The best way I can think of doing this is by using the xp_sendmail stored procedure as follows:

declare @NewSubject varchar(50)

select @NewSubject = server

from table

where status = 'n'

exec xp_sendmail @recipients='Recipients', @message='Message',...