Also, you may want to look at Data Driven Subscriptions. This provides a means of using a query to determine the e-mail addresses to be used as recipients....

I had to rewrite my query to improve it's performance, and once I did that, my problem was solved. However, I think there's a clear consensus that...

It could be a data type problem. Whenever you insert data from Excel, SQL Server looks at some number of rows at the beginning of the data to...

Having never done this myself, and assuming that it must be possible, I would check the BOL to ensure I was meeting it's exact requirements, and see if there was...

Sounds like it may not be configured by default, or it's been intentionally turned off. Check first with your admin/DBA, or if you're it, then you probably need...

How about OPENROWSET ? (look it up in BOL)

Steve

(aka smunson)

:):):)

I'm not sure exactly what you mean by "blowing up". However, I think the larger problem is knowing exactly how you expect things to work. If...

Yes. You can use a "tally table", aka "Auxiliary Table of Numbers". Look up posts from Jeff Moden on creating a tally table. Joining...

Eliminating your WITH statements should be possible by just changing to temp tables from cte's, by replacing each WITH statement with it's INSERT INTO equivalent (INSERT INTO #ctedisks, for example)....

I think you'll quickly discover that using any manner of recordset navigation using Access's built-in methodology will annoy the royal you know what out of you, so I would get...

This topic is making me wonder about a post I put in the Reporting Services forum about Integrated Security. I have no problem deploying reports that use a...

Well, no responses so far... dang... So, I'm now trying to use SERVER_LOGIN within the stored procedure, and it produces results just fine within Visual Studio, and...

Any given control in your report can be tied to one or the other of those datasets. A table or matrix control is only going to be...

Wow... that was too easy... but thank you thank you thank you for saving me the time of having to try and find it when I wasn't even sure where...

What about taking each inner query and dumping the results into a table, even if it's a temp table, and then indexing the resulting tables, then running that plus an...