FYI, "SELECT...INTO" need to be used when the table is created dynamically (not know the table exact structure before runtime), comparing to "CREATE TABLE" or "INSERT INTO". "SELECT...INTO" will perform...

Sorry for the mistake above. Here is the new statement:

select count(*) from (select count(*) as total from table_name group by col1+col2+col3+col4+col5) a

Regards,

kokyan

Why not try this. Group by is more efficient than distinct:

select count(*) from table_name group by col1+col2+col3+col4+col5

Regards,

kokyan

Thanks gljjr. I test your method out and it works. I rather use this method comparing to backup MSDB database and restore to production server because the production server also...

Store proc cannot reference to INSERTED table at Trigger. INSERTED table will not be identified outside of the scope of the trigger itself.

One of the methods is using Temporary...

You can just go to Query Analyzer and go the table which have the trigger. Expand the "tree" and you should see "Triggers". Expand more of the "tree" and you...

Thanks for all the reponses. I just want to highlight the bugs in Enterprise Manager of SQL Server 2000. Actually, I seldom use the features of EM GUI.

Regards,

kokyan

Then, any settings need to configure? For your information, my SQL Server version is:

SELECT @@VERSION

Output:

Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 ...

Try to use Enterprise Manager GUI to insert the record. I also successful insert records using Query Analyzer.

Thanks for the method. It works!

Thanks for your reply. I had tried this method before but seem do not work. Do the ALTER command alter the temporary table out from my current session? I really...

Use ASCII to get the range of characters, e.g from A-Z and a-z. Here is a User-Defined-Function (UDF) that use to check whether the string is consists of valid characters.

CREATE...

You can also check with ISNUMERIC inside a loop (loop through the characters in the string). If not numeric, then replace with the charaters you want.

Another method is checking...

The main question is why you want to cut-off the trailing zeros when you declare the variable as DECIMAL(10,5)?

You can pass the parameters into the store procedure by using global variables.

Click on the properties at Execute SQL Task.