As long as you get both to resolve to a real datetime value (I sugest put into a datetime variable first) then you can use a case state. However due...

Even using the newer join syntax will produce the same execution plan for this query.

select * from Table1

Inner Join Table 2

ON Table1.AnyField = Table2.AnyField

Where 

Table1.OtherField = Value1

Ah, in my testing I didn't pay attention here. I have seen this and it isn't that the column be treated as a constant it is assuming the value of...

You cannot unless you are using Profiler to monitor connections or you turn Auditing on in the Server Properties under the Security tab in EM.

From the SQL Server Licensing FAQ

http://www.microsoft.com/sql/howtobuy/faq.asp

I suggest unless you know they come from another source like an Access database or SQL 2000 and you have 7 that you just try to attach. It will give...

Intresting, where did you test and what version is your SQL Server (along with @@version info). I tried a couple of ways and could not duplicate the problem.

Create a table with a single non-null row that is the primary key and put all of those items in it. Then you can inner join to that table on...

I have heard that before in an article I read somewhere but here is some on what the big deal is.

http://www.winnetmag.com/SQLServer/Article/ArticleID/21752/21752.html

However the file is instcat.sql can also be an...

Your options are DTS or writing a custom app. Either way thou it will still be record by record after the tables are created. There is no bulk task I...

Based on that I would write a simple VB Script to do the work and put in an Active Script in the package. Sorry don't have an example right off thou.

First off I notice you have a lot of subqueries and that you are using the older join methodology. I am still working on the subqueries but try this with...

If you will look at my query you will notice it is actually a subquery for the GROUP BY expression which is treated like a view to the top query....

I believe that has only to do with the font it is displayed in since that is in the standard 255 range. In most copyright is 169 but if you...

No, I have seen no way of telling a difference and my understanding is other than being for developement use there wasn't any.