SELECT 'col1,col2,col3,col4' as line
 UNION ALL
SELECT CONCAT('''', col1,''',''', col2,''',''', col3,''',''', col4,'''')
  FROM myTable

Is it really SQL 7, 2000 you are using?

An alternative is to use OUTER APPLY:

OUTER APPLY (SELECT TOP(1) * 
               FROM...

Is it REALLY possible to bypass the @Where_Clause variable and make the below SQL non-dynamic?

This is a statement from an SP that receives the below 5 parameters and dynamically...

All this does is select rows where RN is odd

WHERE RN % 2 = 1

I'm not quite sure what you want. Are you looking to get the...

I think the OP...

SELECT * 
  FROM #aaa a
 WHERE EXISTS(select * from #aaa b where b.alertid = a.alertid and b.alerttypeid = 4)
   AND EXISTS(select * from...

DECLARE @Date1 datetime = '20150630'
SELECT DATEADD(m,6, @Date1)

'2015-12-30 00:00:00.000'

SELECT DATEADD(m,-12,GETDATE())

'2019-03-19 22:54:19.727'

'2015-12-30 00:00:00.000' < '2019-03-19 22:54:19.727' = TRUE

SELECT LEN(Area + 'x') - 1

Thanks, my CASE is what I was worried about.  If all I have to do is change the ORs to ANDs, then I'm happy.  I was able to find...

I think you will get better results using a CTE than writing any function with a query in it.

This should be faster, but I think you could get it even...

I'm confused by your query. Why have you got distinct in "SELECT distinct(td.EVENT_ID)"?

You have EVENT_ID in the group by. Distinct applies to the entire line, not just what you put...

If you make it a table valued...

Each time you use the function it is doing a query on the table. So if you use the function 10 times it will do 10 queries on the table...

• This reply was modified 5 years, 6 months ago by Jonathan AC Roberts.

SELECT….<column list>
FROM  CA_Leaves CL
WHERE  CL.C_Status     = 'New'
  AND (@i_PARAM1_field = @i_PARAM3_field 
        OR...