Email SP Results

Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.

Magic 8 Ball

This script creates a stored procedure that mimics a Magic 8 Ball

The Data Center that Exploded

A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!

Binary

Monty Hall Paradox

Script to test outcome probabilities of the "Monty Hall Paradox".

RE: Convert table into a crosstab table in SQL Server

Nivedita: This query does work.   Thanks for your help.

RE: Convert nvarchar column to varchar

Less space used sounds good to me.Can I take it that you ran no other procedure to recover this space?

Freeware: Tablesizer

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/products/tablesizer/

Storing the output of a FOR XML EXPLICIT in a table?

Hi all,I am trying to store the output of a Select statement with a FOR XML EXPLICIT back into the dbase. Is there any way of doing this? Here is a simplistic view of the SQL on my attempt. Thanks CREATE TABLE #Members (UserNo int NOT NULL PRIMARY KEY, Phone varchar(50) NOT NULL, Email varchar(50) […]

??? SQL Server 2000 leap year date comparision problem ????

Hi,A greenhorn questionTry below: create table t1( d1 datetime, d2 datetime)insert into t1 values('20040101 00:00:00.000','20040131 23:59:00.000') insert into t1 values('20040201 00:00:00.000','20040229 23:59:00.000')select * from t1 Result:2004-01-01 00:00:00.000                                2004-01-31 23:59:00.000 2004-02-01 00:00:00.000                                2004-02-29 23:59:00.000THEN TRY:select * from t1 where d2 <= '20040229' Result: 2004-01-01 00:00:00.000                                2004-01-31 23:59:00.000If you try :select * from t1 where convert(datetime,d2,101) <= convert(datetime,'20040229',101)it will […]