Wouldn't take long for me to be looking elsewhere for work especially if there was no comp...

Ralph Hightower (3/10/2009)

---

Irish Flyer (3/6/2009)

---

Hey, that's a good thing. ...

Antares686 (3/10/2009)

---

Jack Corbett (3/9/2009)

---

This is odd. Somebody smarter than me will have to give you the answer on this one. If you look at the

Estimated Execution Plan,...

Kit G (3/10/2009)

---

As for the table structure, I definitely want to keep it as normalized as possible, as that's the whole reason behind a relational database from everything I've been...

Have you looked in Books On Line?

A few general rules of thumb (and remember in SQL Server everything comes with an "It depends" attached):

1. Every table should have a...

Glad Lowell and I posted the same answer since the post was duplicated (http://www.sqlservercentral.com/Forums/Topic672270-338-1.aspx). Please don't post more than once.

The trigger you posted here should only send out an email once per update, not once per updated column.

What Brandie is suggesting is that you create a staging...

I don't think there is a replacement for the format function in T-SQL. T-SQL is designed to return data, not format it. You have to remember that Access combined...

Are you sure that all you care about is ODBC connections?

You can see what is connected and by what interface (.NET, ODBC) by querying sys.dm_exec_sessions. You could probably continue...

Another option which you may or may not have, is to put all the data in a staging table on the same SQL Server instance, and then use a Left...

I have not done it, but on the properties for the Group you can set a filter for Top N. Look up filters in BOL.

Here is a snippet from...

I would recommend using the Recipe_Salvage table. This is normalization. If you try to put it all in the recipes table then you could potentially have to add...

Assuming you are using SSRS to do this, you can create a Master report that contains each of the other reports as a sub report and then run the master...

K. Brian Kelley (3/9/2009)

---

Speaking of jedi masters and padawans.... I think I'm going to add the following disclaimer to all my future security articles:

"If you do not understand what this...

Can you post the SQL you are using? Then we can make suggestions.