But be careful if your INSERT..SELECT..UNION ALL... statement is very big or your transaction log is very small.

John

Are you using the /3GB switch in your boot.ini file?

John

Please post your code.

Thanks

John

I think a better way would be to store the results of sp_helpsrvrolemember into a temp table, then LEFT JOIN syslogins to that so that you also get logins that...

OK, hopefully this should get you started. Please post again if there's anything you don't understand.

You can use ROW_NUMBER or RANK (read about both of them and decide which...

You're going to have to try harder than that if you want any of us to be able to help you. Please show us what you tried, and state...

Romakanta

I'm confused - you say VehicleID is unique, and then you say there are duplicates. Also, the word "consecutive" only has any meaning if you define how the rows...

You will need to use a LEFT JOIN so that you get all the logins, and not just the ones with server roles. The query you have written will...

I assume @parameter is a comma-separated list, or something similar? If that's the case, see Jeff Moden's article on "Numbers" or "Tally" tables for a solution to this.

http://www.sqlservercentral.com/articles/TSQL/62867/

John

bcronce (5/7/2008)

---

Here's a question. Would overall performance be better when joining on a dept id vs name because of the comparing of int vs string? I would assuming other tables...

There may be a better way, but my first instinct would be to use CTEs (or further temp tables) to show (a) distinct combination of salesman and week (b) property...

And if, as you seem to suggest, the application only runs SELECT statements, deny INSERT, UPDATE and DELETE permissions to the login the application uses.

John

Integrity is more important than shaving a few milliseconds off your processing time. With your current design, what's to stop someone inserting a row such as this?

Corporate ...

Sorry, you're still not clear. What do you want to update the prices to? Do you want to update the price in all 5000 rows, or just those...

Try turning the subquery into a derived table and joining to it.

John