VGish (9/26/2011)

---

I have my records like this:

IDDateP_IDP_UUID CM

24842011-07-27 00:00:00.00036926349348432436

24842011-08-08 00:00:00.00036926349348613149

24842011-08-10 00:00:00.00036926349348613151

27262011-07-29 00:00:00.0003406026373248395973

36292011-07-26 00:00:00.0004982026462548392343

36292011-08-01 00:00:00.00049926462548419374

36292011-08-04 00:00:00.0004982026462548535510

36292011-08-15 00:00:00.0004982026462548590566

And I want results...

You're right Sean, apologies are above. That's also a much prettier method then the pivot I was thinking of.

Evil Kraig F (9/26/2011)

---

mw112009 (9/26/2011)

---

Sorry,

It did not work.

Reason: My stored proc is very long. So when it outputs it puts only the code to a certain length. After that...

You need a pivot.

If you'll setup the data and schema to be consumable, I'll actually plug away at the code when I get some time to get it to behave....

mw112009 (9/26/2011)

---

Sorry,

It did not work.

Reason: My stored proc is very long. So when it outputs it puts only the code to a certain length. After that I don't see...

nVARCHAR(4000) vs. nVARCHAR(Max) in the view definitions. It's possible to cut off the create statement...

sqlquest2575 (9/26/2011)

---

Hi...Thank you for you reply…. but not sure if i understood correctly....you are saying that SQL express edition will update to SP4 automatically as soon as windows update happen?...

I would approach this a little differently:

DECLARE @c INT,

@LastID INT

SET @c = 0

SELECT @LastID = MAX(ProductUID) FROM Product

WHILE @c <= @LastID

BEGIN

UPDATE Product

SETProductID = 'XY' + ProductID

WHERE

ProductUID Between @c AND @c...

mw112009 (9/26/2011)

---

I like the idea of using a variable ?

Ahh but you are sayng to load that variable I will have to use some special sql that will output the...

Depends, can you script and paste your schema here? It's gonna depend on your available keys and indexes.

I spent the weekend as a 'lost weekend'. My hydration is still recovering. :doze:

From this page:

http://support.microsoft.com/kb/913089

Important notes for using Microsoft Update

•When you use Microsoft Update to install SQL Server 2005 SP4, the installation is unattended unless components are clustered. If components are clustered,...

There is another option. Use a package scoped string variable, and load that variable as the result from a T-SQL query that calls the definition from sysmodules.

Then, in the...

rbuzzard1 (9/26/2011)

---

My concern is that I don't want to cause the transaction log to expand during the transaction. It's currently set to Full. What is the best way to go...

You're going to need a delta mechanism, either an audit table with the pk and datetimestamp, or adding in a datetimestamp column on the main table. Or build out...