Edited orig post for clarity.

You guys are off topic. The question is whether adding the PK (also clustered index) to a new index is superfluous.

So I was just able...

Even cleaner - Nice!

Thx MM

Nevermind.

Solved:

RIGHT() is supposed to return varchar. The concatenation fails with char(2) but works when using varchar(3). I thought it would use it's own internal varchar variable to do the...

fantastique!:-D

So much cleaner. Thx!

How do you give rep around here!?

Steve Hoyer (6/17/2011)

---

I'm working on a query that's returning about 45 rows and most of the rows are combinations of other fields in one way or another, so most of...

--Using ColumnName in WHERE clause returns expected results

[alias] = ColumnName

FROM dbo.TableName

WHERE ColumnName > val

-- Using an alias in Where clauses returns empty rst - NOT expected

SELECT

[alias] = ColumnName...

Jeff, thank you for taking the time to answer. 🙂

I suspected that there would likely be some overhead involved. And thank you for the links, I'll check them...

Thanks Craig.

JM

same problem here. Ever figure out what the issue was?

My queries run fine, pulling data from the linked server, except where there is a funtion call.

"Msg 207,...

Jeff Moden (1/1/2009)

---

gryphonsclaw (1/1/2009)

---

You don't have to use a cursor to concatenate a string.

DECLARE @myVar varchar(MAX)

SET @myVar = ''

SELECT @myVar = @myVar + mycolumn + ' '

FROM myTable

SELECT...