Sandesh

Sounds like you're asking us to do all the work for you without telling us what you've already tried.

You have two options. You could import all data into a...

Build your query string dynamically, then execute it with sp_executesql. If you use an output parameter, you can get the result back to the scope of the calling batch.

John

I'd guess it's because it's evaluating all 65000 rows in the WHERE clause - that's about 10000 years with a freq of 2, which is beyond the range of datetime....

Rolf

Yes, looks OK. My Numbers table starts with 1, so you could try adding WHERE Number > 0, but to be honest I can't see how that would make...

The only thing I can think of is that there's some anomaly in your Numbers table. What does this return?

select MIN(number), MAX(number), COUNT(number)

FROM Utility.numbers where number <= 96

John

Does this help, or is there something in particular you don't understand about sp_send_dbmail?

John

Are you really using SQL Server 2000? Works for me on SQL Server 2008. Could be something to do with the way your dates are being interpreted. ...

SSIS is probably the way to go here. Otherwise, create a table with the same columns and data types as the DBCC output, and do INSERT INTO MyTable ('EXEC...

If you're using the query you just put into your original post, that's an INNER JOIN, and it will only show you the similarities, in the same way that INTERSECT...

Yes, I think you just need to lose those parentheses. You can actually shorten it even further, like this:

CASE Fruit

WHEN 1 THEN 'Apple'

WHEN 2 THEN 'Banana'

ELSE 'Cherry'

END AS Word

You...

You can use INTERSECT to find the similarities, or EXCEPT to find the differences. Or you can use a FULL OUTER JOIN if you want to see the differences...

By enumerating...

In that case, please will you post everything you've done so far,...

Ritesh

The package name is just the path and the filename - something like x:\MyDir\MyPackage.dtsx. There are no command line switches. If you need to configure your package you'll...

Ritesh

Just use an expression to set the name of the package in the Execute Package task. That's equivalent to passing in a parameter.

John