Here is another way of doing so:

;with Months as (

select DATEADD(mm,datediff(mm,'19000101',getdate()),'19000101') as MyDate

union all

select DATEADD(mm,1,MyDate) from Months where Month(MyDate) < 12)

select * from Months

Adi

I have few machines with SQL Server 2008 and SQL Server 2005 (some of them also have SQL Server 2000). Before installing SQL Server 2008 you need to install...

Maybe this is not the answer that you are looking for, but I from my experience, if I have a maintenance job that fails each time that it runs, it...

Is this is the real code that you use? If it is, then I don’t think that it can even compile. You are trying to create a table...

:pinch: I'm sorry but as written this is wrong.

The reason why a clustered index ALWAYS goes to the same filegroup the table goes is because the leaf level of...

Pleas read the article that is on my signature to learn how to ask questions in a way that will get you a better and faster answer.

As...

The QUOTED IDENTIFIER set option is set during the creation of the stored procedure and sticks with it, so modifying this set option at the session that activates the procedure,...

This is done on purpose. When you create a clustered index on a heap you might want to move the table to a different file group, but you might...

When you create the index, you can specify the file group that you want it be on. If you don’t specify where to create the index, it will be...

Like you I would say that it depends. Suppose there is a procedure that inserts data into a temporary table, runs some complex calculations on the table (according...

As far as I know parameter sniffing uses the actual values of the parameters. If the parameters were passed with a different value then the default value, then the...

I don’t have much experience with full text search so I might be off base here, but did you try changing the file’s path or name by using the move...

Sp_who2 can help you when you don’t have many processes on the server that are being blocked. On a busy server you might have a big blocking chain (which...

I think that severity 16 should also do the trick

Adi

You have to be more specific then that. How do you decide which value goes to which column? Also post a small script that had the create table...