You could create a copy of an existing database that has the structure you want to put your subset of data into and then use sp_msForEachTable to delete all rows...

I'm curious to see how people deal with source control issues with sprocs if you're putting your business logic in the database. For example, lets say you create software...

You need to catch the DBConcurrencyException in your C# code. In the catch you can present the user with the new data and the data they entered and let...

DECLARE @details AS VARCHAR(MAX)

SET @details = ''

DECLARE @lineNumbers AS VARCHAR(MAX)

SET @lineNumbers = ''

SELECT @details = @details + Detail + ', ', @lineNumbers = @lineNumbers + CAST(LineNumber AS VARCHAR) + ',...

Nested transactions are supported in SQL Server. The only caveat, if you want to call it that, is that if you do a rollback, it sets @@TRANCOUNT to 0...

It is not really clear what you're trying to accomplish, or why you're trying to accomplish it. A simple query to show what you've given here is:

SELECT ROW_NUMBER() OVER...

Grant Fritchey (7/10/2008)

---

[...]Second, query processing order causes data to be limited first by join criteria and second by the WHERE clause. If you put all the criteria in the WHERE...

if datename(weekday, getdate()) = 'Sunday'

select

case

when Transaction_Type like 'Down Time%'

then Transaction_Type

else 'my hard coded text'

end

from mytable

SSMS can do this as well. Just run the query in a new query window, select all the data in the results panel and copy/paste it into a new...

This definitely wouldn't be one of my "golden...

Thanks for the response Steve. We got a call this morning and it emerged that 'we killed all other sessions' actually meant 'we killed all other sessions - except...