sgmunson (11/4/2016)

---

And here's an alternative that achieves the desired output (however conflicting with the original post that may be...), and shows the performance characteristics, as I'm guessing this sample data...

ChrisM@Work (11/4/2016)

---

This also matches the somewhat ambiguous and vague requirements:

;WITH SAMPLE_DATA(Client,fields,value) AS

( SELECT X.Client,X.fields,X.value

FROM ( VALUES

...

sgmunson (11/4/2016)

---

Your output misses Client 111, who does meet the required conditions. However, the original poster also has stated output that disagrees with their initial statement, and I've asked...

sindhupavani123 (11/4/2016)

---

My output should look like this:

Clientfields value ...

GilaMonster (11/4/2016)

---

Eirikur Eiriksson (11/3/2016)

---

GilaMonster (11/3/2016)

---

Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going...

Tommy 70494 (11/3/2016)

---

But so far, I've come up short with how to shred the XML correctly, so i can search the package definition of my list of tables. Of which...

You are very welcome.

😎

psred (11/3/2016)

---

I need to test DB compression where the SQL DB on SQL2008R2 is taking around 2TB and most of the data is XML files. So I want to test...

GilaMonster (11/3/2016)

---

Neither page nor row compression will compress LOB columns (like XML), so it's not as easy as just ALTER INDEX (and the sp_estimate_data_compression_savings is only going to estimate savings...

Can you post the full DDL, including all indices, the typical usage etc. and particularly the reason for this table being so large. Normally such a large table would be...

abhas (11/3/2016)

---

Thanks Eirikur,

your code works fine, but while inserting into TEMP_USER table, after creating username, getting issue. For first time insert it works fine but if next day again 'aarav...

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(NUMBERS) AS

( SELECT CONVERT(VARCHAR(7),X.NUMBERS,0)

FROM ( VALUES

('1.22345')

...

Head-desk

😎

scottlackey2001 (11/3/2016)

---

is there a way to loop through rows without using a cursor? I can select my rows into a temp table and all, but need to loop through...

scottlackey2001 (11/3/2016)

---

I've got a DECLARE CURSOR and I wish to loop through and process rows that meet certain criteria. I want to use a WHILE loop to process such...