Paul White NZ (5/27/2010)

---

jts_2003 (5/27/2010)

---

A quick search on Microsft's website:

http://msdn.microsoft.com/en-us/library/ms175049.aspx

This clearly gives 8, which wasbn't even an option!

Not my favourite question, although it did make me think a bit more...

Paul White NZ (5/27/2010)

---

jts_2003 (5/27/2010)

---

A quick search on Microsft's website:

http://msdn.microsoft.com/en-us/library/ms175049.aspx

This clearly gives 8, which wasbn't even an option!

Not my favourite question, although it did make me think a bit more...

Since DateDiff returns the number of boundaries crossed in comparing these two dates, it will report the wrong age if today's...

Check out the two links in my signature for dealing with CROSS-TABS and PIVOTS - this looks like what you'll need.

Rog Saber (5/26/2010)

---

I'm trying to add some computed fields to my select by adding something like column = (Select count(*)...)

But, it is making the query take a really long time...

You might want to check out the articles by RBarryYoung on 15 Ways to Lose Your Cursor[/url] - he walks you through it step by step.

CirquedeSQLeil (5/26/2010)

---

WayneS (5/26/2010)

---

Roy Ernest (5/26/2010)

---

We have lots of PM's and BA's here with degrees. But none has what we commonly call as common sense. I never knew that common sense...

Paul White NZ (5/26/2010)

---

Is the current column defined as NOT NULL? If so, there is a neat trick that makes it almost instant regardless of the number of rows.

Table...

Use a config file to set up a package variable. Pass the package variable to the script task. Check out this link.

Roy Ernest (5/26/2010)

---

We have lots of PM's and BA's here with degrees. But none has what we commonly call as common sense. I never knew that common sense was not...

You might want to check out Jeff Moden's excellent article on Running Totals[/url].

After doing this, if you have any more problems, come on back!

How does this work out for you?

SELECT DISTINCT

e.EMPLID,

e.EMP_STATUS,

e.EMP_IDENTITY,

...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Not a problem... but it does GREATLY help us out... if we can just cut-and-paste some code that creates the problem you're trying to figure out, you will get a...

Great job of posting the table DDL, sample data, and expected output! Makes me just want to jump in and help you out.

How does this work for you?

SELECT DISTINCT

...