DDL is the code for the creation of your tables/views that are involved in your question.

See if this helps:

INSERT INTO TableB (Col1, Col2, Col3, Col4)

SELECT Col1, Col2, Col3, Col4

FROM TableA

GROUP...

The GROUP BY technique advised before should work as expected for you. Did you try it?

You could include all columns in the grouping set if needed.

Otherwise, please post some more...

Hi, Jack.

Great suggestions there!

But why do you need to use an IF block?

Wouldn't this work as well?

UPDATE inventory

SET Sold = Sold + 1

WHERE FlightNumber = 'F3241b'

...

Have you checked the database for errors with CHECKDB?

There seems to be something very wrong there.

I heard about an issue like that before but it was easily fixed using 'sp_changedbowner'.

EDIT:...

Hi.

What does the following command tell you:

SELECT SUSER_SNAME(owner_sid)

FROM sys.databases

WHERE name = '<your database name here>';

Got it right because I remembered that lock escalations are always made directly to the table level. Thank you for the question! Very interesting subject.

Great question.

But am I the only that thought that the syntax error was part of the question?

But even so there wouldn't be a right answer for that.

I didn't understand the...

<double post. please ignore this>

Great back-to-basics question!

I just wasn't too sure if SQL Server would allow the log backup to be made or not but Hugo's explanation was right to the point.

I must thank you for the efforts of bringing this subject in the stairway series because as a T-SQL developer I was always a little confused by terms like "subscription",...

Jeff Moden (2/27/2012)

---

Part of the "speed" factor of a Tally table is that it's densely packed with only the information it needs. Adding the columns you have will make...

Excellent article! Thank you.

Now I have a question for you more experienced guys and gals. 😀

If I use a tally table like the one below would that be alright? I'm

trying...

Straightforward question and highly detailed explanations!

Thank you.

tony.turner (2/12/2012)

---

MCM is not really open to us in the third-world (...) Even were it to be available, the price (after currency conversion) relative to salary or contracting rates would...

Love the question. No tricks and a back-to-the-basics one.

I was expecting a few BEGIN/ROLLBACK TRANSACTION commands in there to make it a little trickier but it turns out it was...