I'm confused by this part of the narrative:

" I have a table of Case Numbers and Doctors involved in the case. There could be any number of docs. My users...

It sounds like your destination directory is a constant?

You could use a data flow task to get the values in the text file into the package, but I'd find it...

Good beginner's book: Ralph Kimball, "The Data Warehouse Toolkit". The 2nd edition is ISBN 0-471-20024-7, don't know if there are later ones.

In any case, pages 54 -57...

Is your goal a raise or a review from your boss's point of view? These are not the same thing, and I have to say, it's unclear from your...

I've read this thread, and it seems everyone wants to jump right into code without fleshing out the domain and entity relationship model, and it seems to me that's leading...

I encountered a case where you can't, but it's probably not your situation. I found that I was not able to install 2008 Developer Edition on a test machine...

Is the original editorial about being asked to do something outside of or percieved to be beneath your job title, or just working at a different vocation for an equivalent...

The image is the return of zero rows. "Having" gets applied after the group by (and therefore after the aggregation), so I am going to guess your table has...

EDogg,

Thanks for that idea. Kill 68 with statusonly reports:

SPID 68: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

Either I assume that...

GSquared,

Thank you for your advice and clarifying questions.

Fortunately, I happened to set up this particular database new for this report; it consists of working tables to support the...

Does this do what you mean?

Select Selection_ID, Min(time_stamp) as MinTimestamp, Max(time_stamp) as MaxTimestamp into #Boundary From YourStaticLog group by Selection_ID

Select S.* from YourStaticLog s inner join #boundary b on s.Selection_ID...

Thanks for clarifiying that for me, gilamonster; I was loosely aware these were deprecated (though as archived in my mind, for 2008) but not on the ball enough enough to...

I recently encountered an issue where a one-record insert into a 2 million record table took 45 seconds due to clustered index fragmentation. Performing DBCC INDEXDEFRAG (which does not...

I already have this partially implemented: In one way, barring storage limit issues, with full text search the ability to sort by many measures, I don't understand why people don't...

I recently troubleshooted an issue where a simple activity logging table was taking 45 seconds to insert a new log record. After I took actions to reorganize the index...