Oh - agreed. I wasn't taking a shot at your...

Use a tally table for that. It's a lot more efficient:

http://www.sqlservercentral.com/articles/TSQL/62867/%5B/url%5D

And that's the long version:)

In short - no. CTE's are designed to only apply to the one statement.

No - you wouldn't have to add anything else. Just like a derived column does, this script component would "add" a new column to the list of available items....

I'd agree with GSquared. You need both, and both are equally important. You need the innovators to push things along, give us better solutions, and you then need...

You can use a simple script component to number the rows as well. This assumes that the input table is "nicknamed" input0, and that the script component outputs a...

that would mean that you have some numbers that are larger that 999. You'd want to make the numeric "larger", so that it can accomodate the number of digits...

This is an "ordinal rank" type of question. Take a look at this article - should give you what you need to pursue in 2000:

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/%5B/url%5D

Mark's right. Your syntax performs an INTEGER division, and once a result is derived (3), the result is cast to numeric. Without casting to a numeric first (even...

Is the insert actually inserting any data? Triggers, etc. still trigger if no data qualifies.

Flag a post? how?

To add to the list of questions:

..are we talking full weeks (fully circumscribed within the month)? weeks that START within a month/weeks that END within a month?

RICHTER (5/22/2008)

---

Guys this is great, it works perfect in 2005, however it turns out I am going to need it to work in 2000, is there a simple conversion to...

You need a way to correlate the rows in the AS400 data to the rows in the SQL Server data. In other words - you need some combination of...