No prob. You know I also make faults 😉

Copy my above script into SSMS and execute...

If you want a comma separated list of the numbers use a quirky update syntax (or a FOR XML, which performs better but is more complicated).

Here the quirky update:

DECLARE @Month...

You can also use an inline Tally table:

DECLARE @Month DATETIME

SELECT @Month = '2009-02-01'

; WITH

t1 AS (SELECT 1 N UNION ALL SELECT 1 N), -- 2

t2 AS (SELECT 1...

I confirm Adi. A Tally/Numbers table is a great helper for many things. It requires about 150kb disk usage and the profit is really huge.

Have look to this article just...

Did this help?

Hi

I would advice to use a Tally table:

DECLARE @Month DATETIME

SELECT @Month = '2009-02-01'

SELECT

N

FROM Tally

WHERE

...

Am I correct that you are speaking about release/version management? If yes, maybe you mean "upgrade" instead of "update".

Both word have the same meaning.

Just two examples from BOL:

Look for "Migration...

Why not just adding a CurrencyTable which contains all currency names and their signs?

Hi

@Allister: You referenced Jeff's article, but pasted the RBAR split version 😉

@hunter: Please have a look to Jeff's article. The performance difference between a WHILE loop and a set-based (Tally...

So use a "Execute SQL Task" as I wrote.

Greets

Flo

Hi

If you just want to execute the procedure you should consider to use a simple SQL Server Agent job.

If you really want/need/have to use SSIS use a "Execute SQL Task".

Greets

Flo

... and all those features are a major reason for compatibility level 9.0.

I have to support SSE2k databases in combination with SSE2k5 databases. The new features are really great and...

Hi martin

The SELECT INTO only works if the destination table does not yet exist. If you want to insert the data into an existing table you have to use "INSERT...

Hi

Nope. There is no natural join in SQL Server, even not in SSE2k8. The closed version of a natural join in an INTERSECT.

Greets

Flo