Sounds like you are trying to track changes?

My first thought would...

Here's a thought... though I don't know if it's advantageous in your environment.

What if you created local temp tables (or table variables) in a sproc and loaded single values or...

There are a few good articles on why it is a good idea to use surrogate keys. As to the how, I would recommend using a staging database. I am...

Okay, I am having trouble understanding the why of your reference code as well, so here is what I did:

SELECT run_time

, run_time/10000 AS run_time_hours

, (run_time%10000)/100 AS run_time_minutes

, (run_time%10000)%100 AS...

With SSRS 2005 you can create reports that load from cached data, and create scheduled subscriptions to create the cached data. Knowledgable users can get around this, but it is...

Can you please clarify what your after? Are you trying to get a report of start and end times? Average durations? What?

Thanks,

MentalWhiteNoise

rbarryyoung (7/30/2008)

---

MentalWhiteNoise (7/30/2008)

---

hmmm... interesting concept. "SQL Brain". I wonder though, instead of storing facts, could we (if given infinite processor and infinite storage) create a database that mimics the structure...

SQL Server is a robust RDBMS. There are SEVERAL programming components that can be arbitrarily placed in either the stored procedure or the compiled code. The question is not should...

hmmm... interesting concept. "SQL Brain". I wonder though, instead of storing facts, could we (if given infinite processor and infinite storage) create a database that mimics the structure and workings...

Sorry, missed the "DTS" part... this is a much simpler query:

SELECT 'dtutil /DTS ' + [name] + ' /COPY FILE;c:\LocalDTSPackageFolder\' + [name] + '.dtsx' AS SqlToCentralFolder

, 'dtutil /FILE c:\LocalDTSPackageFolder\' +...

Another option is to script the packages into import or export commands and execute the commands (you could use output to save to a text, or run an ssis package...

Why not the following:

select PolicyID,

sum(amt) as tranamt-- over (partition by policyid) as tranamt

from (

select

policyid,

premium as amt

from policy

...

What are you trying to get? It looks like you have a policy table containing a default amount, and then a policytrans table containing what, a transaction specific amount? A...

Just out of curiosity I asked my friend google about .dat files. Check out http://www.fileinfo.net/extension/dat for a general discription. Basically, a DAT file can be anything from a...

I have begun playing around with tuning... my understanding of the execution plan is a little limited, but I was hoping that an elapsed time difference by a factor of...