I would try to go from the basics to the more advanced things to help to determine easier the knowledge and also to give an easy start for the candidates...

Uwe Ricken (8/6/2015)

---

Hallo Wayne,

your measures are not correct because you didn't run the process:

- for each table separately

- with 200 concurrent Connections

Than you will have a HIGH fragmentation on the...

I just thought on giving a shorter solution that uses a tally table.

CREATE TABLE dbo.TestPivot(

CollectionDate DATETIME,

Products VARCHAR(40),

ItemCount INT

);

INSERT INTO dbo.TestPivot

SELECT '4/1/2015','Benz' , 20

UNION

SELECT '4/2/2015','Benz' , -10

UNION

SELECT '4/3/2015','Toyota' , 10

UNION

SELECT '4/1/2015','Toyota'...

As I was reviewing my code, I found a mistake. I'm including a corrected version filled with comments on what the code is doing.

Basically, I'm removing the cursor because...

sknox (8/6/2015)

---

DrKiller (8/6/2015)

---

I got the answer right, but with the wrong (or different?) theory...

I was looking at the size of the CHAR value... I figured that because it is lower,...

TomThomson (8/5/2015)

---

That's crul and unusual punishment; anything involving a gusano (whether rojo or any...

Hot

Eirikur Eiriksson (8/5/2015)

---

SQLRNNR (8/5/2015)

---

Sean Lange (8/5/2015)

---

Or better yet -...

For fixed width, SUBSTRING is the way to go. To reverse the process will be more difficult as you're creating different types of rows that would need validation when importing...

Would it make my summer cooler? It's hot in...

I'm so tempted to say Books...

jasona.work (8/5/2015)

---

GilaMonster (8/5/2015)

---

Snippets and a whole pile of script files saved in DropBox and on a creditcard-shaped flash drive (which I need to update).

And to get back on topic:

"What book...

I'll support what Kevin mentioned.

There's a great room for improvement and I'm sure it wouldn't stop with this procedure as the whole database will have similar problems.

I'd suggest that you...

You could create a Schema and grant permissions to the user on that schema so the user will have permissions to the views on that schema.

Otherwise, you need to grant...

August