Rayven - thanks for the input. I'm going to give it a try over the next couple of days and see how it works. You said there's some...

I have a similar situation that I'm working on right now. The parameter I'm working with doesn't hit just one column in a where clause though. It's a...

I'll say it upfront, the code below works to an extent but it's not good. It will break if you have more than 2 attributes separated by a comma,...

Oh man, I really hate these types of designs. Retrieving this type of information should be pretty easy but because of the way it's structured it ends up being...

Just be 100% sure your select will only return 1 row. If it returns more than 1 it won't throw an error like the set clause you're probably more...

Not that I'm aware of. I assign variables in a select statement if I'm working with multiple variables that can be retrieved in one pass. If I'm assigning...

I've had to do this type of data scrubbing before. It can be a nightmare. I was able to take care of a lot of my problems using...

Lutz - will doing that break the xml structure at all? I had a requirement to add the encoding header to an xml file and I did it just...

Is that Oracle sytax? Someone can correct me if I'm wrong but I don't believe this is valid sytax "referencing new as new_name for each row". New to...

Curious to know what ever came of this. Hopefully Rambler can give us an update.

See if one of these links helps you.

http://msdn.microsoft.com/en-us/library/ms191184.aspx

http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx

Makes sense. I do this every so often when I want to test something on my local machine and have never had a problem with it.

Can you detail the steps you took before the restore and which versions of SQL Server and service pack levels you are on? I'm curious of this. I've...

brendan woulfe (1/10/2012)

GilaMonster (1/10/2012)

JagWalia (1/10/2012)

Q. Which of the following statements can be used to provide sorted result set based in the CustomerName column?

A. SELECT ROW_NUMBER() AS RN, CustomerName from Customers...

GilaMonster (1/10/2012)

JagWalia (1/10/2012)

Q. Which of the following statements can be used to provide sorted result set based in the CustomerName column?

A. SELECT ROW_NUMBER() AS RN, CustomerName from Customers order by...