I'm afraid this will be a problem. You can't parse strings automatically with that much variability - and I suppose this was just an example. There can be various abbreviations...

On the other hand.. it is so common that probably no-one realized that this is what you were asking :-).

If you want to execute part of the code, not all...

Hello Tom,

it may have worked in your particular environment, but I don't think it is a good idea to post this trigger in an article... unless it is an article...

Well, now this is very different from the original post... the original post contained GOTO inside of a SELECT (that is, between SELECT and FROM, actually you were trying to...

Hello,

I read all the posts twice and there seems to be some confusion on both sides :w00t:

Main thing the we need to know is how do you wish to treat...

Well, you have to keep in mind, that you are inside of a select... so you can hardly jump somewhere else (GOTO). You can do that between two SELECTs, but...

It is possible to make...

Actually, it seems to me that what the original poster wanted could be more appropriately defined as random ordering than generating a random number.

- there is a predefined set of...

Hi,

to your question "For example, i have 3 rows inserted, does it mean that i = 3 rows and the SQL is inteligent enough to retrieve row by row and...

Hello Natalia,

the problem with your code is probably in the parenthesis. You could try to call your procedure with parameter like that:

EXECUTE DeleteRows @ItemName=@name

instead of EXECUTE DeleteRows(@name).

As others have remarked,...

Hello,

unless you give us more info, probably the best answer we can give you is to read about shrinking, especially "Shrinking transaction logs", in BOL. You didn't say anything about...

As far as I can understand, it is something like calculating totals of an ordered set (ORDER BY date), where the desired result is that row of the original table...

Ben,

I don't think we are making it too hard 🙂 - your solution is almost identical to this of Hari Sharma. The only difference is use of INNER or OUTER...

I'm sorry - I think there is no solution that would meet all your requirements.

- if trigger is enabled, trigger will fire on any delete; if trigger is disabled,...

Basically, this problem is very similar to the one solved here:

http://www.sqlservercentral.com/Forums/Topic520209-338-1.aspx

You can get the result you need with the following query:

SELECT t.UserID, t.TestID, Q.Questions

FROM Tests t

JOIN (SELECT TestID, COUNT(*) as...