I use EditPad Lite:

http://www.editpadpro.com/editpadlite.html

Wow! Nice trick, Rockmoose!  

If you want to do it for dynamic SQL:

create function Column_CSV (@TableName sysname)

returns varchar(8000)

as

begin

declare @ColList varchar(8000)

SELECT @ColList = isnull(@ColList + ', ', '') + c.name

FROM sysobjects o

JOIN...

The biggest problem I saw with your schema is lack of indexes.  Definitely index the columns that are referenced by Foreign Keys, but I'll bet there are more besides.

cl

The author also says that UDF to UDF joins will be faster than straight joins.  NOT!  If this is occuring you've got some schema/index issues.

cl

exists is definitely better; left join and looking for a null is better then "not exists".

cl

It's more clear when written this way:

DECLARE @test-2 varchar(10),

              @Sentence varchar(50)

SELECT @test-2 = 'System',

       @test-2 = SUBSTRING( @test-2, 1,...

Milo,

You should check the Microsoft knowledge base.  Here's an article about what waittime and waittype mean.

http://support.microsoft.com/default.aspx?scid=kb;en-us;822101&Product=sql

I'm sure you could find more information as well.

cl

Good article.

It's amazing to me how many DBA's know how to create tables and indexes, but they have no idea how to create GOOD tables and indexes.  The first thing a...

Wait a minute; an 8 proc XP machine.  Good God!  I believe the only OS that supports SQL with more than 4 procs is Advanced Server (or is it DataCenter?),...

Alternatively, you could put this in a trigger:

if object_ID('temp_Product') is not null drop table Temp_product

create table TEMP_Product

(Product varchar(255),

ProductCount int,

ProductPerc money

)

go

create Trigger TR_TEMP_Product

on TEMP_Product

after insert

as

Update  TEMP_Product

set  ProductPerc = cast(ProductCount as money)/(select sum(ProductCount)...

The check constraint is going to be more expensive then a trigger, as you have access to the logical "inserted" and "updated" tables (usually in memory).  If you can make the...

Build the string first and then print to the console to verify that they command is correct (or you can use profiler).

string p22 ="hello" ;

string tSQL = "EXEC transact '"+p22+"'";

--Print...

Sorry, I should have been more clear about "capitals in proc".  I meant in the proc name, not in the actual code.

Apparently this is not required, system procs with uppercases works...

Phill,

What do you mean, "fields are manually entered in"?

cl

sqljean,

You should not be using a sub-query at all, and definitely not a "Where IN".  Instead, use a join...

DELETE d

From  #Test_Delete d

JOIN   dbo.Account a on d.MyID = a.MyID