It's because Excel thinks it knows what you want: so that even when you ask for...

Try this. Thanks to Jeff Moden (and probably others) for the compounding CTEs.

WITH E1(N) AS (

...

I've had a brief look into my crystal ball, but for some reason it won't show me the query which you have used, nor the data in your source tables.

It...

whereisSQL? (8/11/2013)

---

I have an excel sheet being imported with 8 columns. One column (say name)has comma delimited string.

Difference with most other posts.. is that the 1 column that has the...

Presumably the students are not using SSMS as their input tool.

Whatever front end they are using should perform this validation either by calling appropriate stored procedures or executing the...

You could try outputting to a CSV file and then importing that.

Great.

mrichardson 57577 (8/7/2013)

---

Can anyone help with this please?

I am trying to count all users in a table who are superusers (only if there is more than 1 super user).

TABLE: 'SuperUs'

FIELDS:...

Jeff's original suggestion (optional parameter to the stored procedure) really is the way to go here. I can't understand why you would choose the convoluted alternative over it.

Use a reporting tool. This...

Eskandari (8/5/2013)

---

The basic problem is this:

Consider the case that we are looking for a particular term, for example, the word network.

A word can be located anywhere, such as the subject...

Erland Sommarskog (8/5/2013)

---

No, that old syntax for RAISERROR (which has been deprecated since SQL 6.0 released) does not work in SQL 2012 in any compatibility mode.

Ironically, SQL 2012 includes a...

Please...

Mike Dougherty-384281 (8/5/2013)

---

zerko (8/4/2013)

---

Select * From Employee /*

Update Employee

Set LastName = 'Smith'

--*/

Where LastName = 'Smeith'

So I can now write quite a complex update statement if needed, it's protected in...

Have a look here[/url].