Which posted possibly solution are you refering to?

If it is my posting - please...

A method which should work in 2005 (sample code copied from the 2008 help file)

USE AdventureWorks;

GO

CREATE PROCEDURE dbo.InsertUnitMeasure

@UnitMeasureCode nchar(3),

@Name nvarchar(25)

AS

BEGIN

...

Are you familiar with the new MERGE statement (Introduced in SQL 2008) ?

May I suggest looking at:

http://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/

and:

SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for...

Just a suggestion - look at this article by Jeff Moden on an 8K splitter, its use just might help you.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

This might get you thinking (especially how to improve the code I have posted below). Seems I got my mind in a rut and could come up with nothing...

Many people here will attempt to assist you.

But what is your problem ... ? ? ? ? ?

Is...

Nice question ....

Good question - thanks for reminding me of the basics

Nice question ...

This may or may not be of help to you, but it is the only method I have utilized and it worked for myself. So for what assistance it...

tilew-948340 (1/23/2012)

---

I desagree with every one because Resource Governor is available only on the Enterprise, Developer, and Evaluation editions of SQL Server.

The question was 'on your SQL Server 2008 R2...

Nice question really had to dig deep into my memory to, well answer the question.

A question for you. Why...

GilaMonster (1/18/2012)

---

Gianluca Sartori (1/18/2012)

---

From time to time, the questions are really getting worse.

This one made my LMAO:

OP: I have performance issues and I'm totally clueless.

Gail: Hire a consultant.

OP: I'm the...

Is this what you are searching for?

Select dateadd(qq, datediff(qq, 0, @ThisDate), 0)

Whoops that gives you this quarter NOT last quarter ... sorry about that