Jnrstevej (6/8/2011)

---

I'm happy with the current results, however now i want perform a calculation using the case expression column called CURRENT_ABC_WEEKS. By create a new column '(LASTMONTHSIX/24)* CURRENT_ABC_WEEKS AS...

Thanks. When I simply add those columns to the group I get more than one column per transId/radid/ProcID combination...which I see you do not want based on your expected results....

Have you attempted to write a query yet? Please share what you have done so far.

+1000

Thanks for the great article David!

From the article:

Therefore, each row in a database, at any given point in time, can be identified by three numbers; file number - page number...

I think what you want to do is put your query into a CTE and then when selecting from the CTE add a column to the SELECT list that makes...

If you go with SSIS consider having it run on one thread, select the data out of TableA in clustered index order and do a sorted-insert into TableB.

If you have...

No problem. I just realized something else, because you know up front that both result sets will be unique you can use UNION ALL instead of UNION and save yourself...

Third try...please provide...

The worded explanation makes more sense with an accompanying code example 😉

I still think your query has a problem...where is the table with alias b?

You do not need the USE because I fully-qualifed all the table names. The problem is with the SELECTs at the bottom. Try this version, I added a column to...

Daniel H (6/7/2011)

---

Thanks a million!

I was really close on my own. I knew that I could use a CTE and possibly use the row_number() as an "index". I couldn't...

Nice job posting usable DDL, DML and expected results!

This should get you there:

DECLARE @Autos TABLE

(

itemid int

...

That is one way to do it and it is very nice that you decided against using a loop. I suspect there are hundreds of ways to get the task...