I don't think you actually need to go thru all those gyrations; instead, try this:

;WITH allstores(storeid, doc, article) AS(

SELECT 'ALL', '0010', '001' UNION ALL

...

Looks reasonable to me. I don't see a "better" way.

SELECT

ProjectID,

Project_Name AS [Project_Name|UpdateDescription],

CONVERT(varchar(10), Start_date, 120) AS Start_date,

ProjectDescription

FROM #tbl_projects

UNION ALL

SELECT

...

Since it's only three values, maybe this:

...

,isnull(cast(CASE ca1.COMM_max WHEN 1 THEN COMM1 WHEN 2 THEN COMM2 ELSE COMM3 END*QTY*1.8 as numeric(6,2)),0) as RATE

FROM dbo.yourtablename

CROSS APPLY (

SELECT...

MysteryJimbo (5/13/2014)

---

ScottPletcher (5/13/2014)

---

You have broad control of the frequency of cdc scan processing, and can even customize it if you want. I wouldn't ever want to risk the never-ending...

You have broad control of the frequency of cdc scan processing, and can even customize it if you want. I wouldn't ever want to risk the never-ending maintenance of...

You can't use a standard CHECK constraint, as all values must be available on a single row for that.

You could easily use an AFTER DELETE, INSERT[, UPDATE ] trigger if...

CDC should perform far better than hand-written triggers on all those tables.

Make sure you have sufficient pre-allocated log space to hold the changes until CDC can process them all.

It's testing to make sure that @Num contains only "0"-"9"s and/or "-"s.

Jeff Moden (5/12/2014)

---

ScottPletcher (5/9/2014)

---

I don't understand the rationale...

I don't understand the rationale for that statement....

Sean Lange (5/9/2014)

---

scotsditch (5/8/2014)

---

I'm trying to do something so simple, it's driving me nuts. Especially since I remember doing it before.

I want to create a computed Column in a...

You can use a GLOBAL cursor and use dynamic SQL just to declare the cursor. You can process it in static code, including deallocating the cursor at the end.

T-SQL and SQL certainly are different. I, therefore, would never assume someone knew TSQL just because they wrote SQL on a resume.

TSQL to me would mean the person understood...

By default, yes, they will be stored in the same page.

Someone can, however, override SQL's default behavior, table by table, via "EXEC sp_tableoption" and force SQL to store all LOBs...