That order by clause is functionally identical to "order by carac desc" 😀

If you could post your full...

Hi Thomas, what problem are you running into?

Thanks

Gaz

agabb (10/22/2012)

---

INSERT INTO [ADDRESS] ([CLIENT_NAME], [ADDRESS1])

VALUES ('ABC CORP', '50 Langridge St.');

INSERT INTO [PROJECT] ([PROJ_NUMBER], [PROJ_NAME], CLIENT_ADDR_ID])

VALUES ('A445566', 'My Project Name',...

Add an order by clause, something like:

ORDER BY CASE CARAC WHEN 'None' THEN 1 ELSE 2 END ASC, PROJ ASC

Nils Gustav Stråbø (10/19/2012)

---

Aaaaarg!!! Got it wrong because of the unclustered index options.

I know that SQL Server enforces unique constraints by creating unique indexs, but I wasn't sure if this...

No problem 🙂

Add more apostrophes 🙂

exec msdb.dbo.sp_send_dbmail

@profile_name = 'Default Public Profile',

@recipients = 'example@example.com',

--@copy_recipients = 'example@example.com',

@subject = 'I022 flows',

@query = 'select * from [GATEKEEPER].[dbo].[DATAFLOW_CLOB] where [RAW_CLOB]

LIKE ''AAA|S0141007%SPH%''',

@attach_query_result_as_file = 1,

@query_attachment_filename = 'test.csv'

GO

As it is, you can't. Would it be possible to execute the query, set the result to a variable, and then concatenate that to another variable for use in sp_send_dbmail?

e.g....

SET DATEFORMAT (which is implicitly set by using SET LANGUAGE) controls the interpretation of character strings into date datatypes.

You can see the effect here:

set dateformat mdy --(which would be set...

Yep. SSRS & BIDS are included in Express with Advanced Services. SSIS I'm less sure about.

+1 for SQLBits - I attended this year, really impressed. Hopefully I'll get there again next year.

Jason-299789 (10/9/2012)

---

Gazareth (10/9/2012)

---

Jason-299789 (10/9/2012)

---

I think that Joe was probably refering to some form of regulatory requirement, eg Sarbanes Oxley/solvency II or other federal...

Lol, apologies. Definitely a skillful game. Did used to watch...

Jason-299789 (10/9/2012)

---

I think that Joe was probably refering to some form of regulatory requirement, eg Sarbanes Oxley/solvency II or other federal requirement to...

vahid.arr (10/9/2012)

---

Gazareth (10/9/2012)

---

vahid.arr (10/9/2012)

---

Performance is not important Because I want To Do it One Time.I want All Removed Data from My Main Database Come to Another Database So I...