Matt,

You are right, I interpreted it as vetoed and it may not have been.

Could you post some code on how you would dynamically load from the correct status table...

Matt Miller (10/9/2007)

---

without starting a thread war - you'll end up with an entirely different maintenance nightmare - the "update" nightmare. For example - if you wish to change...

I hate to break this to you, but there is no way to format only part of the data in a textbox. If "Employee Name" is a concatenation of...

You can't restore just empty objects from a backup. If you want to create an identical database structure you can use enterprise manager to create scripts of all the...

It looks like you are trying to find records where Customer.AscentId Is Null, so why wouldn't you just use Where Customer.AscentId Is Null as the criteria in the Where clause,...

Did you try what I suggested? Since you added an instance it may need to use localhost as the server name or have the Sql Server configured to allow...

When declaring a table variable you can define it with any columns you need. In my example I added a column ExtraTime, which does not exist anwhere else. ...

Is the parameter/variable defined as datetime or smalldatetime?

AS far as the collations they are the same. Both are US English Case Insensitive and Accent Insensitive and I do not...

I almost added your original solution to my post as Solution 3, but I decided the downside of having to create a new table anytime you might need to add...

How do you know the stored procedures are expecting US Format? What happens if you run a query against the table using a date field in where clause? ...

I'm not sure what you consider a maintenance nightmare, but I will make some suggestions anyway and then see if you think they are maintenance nightmares. These are not...

You can only install the server portion of SQL Server 2005 Enterprise Edition on Windows 2K server SP4 or later or Windows Server 2003. When you run the Enterprise...

It looks good to me also. I'm surprised we haven't seen a post in this thread about how no trigger is a good trigger:D. Not that I would...

Hey how many people here are really experts in SQL Server? I learn something new everytime I come here. The same can be said of any programming or...

a_mail.address (10/6/2007)

---

Thank you Jeff,

No, RequestDate and RequestTime are not VARCHAR, just SMALLDATTIME.

They are seperated because RequestTime and RequestDate were just some symbolic names to make my query's structure clear. In...