EDIT: Isn't that the point...

Jeff Moden (2/20/2012)

---

Honestly, I'm seriously confused. Since you've already identified that there is a way to do this without the use of dynamic SQL, why do you insist on...

Try this:

create table #my_test (myval varchar(300))

go

declare @sql nvarchar(max)

declare @parmdef nvarchar(25)

DECLARE @param nvarchar(300)

SET @sql = 'INSERT INTO #my_test (myval) VALUES(@value)'

SET @parmdef = N'@value varchar(300)'

SET @param = 'test string'

select @sql

EXEC sp_executesql @sql,@parmdef,@value...

Eh... Kind of? That is if the elements of the...

SQL Kiwi (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

Why is your first example not a set? A set is simply "A group or collection of things that belong together or resemble one another or are...

SQL Kiwi (2/20/2012)

---

For what it's worth, I didn't really see what Joe was driving at with his example either. It's pretty easy to do what the OP was asking...

S. Kusen (2/20/2012)

---

LOL- Wasn't the...

patrickmcginnis59 (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

The OP had this:

select

A,

B,

...

It's not a matter of taste. It is that A * B AS C is not the same as A * ...

Was that a pasting error or was that the cause of your update issue? 🙂

The OP had this:

select

A,

B,

...

patrickmcginnis59 (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

SQLKnowItAll (2/20/2012)

---

patrickmcginnis59 (2/20/2012)

---

I'm realise I'm posting in an old thread, but I'm genuinely curious about this and maybe someone can point out what I'm missing.

Now try to...

It should not be an issue if you have the proper indexes. I would think that there should be one on Region, Division, Group. If your data is in that...

Look at the difference between this:

and (case

when CHARINDEX('\', dpi.instancename, 1) = 0 then dpi.instancename

when CHARINDEX('\', dpi.instancename, 1)...

Are you sure this is what you want in your update?

SELECT SUBSTRING('SERVERNAME\NAMEDINSTANCE', 1, CHARINDEX('\', 'SERVERNAME\NAMEDINSTANCE', 1) - 1)

Because this gives the server name in the case of a named instance...