GSquared (5/20/2008)

---

lfmn (5/20/2008)

---

GSquared (5/20/2008)

---

If you build the string this way, you don't even have to remove a final comma.

declare @String varchar(max)

select @string = coalesce(@string + ',' + cast(ModuleID as varchar(10)),...

GSquared (5/20/2008)

---

If you build the string this way, you don't even have to remove a final comma.

declare @String varchar(max)

select @string = coalesce(@string + ',' + cast(ModuleID as varchar(10)),

...

Sauron J. Terrill (5/20/2008)

---

As long as you're selecting just that one column to concat, there's a trick that I believe is specific to SQL Server:

declare @table table(identifier int identity(1,1), ModuleID...

Thanks to everyone for the good advice!

GSquared (5/1/2008)

---

Which solution are you asking about? Steve's use of datepart in the...

Thanks. I'm concerned about performance. Do you know if this solution would out-perform the convert function?

I would do the following (after 2 days of cursing upper management)

1. Ask management for a quantifiable list of objectives they wish to accomplish. If they won’t provide one, make...

Thanks for your input. I'll be sure to read your article.

Thanks for your input. I'll check out that article.

Thanks for your input.

Bravo.  I'm standing on my desk applauding. I especially agree with one point - "we get paid to solve problems." Most clients don't care if we write "elegant" code. They...

Thanks to all for your help.  This is what I thought.

That was all that was in the book. I've never read anything else on the issue (although I've looked). Most of what I've found has been opinion rather than...

One source for binary sort order being faster is Microsoft SQL Server 7.0 DBA Survival Guide by Spenik and Sledge. Page 92 - 'Binary sort order is the fastesdt...

I may be one of the few that new I wanted to be a DBA starting in college. I went back to get my CS degree at the advanced...