The query probably can run much faster, we can help you tune it if you provide the information we need.

We need the DDL scripts, with sample data in a ready...

What you are referencing seems to be a named instance, by which, you can install multiple instance:

MachineName/InstanceName. Therefore, when you installed your sql server, you must have specified a named...

Damn, I felt Jeff almost got a Heart attack :w00t: Are you sure there is no way...

Sorry, I read your post again, and you made it clear you wanted to select from another table.

In this case, you have to add parenthesis around your select :

SELECT TOP...

tnocella (3/4/2010)

---

I'm trying to use a case statement, and inside I need to have a BEGIN and END with multiple statements, but I can't seem to get it to work:...

1.How many parameters can there be in the table (there is 10 right now). Can we have more, or less numbers in the table?

2.How many of these parameters must be...

Happy it helped,

Have a nice day,

You did not post any DDL information, nor sample data, so I cannot test it, but here's a shot in the dark...

This should work:

SELECT rim_no ,

...

I agree with Wayne on this one, if you want to use the same plan, sp_ExecuteSQL is the way to go. And if you want different plans based on certain...

Thanks Peter, it makes sense that limiting the number of rows in the tally table makes it faster. I'm just surprised the "Where len(value) <= tally.N" did not make it...

I have a weird behavior when using your stripping function. Seems the weird triangle in the third example translates to a question mark... I'm not sure of that behavior, maybe...

Nice Lowell, very interesting stripping function you got there, thanks for sharing.

I'm not sure about the "like" you have used, I use like a lot, but never used it to...

You don't assign any values in your update statement, that is why it's wrong..

Lookup BOL to see how an update statement is done, you have to assign values to each...

This is exactly what the "Row_Number()" function will allow you to do, read it up in Books Online.

Lookup Row_Number() in Books online, it is what you are looking for.