Well I don't know, but I'm putting it on my resume right quick.

Ouch. I saw the other post first (which has some good replies), and replied there. Anyway, the title of the other post suggest that the poster wants the query to...

Looking at the title (not the text) of the original post gives a clue. "Trying to get null values" sounds like they want to retrieve rows with NULL dates as...

create table #member (A char(10), B char(10), C char(10), D char(10))

insert #member (A, B, C, D)

values ('apple', 'bread', 'carrot', 'chocolate'),

('Mango', 'Begal', 'Onion', 'Candy')

create table #Util (A char(10), B char(10), C...

That's the right way to begin, I think. Setting the TransactionOption to Required on the container will cause the container to start a transaction. Now you should set TransactionOption to...

My date column is called periodbegin. The derived column is like this:

YEAR(PeriodBegin) * 100 + MONTH(PeriodBegin)

The link seems to be busted today.

I took a three-day remote instructor-led course from New Horizons and thought it was pretty good:

http://www.newhorizons.com/content/index.aspx

Try this:

http://msdn.microsoft.com/en-us/SQL10R2BYFBI-TrainingCourse

So I've got three points per dollar for the last $500 of product "D." What happens if I now return "A" "B" and "C?" Does my score for product "D"...

I guess I haven't learned how to separate my comment from the piece I was responding to. The first line only was from the original poster.

I suspect there may be...

I would like to do the same for division so for 01/01/2011 00:00 my calculation should be 2 / 4 / 6

You must have some kind of sequencer, right? That...

It’s fairly common to have a Primary Key and a Foreign Key on the same column, when the Foreign Key points to a different table. Example: a company where...

Ichiyo85, on the 12th you said:

"Also,

SELECT *

FROM table1 t1

LEFT JOIN table2 t2

ON t2.ID1 = t1.ID1

OR t2.ID1 = t1.ID2

OR t2.ID2 = t1.ID1

OR t2.ID2 = t1.ID2

WHERE t1.ID1...

Let me get this straight - if ID1 is not 'Unassigned' then you want to use it for the join, but if ID1 is 'Unassigned,' then you want to...