Leo.Miller (6/8/2011)

---

As has been mentione the answer to the first...

Jeff Moden (6/8/2011)

---

-1000 😉

Why all the FUD about xp_CmdShell? Done properly, it's an incredible...

Cool, I am always happy to lend a hand in the eradication of a cursor 🙂

Mine handles schemas now but I stopped short of (actually backed out of the...

Lowell, we all agree they are acceptable for system maintenance however there is no need to use one here so I'm just as happy having one less cursor in the...

James A. Lawrence (6/8/2011)

---

I have a table with the following data:

A_Pfxa_policyA_DATE_ADDEDA_PROCESSDATEA_NUM_PROCESSEDEndRReq CertPremaud AudDisp

GL69269509/15/200908/16/20090 ...

You are on the right track. You can cascade CTEs as well. See of something like this works for you:

WITH StockSafety_CTE(ITEM, BU, Sub_Family_Desc, Sub_Family_Code, Current_ABC, CURRENT_ABC_WEEKS, Last_months_six_months_forecasts,...

To expound on what Suresh said, yes, you can, however when logs are applied no users can be connected to the...

Depending on your requirements regarding tracking historical changes to the data either Change Data Capture or Change Tracking could be a good fit. Both are configurable at the table-level.

Jnrstevej (6/8/2011)

---

Right i understand it perfectly now I just need to incorporate the caluculation in the StockSafety_CTE section of the code not add another CTE brilliant. Thanks alot for the...

Awesome, thanks. This code demonstrates how you can create the Current_Stock column.

WITH StockSafety_CTE(ITEM, BU, Sub_Family_Desc, Sub_Family_Code, Current_ABC, CURRENT_ABC_WEEKS, Last_months_six_months_forecasts, Standard_Cost, A, B, C, D, E, Current_ABC1, Current_six_months_Forecast,...

Not directly, just in some analysis. I am evaluating an ETL system where data store tables that are directly queries by users and are actively accepting new data nightly are...

I think I found it but it was not as easy as I expected to find. From this article it looks like a physical RID occupies 8 bytes: [2 byte...

Sure, could you kindly post DDL for your tables and DML to add your test data? If you're not sure what I mean please refer to this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

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....