Your open parenthesis is in the wrong place. (exec @sql) should be exec ( @sql).

Greg

You can query across database using three part naming. For example:

SELECT * FROM Database.Schema.Table

Greg

Max and min server memory is in MB, so your setting is way too high.

Greg

Because it's not the only correct answer. Without giving away the answer, the answers were check boxes. You needed to select more than one.

Greg

I agree with Matt. The pseudo code that you posted doesn't tell us what tables the three columns are from or what the relationships between the tables are, etc....

Yes. RTRIM(LTRIM(columnname))

Greg

Try using ISNULL(COUNT(col2), 0). That should replace the NULL values with a zero.

Greg

In my experience, there is no way to truly prepare for an interview. You know what you know. Cramming probably isn't going to help you much. That...

I've never heard of it referred to as index tearing or index splitting, but I assume he's talking about torn pages and page splitting which are two entirely different things,...

I have no idea why you would want to do this programmatically, but you could do something like this:

SELECT TABLE_NAME, COLUMN_NAME

FROM MyDatabase.Information_schema.Columns

WHERE ORDINAL_POSITION > 2

ORDER BY TABLE_NAME, ORDINAL_POSITION

Greg

Check out this article:

Analyzing Memory Requirements for SQL Server[/url]

Greg

Try this:

SELECT station_id, MAX(time_tag) AS time_lag, sensorname, ed_value

FROM NameOfView

GROUP BY station_id, sensorname, ed_value

Greg

When you use an aggregate function, all non-aggregate data must be included in the GROUP BY.

Greg

First, the six lookup tables shouldn't be an issue with the other three tables as long as the data that you are inserting is in the lookup table.

It looks like...

To get someone to help you further, you have to post your database design. Also, you mentioned that the examples that you have read only insert data into one...