Also beware the the inserted table can contain more than one row if a multiple row insert is done.

If all the input dates are valid dates in the format DMY then use a derived column as you stated but cast the input to date (proving your output table...

Evil Kraig F (2/20/2013)

---

Hey folks, can I get some help here: http://www.sqlservercentral.com/Forums/Topic1421888-392-1.aspx#bm1421965

A very pleasant newbie... I just don't understand what he's trying to say. New eyes on the problem...

You will need to build a defined dataset using dynamic sql to union your statements or build a temp table and insert data interatively.

If your dataset contains the columns ID,SequenceNo,ColumnHeading...

L' Eomot Inversé (2/18/2013)

---

David Burrows (2/18/2013)

---

L' Eomot Inversé (2/18/2013)

---

Thanks Tom, I thought of that as well and...

L' Eomot Inversé (2/18/2013)

---

Thanks Tom, I thought of that as well and I intended my post to...

Stefan Krzywicki (2/15/2013)

---

So here's an idle question that no-one will see because it is right before the weekend.

Apostrophes are fairly common in names. Why do we still use ' as...

AFAIK you cannot use SSIS with VS2010 (this is documented on MS site and connect items).

Install and use BIDS from the SQL Server 2008 R2 media.

Yep, my bad :blush:

Changed my second solution to cater for nulls

SELECT learner,a, b, c, ISNULL(a,0)+ISNULL(b,0)+ISNULL(c,0) AS [total] FROM WHERE ISNULL(a,0)+ISNULL(b,0)+ISNULL(c,0) > 100

Edited to fix null issue

SELECT COUNT(*) FROM WHERE A+B+C > 100

or...

ORDER BY RIGHT(SPACE(20)+BipolarNumbers,20) ASC

dwain.c (1/15/2013)

---

Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:

Woooohoooo!!! My 2000th post! Time to celebrate!

Good grief! Seems like only...

Grant Fritchey (9/25/2012)

---

I'm not getting what this guy is after, so I'm clearly not helping. Could someone else check it out please?

Oh, and don't pile on the poor guy. I...

And therefore the ones that caused the routing of the routed are routers (rou-ters) :w00t: