This code will work for any date within a quarter to find the end of month for the three months in the prior querter.

select

CurrDateTime,

PriorQtrMonth1 = dateadd(mm,(datediff(QQ,0,CurrDateTime)*3)-2,-1),

PriorQtrMonth2 = dateadd(mm,(datediff(QQ,0,CurrDateTime)*3)-1,-1),

PriorQtrMonth3 = dateadd(mm,(datediff(QQ,0,CurrDateTime)*3),-1)

from

(...

dwain.c (9/12/2012)

---

Michael Valentine Jones (9/12/2012)

---

dwain.c (9/12/2012)

---

Another way:

;WITH MyValues AS (

SELECT Id

,A=CASE WHEN A > 0 THEN A...

dwain.c (9/12/2012)

---

Another way:

;WITH MyValues AS (

SELECT Id

,A=CASE WHEN A > 0 THEN A ELSE 2147483647 END

...

I think this code is about as short as it gets to do this:

select

[DD-MM-YYYY] =

convert(varchar(10),dateadd(mm,(12*YEAR_)-22801+MONTH_,DAY_-1),105),

[Date]=dateadd(mm,(12*YEAR_)-22801+MONTH_,DAY_-1),

a.*

from

PS_TestForOnline a

Results:

DD-MM-YYYY Date ...

This seems simple and fairly fast:

declare @n table ( n int not null primary key clustered)

insert into @n select top 1000 n=row_number() over(order by id)-1 from syscolumns

select*

from(selectx,y,z = x-y, c...

The ancient Japanese art of Orange-gami:

http://www.youtube.com/watch?feature=player_embedded&v=CVHF0J8XOKM

select

ID,

[MinVal] = (

select

min(x)

from

(

select x=A where A > 0 union all

select x=B where B > 0 union all

select x=C where C > 0

) m

)

from

#MinAmt

order by

ID

Results:

ID ...

dwilliscp (9/7/2012)

---

The problem with...

You haven't provided enough information for anyone to begin to answer that question.

You should just try each way to see which is faster.

Did you compress the files?

What was the total size of the compressed backup files?

Did you copy multiple files in...

If you are not using one, I suggest installing a backup compression product, like Litespeed or Redgate backup, to make the files smalller. Or as an alternative, use a...

I think any conference situation where there is a lot of consumption of alcohol, especially by young men, is likely to lead to this sort of behavior.

This is probably why...

SQL Mad Rafi (8/31/2012)

---

Hi Friends,

My problem is: the DML of a table fails, then i found that it is because of a indexed view on...

The thing I think is stupid about the EAV model is that it actually poorly duplicates what is already built into SQL Server: sys.tables, sys.columns, sys.types, and the tables themselves.

The...

sestell1 (8/31/2012)

---

guerillaunit (8/31/2012)

---

Thanks Michael. I was hoping to avoid the restart, but it looks like there are no alternatives. I've never restarted a server before. Any things...