DECLARE @openorder INT

SET @openorder = 2

DECLARE @tbl TABLE (openorder INT)

INSERT INTO @tbl (openorder)

SELECT 0

UNION ALL

SELECT 1

UNION ALL

SELECT 2

--UNION ALL

SELECT * FROM @tbl o

WHERE

...

Crap code too!!!!!!!!!!:w00t:

Lamprey13 (5/6/2011)

---

You can... Not sure why you'd want to thought. Maybe this will help:DECLARE @i INT = 0

WHILE @i <= 10

BEGIN

SET @i = (@i % 10)...

What do you need to do exactly?

DECLARE @I INT

SET @I = 1

WHILE @I < 11

BEGIN

PRINT 'Warning this is an infinite loop'

SET @I = @I + 1

IF @I = 10

BEGIN

SET @I...

You can use this to generate the data.

http://www.red-gate.com/products/sql-development/sql-data-generator/

Or you can do it manually using this exemple :

http://www.sqlservercentral.com/articles/T-SQL/68467/

Go to the section called "Populate the Test Table with Randomized Data".

Option 2...

Rebuild of the index assuming a good amount of page should eliminate it (maybe not 0%, but certainly not 99% left).

Run this to get all the corruptions errors in the...

How can you say a server is not needing 100 GB ram?

I've heard about multi TB dbs. 100GB for that is not overkill.

By the way there must be 50 000 hours of tuning expertise between Gail and I... which you are promptly refusing to use.

So again, good luck. Because you'll need...

Can't help without the plan.

We can do without the code / data but not without the plan.

Use google to figure out how to replace the cursor with set based code.

Good...

tommyh (5/6/2011)

---

As i stands i...

replace select * with the list of columns, then use the stuff function on that column rather than the variable I use in my demo.

Well it's called string manipulation. Why are you forbidden to use those?

DECLARE @a CHAR(6)

SET @a = '123456'

SELECT STUFF(STUFF(@a, 3, 0, ':'), 6, 0, ':')

In the select of your xml...

How about '14:38:25'?

+100

sqlnaive (5/6/2011)

---

I'm not using any UDFs or table variable It's just simple insert as below:

Insert into dbo.TableA

PageId, col1, col2, col3, col4, col5, col6, col7, col8)

select

(row_number()OVER (ORDER BY col1, col2,...