This is a hard one to call.

If I read your post correctly, you are saying that the bulk of the queries you are running are for date ranges. This being...

By report, what do you mean?

What application is generating the report and what format is the report in.

Sounds like an application problem rather than sql

Thanks wlawton. I think you're right about one sp logging and alerting and maybe that was where my friend saw it.

However, I was thinking that one sp could conceivably be...

Tried a few combinations and finally found it.

Syntax is:

App=application_name

No spaces between the equal sign. I tried this in a vb package and ms access and both work.

In order to process a cube, you must first process the dimensions. I start with the rule of processing shared dimensions first, non-shared dimensions second and the fact table last.

In...

If you need a site concentrating more on design isuues rather than the physical building side, you might want to take a look at;

http://www.rkimball.com/html/articlesbydate.html

Ralph is seen as the guru of...

Quick and dirty but it works.

Run an insert query to insert the value of the variable into a temp table every time the variable is set and select * from...

Don't forget those indexes. No point in building the best application in the world if runs like a pig.

Get the right indexes in the right places set at the...

I think there must be something wrong in either your code or the stored procedure. If you are using a stored procedure you must use BEGIN and END. The count...

This site is great for getting ADO connection strings to multiple dbs.

http://www.able-consulting.com/ADO_Conn.htm

A better one for applpication name is contained in:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q193/1/35.asp&NoWebContent=1

Hope either helps.

You are not likely to be able to do this in excel. I have never found a way.

Check this site on info you will need to perform the action in...

If I get you right, you want something like this in a stored procedure:

/* CREATE TABLE AND INSERT VALUES FOR TEST*/

CREATE TABLE TABPERF

(INSTRUMENT NVARCHAR(100),

PERFORMANCE INTEGER)

INSERT INTO TABPERF VALUES ('AAA', 100)

INSERT...

I found the following site and have implemented it to import a text file dynamically. It enables me to set db location as well text file name change etc.

For example,...

Just a shot in the dark here.

Are you trying to write the outcome of the job to a log file. If so, it may be storing the data in the...

Thanks for all the ideas. I found that I will have to split the job into two applications. The embarcadero tool is great for the sql side. On the application...