Lynn, I'd like to disagree regarding "no reopening a previous tab".

There are tools out there (e.g. RedGate's SQL Prompt -> advert intented 😉 ) that'll allow you to save, search,...

duplicate post. no replies please.

Use the original post instead.

But this query doesn't return the result set as requested since there's a TOP 15 involved for each group...

I agree, Kevin.

But if the OP really want to "force" the data to stay in memory, one way could be a dll that would query the aggregated data and keep...

See Phil Factor's article[/url] for detailed examples of different ways to export to Excel.

Do you need to physically save the file or just to mail it?

If the latter, have a look at sp_send_dbmail.

You'll need to loop through the userID's and send the mail...

isuckatsql (5/2/2014)

---

Kevin,

You are correct!

I am not sure on the best way to do this.

Based on the Microsoft Outlook scenario, i assume you would need one SP for each...

This is more than a vague question...

What do you mean "save by userId"? Just the sort order within a Excel worksheet? An additional line between each userId to separate it...

One-timer: Adda filter to the EXCEL section, filter out empty rows (for every 2nd column) and copy the relevant cells (CTRL +C, CTRL +V).

Permanent Process: Copy the table to a...

There is no "initial" value. See this link for a syntax description.

The handle is a system generated int value to uniquely identify the statement. The handle is not

You can...

Cross post.

Discussion already started here.

Please check the settings for

linked server properties -> security options -> query timeout

and

SQL Server instance -> connections->remote server connections -> remote query timeout

and compare it to the query processing...

It doesn't depend on the SQL Server setting but on the setting of the date format setting at the point the INSERT statement.

It is influenced by the following settings:

SET DATEFORMAT

SET...

On what SQL Server instance did you install the Adventure Works database?

How can we provide a step by step solution if you don't provide us any information except "I cannot...

Since you obviously simply don't like the alias v_userpro I provided a solution that doesn't use it at all.

Please note that it is absolutely equivalent to what I posted before...