This is a simpler way to find the last day of the same month last year, if that is what you are after.

declare @MyDate datetime

set @MyDate = '2/28/2009'

select LastDay...

Lynn Pettis (5/24/2012)

---

Cadavre (5/24/2012)

---

Fizzbuzz is your evil interview? Really? It's as old as dirt (as are the solutions) 😛

WITH t1 AS (SELECT 1 N UNION ALL SELECT 1 N),

t2...

Yes. Index maintenance is just like any other transaction, so it is logged and gets applied to the target.

You should ask Reporting Services questions in the Reporting Services forum, instead of a TSQL forum.

This also works with one less function call.

select dateadd(yy,datediff(yy,-1,@date),-1)

I had an interesting experience recently where I was being interviewed by someone without the technical experience to be able to evaluate my skills at a company where I would...

chandan_jha18 (5/15/2012)

---

Hi,

I had a procedure where there was a condition in where clause:

where ISNULL(d.[RejectReason], 0) IN (240,241,300,301)

The column RejectReason is int,null.

After going through several posts in this forum, I started...

Jeff Moden (5/12/2012)

---

Elliott Whitlow (5/12/2012)

---

As a further point, I dislike most aspects of technical interviews purely because in MANY cases they are very subjective and if you don't give them...

If those are the only ways you access the table, then a clustered index on col2, col1 would cover all your lookups with no need for additional indexes.

However, I would...

Matt Miller (#4) (4/25/2012)

---

Michael Valentine Jones (4/24/2012)

---

I would think that venting the waste heat into a cluster of greenhouses would make a lot of sense. Grow expensive flowers or...

I would think that venting the waste heat into a cluster of greenhouses would make a lot of sense. Grow expensive flowers or vegetables in places where they would...

Abrar Ahmad_ (4/24/2012)

---

[font="Verdana"]Hi Folks,

We do have a new pragmatic software with the front-end technologies as N/Hibernate etc. The team has devised a manual sequence/identity mechanism (physical tables with next...

I would just point out that Facebook's terms of use state the following:

"...

You will not solicit login information or access an account belonging to someone else.

...

You will not share your...

Here is how to do it in your T-SQL query.

select

a.MyNum,

ZeroFilled =

case when a.MyNum < 0 then '-' else ' ' end+

right('00000000'+convert(varchar(11),abs(a.MyNum)),11),

SpaceFilled =

right(' ...

GilaMonster (4/5/2012)

---

george sibbald (4/5/2012)

---

I stand corrected, I had forgotten about forwarding pointers. what about internal fragmentation though?

where I have added a clustered index to a heap I have achieved a...