Just to make sure, the answer to your question 2) is No.

I suppose you have some large varchar/nvarchar columns. These are of variable size, and as long as you don't...

Why not display the dates as 2007/01/27? Is that such a big issue to show the dates in YMD format?

General tips? Well, especially if cursors are used as often as you describe, be very careful. Some of the other functionalities, that don't include any cursor themselves, may rely on...

But you didn't mention DISTINCT in your original question... does it mean that the sp is actually different than what you posted?

Helping you would be easier if you post...

Tom,

I can understand your position (although I don't agree), and I also know that there are certain situations where you simply have to use cursors (sometimes because the database has...

Will no one ask THE question ? No? Well, then it is up to me : Why do you use cursor? Is there something...

It can be even nicer, without any IFs - COALESCE function takes care of the delimiter and will not place it at the end of the string:

CREATE FUNCTION fn_ConcatStrings (@ID...

It isn't as bad as sewage 🙂 it is rather the other end of production chain - it means raw material, or simply a substance, that is used as starting...

Hi Emma,

that's a nice name you have :-). Do you mind if I ask where it came from? Somehow can't imagine why anyone would choose "raw material" as a name...

Hi,

I'm no expert at all when it comes to cursors, but there are a few things that you could try to change. Maybe some of it will help... if not,...

There are no parameters that can be used for objects (TABLE, INDEX, VIEW - whatever), you always have to name the object directly (can't use a parameter that holds the...

Hello,

the problem with your question is, that you ask how to achieve certain things, but not why do you want it. Generally, requirement to get some values one by one...

Search BooksOnLine for RESTORE DATABASE. If you have tried to restore the database, it didn't work, and you can't find answer in BOL, please ask again and specify what the...

It isn't how often this particular query will be used. Problem is that you use one column in the base table to join to several tables - based on value in...

Sorry, Best, but you need to help us first if we are to help you. No structure, no sample data = no help. You should understand that it is impossible...