I suggest to create a stag table Sales_new, just a copy of sales, fks and indexes included.

Write a select where you join contact with itself to retrieve top (or min)...

In your case it ill (presumably) fall in the TSQL:SQL batch completed, but its (probably) marked as default.

If you are conding in visual studio, just put a break point before...

Use the SQL Server profile (in the SSMS 2008 -> tools)

It can capture any command sent to the server (you ill need to learn how to use it, but that's...

Why? You still can do it in the "relational way"

create table TableA (textname char(3))

GO

insert into tableA values ('ABC'),('DEF'),('GHI')

GO

create table TableB (id int, ind tinyint, textname char(3))

GO

create table TableC (id int,...

A convetion from monochrome monitors age, from sure 😀

identation, syntax highlight, alignment, casing...

Its all "personal taste".

At the wikipedia disambiguation page there are TWO entries relative to DB:

Cardinality of a set, a measure of the "number of elements" of a set in mathematics

Cardinality of a musical...

MS SQL Server is mostly case insensitive.

reserved words are insensitive.

objects names and strings are insensite (if the collation used is insensitive)

and only a few things are sensitive like the today's...

If you migrated from a 2005 enviroment maybe something is still missing.

I tryed to set compability level and

Tools > Options > SQL Server Object Explorer > Scripting for server...

I find funny when someone complain about by *= versus explict outer join and stills write code in upper case and complains about lower case.

*=

OUTER JOIN

outer join

😛

But I digress.

I'm a...

Yes I agree its hard for beginners.

But these jargons come with the job. You ill need to learn it anyway.

When you find any strange word, take a time to learn...

Short answer:

In the SP, write the update statement for the columns.

and after it put:

if @@rowcount < 1

insert statment

@@rowcount contains the number of affected rows by the last statment,

if the row...

I think the problem lies in:

"Column Finish_Time in object Results contains type Time, which is not supported in the target server version, SQL Server 2005"

Try to install SSMS 2008 in...

The script was submited do SSC a few weeks before it was published.

In the mean time I managed to implement it in a real world application and the results are...

You are welcome.

The problem with cross join is it ill iterate for (size of tableA)*(size of tableB) times.

But its more a conceptual problem.

The performance of any join (and most where...

You are welcome.

These thing come slow

just keep going.