Daniel Bowlin (10/19/2010)

---

I've known some people that have tried to make this don't...

Bill_CCAC (10/19/2010)

---

you folks are all fabulous. thank you all.

I had been trying to use the case statement but ran into problems and didn't get the results I was after....

As it's been pointed out you can do a single query and add an age group. From there pivot the data in the reporting application.

That'll take out 99% of...

This may help a little bit to decipher the code.

DECLARE @Start_Date As Datetime

DECLARE @End_Date As Datetime

SET @Start_Date = '04/01/2010'

SET @End_Date = '07/01/2010'

SELECT

'1to18' AS 'AgeGroup'

,...

Gary Varga (10/19/2010)

---

Ninja's_RGR'us (10/18/2010)

---

Matt Miller (#4) (10/18/2010)

---

Ninja's_RGR'us (10/18/2010)

---

How would you guys react? I still have full access to all source codes and their backups. I have no intent...

Matt Miller (#4) (10/18/2010)

---

Ninja's_RGR'us (10/18/2010)

---

How would you guys react? I still have full access to all source codes and their backups. I have no intent to destroy there...

And yes for all of you wondering, I'm available for work as of pretty much now.

Resume :

I know a little bit a SQL :w00t:.

SQL 7, 2000, 2005, 2008

Access, Office,...

Ninja's_RGR'us (10/18/2010)

---

GSquared (10/18/2010)

---

Ninja's_RGR'us (10/18/2010)

---

mike.hartman (10/18/2010)

---

There is a proper time and procedure for every matter, though a man's misery weighs heavily on him (Ecclesiates). Each of the options listed in...

GSquared (10/18/2010)

---

Ninja's_RGR'us (10/18/2010)

---

mike.hartman (10/18/2010)

---

There is a proper time and procedure for every matter, though a man's misery weighs heavily on him (Ecclesiates). Each of the options listed in the...

mike.hartman (10/18/2010)

---

There is a proper time and procedure for every matter, though a man's misery weighs heavily on him (Ecclesiates). Each of the options listed in the original post...

GSquared (10/18/2010)

---

These scenarios don't sound like disasters to me. They sound like challenges that would be fun at best and interesting at worst.

Games have a goal (or multiple goals),...

How about using ROW_NUMBER(PARTITION BY Member_ID, ORDER BY EndDate)

Then self join on ROWNumber = Rownumber + 1 and member_id= member_id

where dateadd(D, 30, tbl1.enddate) <= tbl2.stardate

I'm sure you'll figure out the...

LutzM (10/15/2010)

---

WayneS (10/15/2010)

---

Specifically, Do ALL tables that reference table konten have indexes on their foreign...

vky3 (10/15/2010)

---

If you already have indexes and are looking to drop and recreate those indexes ,then from a performance point of view, the best way to do it is to...

Grant Fritchey (10/15/2010)

---

Views aren't compiled. If you want to know which views are dependent on a table that you've modified, you can use sys.dm_sql_referencing_entities. If, on the other hand, you're...