It can be done in SQL, but if you're using a reporting tool, you should do it in there.

Assuming you have @@DATEFIRST = 7, you could use this formula:

SELECT CASE WHEN DATEPART(DW, DATEADD( MM, DATEDIFF(MM, 0, GETDATE()), 0)) = 2

THEN DATEADD( DD, 4, DATEADD( MM, DATEDIFF(MM, 0, GETDATE()),...

The reason that makes the query work without the alias is that a.JOB_Date is different to JOB_Date which is the column alias.

I'm not sure how would you be able to...

And after some testing on SQL Server 2012, the DelimitedSplit8K still is the fastest solution posted in this thread. However, I haven't tested the new version presented by Eirikur in...

You can concatenate the quotes

SELECT '''' + Column1 + '''' AS quotedColumn1

FROM TableA

Why are you using 100, 101 & 102 for statos when you don't seem to have that values in your stato column?

Informer30 (3/24/2014)

---

ok - I am understanding correctly -

1. output to csv or txt

2. then in excel import the csv or txt and I should see all of the 2million...

It's nice, but the DelimitedSplit8K version will work in half the time :-). You might not notice it with a few rows but it becomes...

Would this give you the correct result?

SELECT

Users.Department as Dept,

CaseTypes.Description as Case_Type,

Users.Code as FE,

COUNT(Matters.FeeEarnerRef) as No_of_Matters,

ISNULL(SUM(Usr_Int1.Estimated_total_fee),0) as Fee_Estimate

FROM

((Users LEFT JOIN Matters ON Users.Code = Matters.FeeEarnerRef and...

You need to provide more information. To find out what could be wrong, people need DDL for tables and indexes, as well as actual execution plan as described in this...

Using CROSS TABS you could achieve this easily without UNION ALL.

SELECT MAX( CASE WHEN system = 'system 1' THEN item END) system1

,MAX( CASE WHEN system = 'system 2' THEN item...

Here's another option. I was thinking more of creating it for an iTVF (but leaving that part to you).

DECLARE @String varchar(20) = '00001001001';

WITH e1(N) AS(

SELECT N FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))e(N)

),

cteTally(N) AS(

SELECT TOP(LEN(@String))...

It depends, I would add a clustered index before thinking about a non-clustered one. It depends as well on the size of the table and the columns and rows used...

Why do you say you can't use aggregate functions on dates? SUM isn't the only aggregate available.

Is this what you need?

Select @SQL2 = ISNULL(@SQL2+',','') + CHAR(13)

...

That has always been like that. It's not new to 2008, it already existed on 2000. The query might have been changed.