Hi Hunterwood

I see that Lance is importing data from a flat file - something we regularly do. Can the references be set up during the import as in a package...

Hi

Have you had any luck tuning your query?

Like they said before, start with replacing the cursors with set statements. But then replace the temp tables with table variables.

How big are...

Thanks for the question.

What it does highlight for us 'Newbies' in SQL, is the order of statements being processed, in this case the whole of the SELECT before the FROM...

Thanks for the question, however I'd like to point out that as per MSDN,

The values of the PasswordHash and PasswordLastSetTime properties are available on all supported configurations of SQL Server,...

I suppose it would be SQL 2000 vs SQL 2005 and the bug has been fixed, but I want that point. :alien:

Now I understand what you were trying to achieve. Thanks for the question.

I think this question could have been worded better and is incomplete.

Thanks Wayne.

This seems to work. Will have to understand it and test it before I use it though :blush:. I've worked with CTE's but not a TALLY table. Thanks for...

So a DELETE would check if there were any rows still referencing the parent table, but a TRUNCATE can not and would therefore fail? even though we have cleared the...

So... in the following code

declare @result decimal(12,8);

set @result = round (5/3.0, 4,3);

select @result;

I get 1.66660000

The operation (5/3.0) completes and the rounding is done according to the variable declared...

This is a good question. Thanks.

It should have been easy to spot the conversion to Int, but I was more focussed on the 1 in the ROUND function. :blush:

LOL....

Who uses a ';' anyway? it's not yet standard practice and if you do, you should realise that it would cause...

I was kind off expecting SQL to throw an error due to regional settings. I am in South Africa and we specify the day before the month (the day is...

Just a quick comment.

Most of us still have SQL 2005 but will (hopefully soon) migrate to SQL 2008.

In SQL 2008 it will be alot easier to insert multiple rows...

I did some research too as i'm not American. What do you get if the answer is wrong?

As noted already, the correct answer would be 2011.04.18.

What do you get if...