Going for the radically different approach here :

There is an option, DATEFIRST, that indicates the first day of the week. You can set it to friday (5, that is). Check...

When you're dealing with both internal and web clients, you have to move to a model where all BL is situated 'server side'. Be it in a middle tier or...

You can't return a result from a dynamic query. The easiest solution to your problem is inserting the result in a temporary table.

CREATE TABLE #temp(recordcount int)

SET @SQLString = 'INSERT INTO...

Good idea.

The problem is probably that your user is known in another database too (except for the one where you dropped it).

sp_helplogins should point you in the right direction.

Don't know if it is of any use, but there have been some threads a while back about multi-processor systems having problems.

Maybe you can check those for a possible cause...

Your procedure works fine for as far as I can tell. No problems inserting or recognising existing records.

(I only removed the reference to @phone, since it is not in the...

Can you post the rest of the code (the things you left out).

From your previous post, I gather that there must be an error in the first part, with the...

You'll have to add the check constraint on multiple columns, on table level that is. The next statement should do the trick

alter table constrainttest

add constraint two_column CHECK (other_column <> 0...

nmoore,

Yes, there is an issue with selecting all fields in the 'temp' query.

Because there is a 'group by' clause, you can only select either the fields that are also...

And it's still not too difficult... But you might run into performance problems.

Anyway, here's how you should proceed :

1. Construct a query that returns the product, type and the max...

You should use SQLCHAR as the host file data type for all fields if it concerns an ASCII file.

If not, it will think you are importing some kind of binary...

We also had some problems importing Excel files some time ago.

Don't remember the exact stuff, but it boiled down to a problem with Excel 'guessing' the type of a column...

From BOL : (Subject : Results Pane - just hit F1 in the results pane when browsing data)

Columns containing long varchar-type data display up to 900 characters of data....

You're completely right on this. As always, there is no single 'best' solution.

In this case there's a trade off between simplicity/mantainability and perfomance.

My personal experience is that in general performance...

I can imagine that the application time-outs on the statement if it really takes that long.

Have you looked at the execution plan? And are you running the latest SP?

If you...