SCC has been an invaluable resource for me, since I started pursuing SQL Server 2005 professionally, about 2 years ago. I began using SSC when I was preparing for my...

You're right - thanks for the help, Gail, and others.

-Simon

Gail:

Thanks for getting involved, and thanks to anyone else who still might be playing along at home...

I've been trying to simplify things, but I'll explain in a little more detail...

Thank you for your post, Michael, but unfortunately the code you suggested didn't produce the desired result.

When I implemented your code into the trigger and ran an INSERT...SELECT statement against...

Thanks so much, Jacob and Lowell, for your input.

Here is the code for my trigger - hopefully it will help to clarify what's happening:

-- INSERT Trigger on FileTransfer, to insert...

Mike:

Although I don't think there's a way to hide unwanted databases from SSMS, you can specify a default database when you connect to the ISP's server by choosing your database...

Sorry - I was not able to resolve my issue. I ended-up taking a different approach to my problem. Good luck resolving the error!

-Simon

Have you got a table which stores the date ranges for each of your quarters?

Such a table might look like this:

QID QuarterStartDate ...

Just wanted to post a reply to my own previous question, in case anyone else is following the thread, or runs into the same trouble in the future.

I upgraded the...

Hello All,

I am in the process of finishing the migration our SQL Server 2005 from a Windows 2003 32-bit machine to a Windows 2008 64-Bit machine. Despite the 64-bit O/S...

Anything by Ben Forta will be pretty good.

Try SAMS' Teach Yourself SQL in 10 Minutes, or Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes.

Both good books to start with.

Good...

Hi All:

I'm working with a MySQL database that serves a website, and need to periodically transfer data from our local SQL Server 2005 server to the MySQL server.

I've setup the...

Just as a follow up, Mark I used your CROSS APPLY syntax and it worked perfectly - allowing me all the groupings I needed.

Thanks again everyone for the expert help.

-Simon

Mark and Chris,

Thank you so much for your replies.

I'll try both and let you know what works best.

Thanks again - I really appreciate it.

-Simon

I can second that.

I definitely had to restart the SQL Server service after installing the driver.

-Simon