checksum

Using the CheckSum Function - SQL School Video

There are times that you want to determine quickly if any data has changed. Brian Knight shows how checksums can be used in T-SQL.

RE: Concatenation within Stored Procedures

I already answered this question under your other post.

RE: SQL Table Changes and Who

You could set up a trigger to output details to a table of whose process is running although not the specific stored procedure or application. The following from BOL : This example returns the process ID, login name, and user name for the current user process. SELECT @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER […]

RE: Web Cube

Thanks a lot Jim, I'm very thankful One more thing: By company politics we only have office 2000 (and Office 2003 seems not to be here prior to 2005). Do you know if is there a way to install OWC 10 in Office 2000 (wihtout using Office XP/2003)? Using Office Update only get up to […]

RE: summarizing two tables into one table

Hi wenny,you can also use a full outer join like thisSELECT  distinct   CASE  ISNULL( t2.[name],'')  When '' THEN  t1.[name] else t2.name   end AS name, t1.feb, t2.March FROM         t1 full OUTER join                       t2 on t1.name = t2.name you should compare speed if the two tables are large.Cheers,John R. Hanson

RE: FOREIGN KEY on Temporary Table?

Interesting!http://lists.isb.sdnpk.org/pipermail/comp-list/2003-January/001741.html

RE: installing SQL server

Thankyou sooo much for your help, I am sure I will be back to ask more questions as time goes on.

Suggestions on processing result set in T-SQL

Attempting to get column name from varchar staging table and data type from target table.Query works, but need ideas on processing rows returned to select IsDate, IsNumeric .. based on data type.select is1.column_name, is2.data_type from   information_schema.columns is1,        information_schema.columns is2 where  is1.table_name = 'StagingIn and    is2.table_name = 'Target' and    is1.column_name = is2.column_name and    is2.data_type <> […]

RE: Is this possible in a view

If prepared sql/string executes wont fit the bill, how about: set rowcount 10000 <do query> set rowcount 0 Or if you have to have this logic in a view/udf instead of a stored procedure how about using case statements and including logic for usage of any or all fields in a UDF? The below example […]