🙂 Sorry for the headache, Craig. I appreciate the response, in spite of the headache.

If your head hurt, then SQL Server must be scratching its head too! ...

Thanks for the response.

Hi, Scott. Thanks for the great article. To clarify a point that you made in the comments, to configure the configuration connection string, you have to use an...

I'm not sure if the T-SQL (SS2K8) forum is the correct place for this topic or that the Lookup transformation task is the desired task. Perhaps the Merge Join...

Look into the FileInfo class/object. I believe that it has the information that you need. Hope that this helps.

Thanks...Chris

Have a look in Books Online at the merge statement. It's what's called an upsert...update when present, otherwise insert. Hope that this helps.

Thanks...Chris

Run a profiler/trace session against that database...that will give you the queries hitting the database.

Hope that this helps...thanks.

Chris

I think that this functionality of adding a count to the GO command is only available in SQL 2005 and up.

Thanks...Chris

To execute a stored procedure, use the syntax below:

exec storedprocedurename parameterlist

For example, if my stored procedure name was usp_GetSalesByState with a parameter of StateID, I would use:

exec usp_GetSalesByState 'GA'

OR

execute usp_GetSalesByState...

In the article, you mentioned in "...I picked jobs that would be good for me growth and development, would pay me more, or provide some exciting challenge. I was willing...

If you are just trying to concatenate rows rows into a single column, see the following link.

http://databases.aspfaq.com/general/how-do-i-concatenate-strings-from-a-column-into-a-single-row.html

Hmm...I guess it depends on what you want to do.

This is a tutorial on using it in .Net.

http://www.4guysfromrolla.com/articles/072209-1.aspx

I guess it also depends on how you want to structure...

Try adding your index after your insert...see if that makes a difference.

You can use SPs with nHibernate.

Well, as far as I understand it, the report viewer is just, as you said, a link to Reporting Services, which means that the reports would have to be developed...