Ok... took about 40 hours to figure out the problem. Basically, the foreign key relationship between the table I was inserting to and the "parent" table were being violated (due...

I ran some of the speed tests using the SQL code from the article and I do not see much difference in performance (time-wise) in the queries... but the logical...

My experience with doing restores and permission problems with "EXECUTE AS" is where the database is coming from. If it is from a different server you have SID mismatch. Try...

There was a great script developed by Shivaram Challa, http://www.sqlservercentral.com/scripts/Administration/63841/, which I used to get a listing of all DBs (i.e., mappings) for a individual user.

You can...

I do not believe you can do a count on an aggregate function, i.e, COUNT(MIN(si)). I believe the data would have to be broken up into seperate results then a...

For my example data, the final result would look as follows:

ArchivedDate 3 Week Average

3/18/200933,573

4/7/2009 ...

I was going to try to get the MAX(CONVERT(varchar,Archived,101)) as the Date and the 3-week average.

I could do this programmatically (either via cursor or cursor-less), but that is a...

The problem is you are doing a RIGHT OUTER JOIN on #temptable, so Incident_ID 101 will never get touched...

CREATE TABLE #temptable (Incident_ID int, [Name] varchar(4), Date varchar(10), NotifyDFS varchar(3),...

As a general rule, I typically will run the query as a SELECT statement to ensure the records being returned (or modified) are correct before converting the query to an...

Easy enough to generate the data... as for the "beginning" date, it would be a rolling three-month time period from todays date....

WHERE Archived > ''+GetDate()-90+''

DECLARE @Hist TABLE (Seq INT...

I would use the for each loop container,

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

then write a .NET script to parse out the filename.

I would then do a conversion of the file "number"...

From the research I have done so far, the answer appears to be no, it cannot be done.

You cannot simply try to cast the system.object variable into a string...

I did finally find some information in BOL (Creating Nonclustered Indexes) which helps explain things for me. For the benefit of people who do not know what a "heap" is...

Jeff,

Good question. First, the problem was the Invoice Total (a seperate record in the file we receive) did not always match the sum of the charge(s) (sum was sometimes...

Oh... oh.... now why did I not think about that! I use the Row_Number() function in other SQL statements... never thought about it in this case. Another case of posting...