What would be Week one for this year?

Either from 01-02 (Fr - Sat) or 03-09 (Sun-Sat)?

Or, to phrase it a little different:

What needs to be the first day of the...

I would use the following code.

The first CTE is used to order each guid per lastchanged column (desc order).

The second CTE calculates the sum of the latest two rows.

The final...

Glad we could help 🙂

Would something like the following code do the job?

DECLARE @t TABLE (IsSet bit)

INSERT INTO @t SELECT 1 UNION ALL SELECT 0

SELECT

CASE WHEN IsSet=0 THEN 'False' ELSE 'True' END AS...

dave.repton (1/21/2010)

---

As far as I am aware SQL will not be able to provide the dataset in the way you require - you would need to handle the display of...

Why not using a solution that doesn't use any while loops at all and do it all in one path?

;with cte

AS

(

SELECT

BusTypeCode,

n1 % (ncolLeft+nColRight) +1 AS Col_X,

row_number() over(partition...

One reason could be that you're using UNION instead of UNION ALL.

When combining two queries using UNION you'd force an (internal) DISTINCT to be applied to the result set, usually...

Would something like the following work?

Please note that I added some more lines to make the concept a little easier to understand since your sample data could have been joined...

Jeff Moden (1/19/2010)

---

lmu92 (1/19/2010)

---

When adding the following three samples to your data, which one should be displayed (each one has values in two out of three columns)?

select 'fred', 'unsure', 33716,...

Where do you get that result set from?

Instead of auto-generating column names you should ensure to get a useable result set in the first place...

Gianluca Sartori (1/20/2010)

---

...

Well, I can say that I had a baby...

You would either have to add a column identifying year + month instead of month only and alter your PIVOT clause to reflect that or you might want to have...

... or you can set up an XLS file as a linked server

... or you can use SSIS

... or bcp

... or send an email with the data attached as xls...

I would use the input parameter and a split string function together with a join.

Something like this:

DECLARE @input1 as varchar(50)

SET @input1 = '12,15,25,49'

SELECT * FROM

master..spt_values m inner join...

Ooopss!! Sorry, my fault (I mixed Object Explorer and Object Explorer Details...):blush: