Hrm... I using this in a sproc to gather data from other servers, but it doesn't like using a variable as the server name:

SELECT @version=version FROM OPENQUERY(@SERVER_NAME,'SELECT @@MicrosoftVersion / 0x01000000...

Good catch! And this works, thanks.

Oh no, I'm not programming anything... just something I wanted to find information about. And since all the forums I belong to are sql centric, I didn't really have many...

Very sneaky UMG Developer. That's a very hot solution. Right when I thought I knew a cool trick someone one-ups me.

ewwww... Crystal Reports. Fair Enough, Russ.

Hey russ,

this is a pretty common question, with several different solutions. Why exactly do you need to concatenate all the rows on sql server? Typically this is something done on...

I'm *mostly* certain you're right. I'll check with some co-workers. This isn't my forte.

I'm surprised noone else has responded yet.

I never thought about anything like this before.

Is there a way a query batch can trigger a process in another thread of the server? Ie - rebuild an rss feed...

WanyeS, your link looks broken. I also couldn't find the BOL NULL page myself.

The wiki page is a pretty good read though -> http://en.wikipedia.org/wiki/Null_(SQL)

Depending on the size of your project and what exactly you're using the information for. However, handling of NULLs should be a common, and expected, practice. Furthremore, you don't want...

I'm a little less than a year into this whole DBA mess and I'm only a college intern, but titles that come to mind:

DBA Liason to Development team

DBA Development Coordinator

But...

Sweet. Thanks.

edit: Narrowing the error more:

Anyone know how you're supposed to enumerate an attribute list?

Also, everytime I post XML it disappears in the post, and I have to search and replace...

I haven't worked in the field that long, I'll take your word on the inability of others to use their heads. We're in IT, we're not the users! I wish...

My mistake RBarryYoung, I tackeld the wrong argument.

Preaching the evil of cursors then using them yourself for particular instances can be a mixed message for neophytes. I'd say if you...

I'm going to have to side with the cursor argument on this one.

A one time use/db script probably isn't going to take the server down.

The probability of overfilling an nvarchar(MAX)...