Brandie Tarvin (1/15/2015)

---

Koen Verbeeck (1/14/2015)

---

Make sure you have a good grip on the new window functions introduced in SQL 2012.

And you know, for some reason MS still likes to ask...

ChrisM@Work (1/15/2015)

---

or resolve it in the string:

+ '

FROM employee m

LEFT JOIN shiftdetails b ON m.empno = b.empno

where b.shifttype = ''' + @shifttype +

''' GROUP...

Raymond van Laake (1/15/2015)

---

Hey,

Since SQL2012 MS changed something with the identity column; after a restart the value jumps with 1000 (for INT identity column). This is an undesired "feature" for...

Since you are using dynamic SQL in your sp, you cannot simply use the parameter @shifttype, because it is not known in the execution context of the EXEC command. In...

Right-click database, go to "tasks" and then "generate scripts".

There you can script everything out.

OK, glad you got it solved.

It goes through C.

It loads data from A through the network into the memory of C, and then sends it through the network to B.

If you use a data flow...

Try filtering in the data set itself. What is your source?

Make sure all users are disconnected from that database.

Even yourself 🙂

Close all open query windows, and then use sp_who2 to check if there are still connections to that database.

If there...

Interesting question, thanks.

Grant Fritchey (1/14/2015)

---

Steve Jones - SSC Editor (1/14/2015)

---

Grant Fritchey (1/14/2015)

---

Back on topic for a moment.

Maybe I'm in a weird head-space at the moment, but it seems like the questions have...

Sean Lange (1/14/2015)

---

Koen Verbeeck (1/14/2015)

---

The question of today wasn't...

Sean Lange (1/14/2015)

---

Koen Verbeeck (1/14/2015)

---

Sean Lange (1/14/2015)

---

Charles Kincaid (1/14/2015)

---

Great QOD Steve. I would have not thought that this would have that many issues.

Seems that COUNT() does some fun things....

Make sure you have a good grip on the new window functions introduced in SQL 2012.

And you know, for some reason MS still likes to ask XML related questions...

The question of today wasn't bad at all. A...