>>Couldn't even find it in BOL....are you sure your not just making this stuff up

As mentioned above, DIVIDEBY is not implemented in Sql Server, hence the issues with this question....

>>I always thought you had to define. I just see your dt after a select inside of some parenthesis. is that all it take to create it?

In SqlServer, yes,...

I would expect that specifying a format file overrides any other parameter you give to BULK INSERT, since you're essentially telling it to get all its parameters from the format...

The speed up probably has less to do with the DT, and more to do with getting rid of the IN() and the correlated sub-query. Use of IN() should be...

Getting rid of the UNION and the WHERE <column> IN should help performance.

I'd use a derived table to get the required aggregates (Min & Max) per serverid, then join to...

Well ... you're using the same expression in the WHERE clause. Are you remembering to handle it the same way in both parts of the query ?

[Note] If you're going...

>>returns just the records where OpeningDate=''

Well, that's the entire source of your error. You're telling SqlServer to convert a column to a date and it doesn't know what to...

Run this query. Does it return any rows ?

SELECT Mattername, OpeningDate

FROM tm5user.Matter

WHERE ISDATE(OpeningDate) = 0

Note, the question was regarding Table variables, not variables designed to hold single scalar values.

Try this recent thread on the same subject:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=157332&p=2

The LEFT JOIN will be more efficiant than the NOT IN.

However, if the only purpose of the LEFT JOIN is to check for a NULL to determine a non-existent record,...

Since the join is expensive, I'd do it once in a derived table, then pivot the results to translate each index row into a column:

Select dt.ID,

  Max( (Case Index When...

NULLIF()

Google group search on the comp.databases.ibm-db2 newsgroup will answer DB2 stuff real fast.

Search the forums on 'Dynamic SQL'

Search the forums on 'SQL Injection' to see why you shouldn't use it.

Search BOL on "Linked Servers".

Once linked, you reference object names using 4 parts:

YourLinkName.DBName.Owner.Object

The sample VB.net code for comparison contains both syntax and logic errors.

In VB.Net, an IF is ended by "End If", not End.

Also, "If result = number *...