Here's another approach:

WITH cteEmpDates AS

(

SELECT ID, STARTDATE AS AnyDate FROM #EMP_INFO UNION ALL

SELECT ID, ENDDATE FROM #EMP_INFO

), cteDates AS

(

...

Fantastic Gail! Congratulations.

Starting with SQL Server 2008R2, you can run...

SQLRNNR (7/23/2015)

---

dweil (7/23/2015)

---

Who really cares if they are looking up the answer on the internet. The idea is to see how they would approach /solve a particular problem/solution. If they...

Good luck with adding that index to the...

TheSQLGuru (7/22/2015)

---

This should be able to be done with WINDOWING functions since you are on SQL 2012. I bet I could also do it very quickly and efficiently using DATEADD...

xtimesu (7/23/2015)

---

I'm new to this so please bare with me..

This is what the report looks like when I run it.. and then how I want it to look is...

MPF (7/23/2015)

---

Hi Wayne,

I completely appreciate what you said and that if i don't understand what it's doing then don't use it.

Your write-up and description however is really very helpful indeed....

mpdillon (7/22/2015)

---

The database has approx. 2500 temporary tables. The temp tables match a pattern such as APTMP... I tried deleting the tables in SSMS with the statement,

Delete from Information_Schema.tables where...

tcronin 95651 (6/29/2015)

---

Dealing with 3rd party database. When analyzing tables/indexes found 2 indexes on one table. Which would not be bad but

index #1 clustered index on column a.

index...

xtimesu (7/22/2015)

---

Please help!

Need query to provide rolling 12 month and prior year rolling 12 month. Example: If this is July I would want Jun 14-July 15 and Jun 13-Jul 14

I...

greggg (7/22/2015)

---

I’m trying to extract a list of records that don’t appear between 2 dates and could use a bit of help figuring it out. I have 4 tables:

tblCustomers

tblMachines

tblServiceOrders

tblMachinesServiced

tblCustomers contains...

That's his signature... it's put on all of the posts automatically.

MPF (7/22/2015)

---

WayneS (7/21/2015)

---

Ed Wagner (7/21/2015)

---

WayneS (7/21/2015)

---

What we need to do here is to look at the patterns.

The Length is from the first numeric value to the first non-numeric value.

The Width...

Brandie Tarvin (7/22/2015)

---

Here's my fun thing for the day:

2 a.m. Email: Disk X on non-prod server test is full

2 a.m. Email: Disk Y on non-prod server qa is full

2 a.m....