Thanks, I'm trying with WHERE but I'm just not getting the gist of it yet.

I want it to look at the Date to be unique and only to take through...

If you're okay with it being a CSV file (which opens...

espanolanthony (10/16/2012)

---

Hi,

I have this below script and need the output in excel in D:\Reports folder. Anyone can help me with this. I don't know much with queries and all...

Thanks, that worked.

We don't get three in a day, we only get two sent to us daily.

select distinct code from @T

I guess I won't! We do have a piece of software that also gives us...

I tested it with other data and it works great, thanks.

Abu Dina (10/15/2012)

---

Okay so something like the below might work for you:

IF (select count(*) from [e009]) > 0

begin

exec msdb.dbo.sp_send_dbmail

@profile_name = 'Default',

@recipients = 'me@example.com',

@subject = 'warning',

@query = 'select * from [e009]',

@attach_query_result_as_file...

Abu Dina (10/15/2012)

---

sqlrd22 (10/15/2012)

---

I have a job in SQL Server Agent that sends the results of a query to my email twice daily, however most of the time this query...

The code I'm running is

SELECT * FROM GATE.dbo.DATAFLOW WHERE RAW LIKE 'AAA|E0000000|_|'+CONVERT(VARCHAR(8),GETDATE(),112)+'%ECP%'

I'm currently trying to do this using BCP -

BCP

"SELECT * FROM GATE.dbo.DATAFLOW WHERE RAW LIKE 'AAA|E0000000|_|'+CONVERT(VARCHAR(8),GETDATE(),112)+'%ECP%'"

QUERYOUT "test.csv" -c...

Thanks 🙂 that worked.

Sorry I've only just managed to...

I don't really understand the question. Do I have to specify a limit? No. I did try the set textsize option but this did not change the output for me.

I don't have SSIS with my version of SQL, sadly.

Sorry, I didn't know what this stored proc was, I've looked more into it now and it's not what I want. I do not want the results emailed to me,...