If the table is partitioned on the Day column, wouldn't it need to be a not null column? and part of the primary key?

How is data continually pumped in to this table if it only has 200 rows?

I don't know much about it, but at a previous job all the VMs were unable to use parallelism (at least that's how it seemed).

I would look at the execution...

CraigIW (3/12/2012)

---

Did you say the...

There is no schema specified, is it possible you had multiple copies of the same table, owned by different schemas? Seems unlikely, but funny things can happen if you have...

I did this in my previous job using a linked server with a dynamic open query call.

My recollection is that I had to specify the date format used by Oracle.

It...

jeff.mason (9/28/2011)

---

lemsip (9/28/2011)

---

venoym (9/27/2011)

---

I thought the question was fine. The trickery would have gotten closer to an 80% failed if the possible answers had included the number 4. ...

venoym (9/27/2011)

---

I thought the question was fine. The trickery would have gotten closer to an 80% failed if the possible answers had included the number 4. That was...

Sorry if this is a repeat.

01/04/2004 is a numeric expression.

SELECT 01/04/2004-- 0

SELECT 01.0/04/2004 -- 0.00012475049

Datetime zero = "1900-01-01 00:00:00.000"

SELECT CONVERT(DATETIME,(SELECT 01/04/2004))

[1900-01-01 00:00:00.000]

This may be why the original query returned no...

I do it sometimes when the primary key is a uniqueidentfier.

I don't particularly like doing it, but sometimes I can't find a better column.

Some questions you may or may not wish to consider.

Do all employees of the same type earn the same amount per hour?

What happens if an employee changes type? gets a...

Sounds like you have users with querying privileges without the skills they need. Good luck!

You may have to write some dynamic code to drop and recreate the view with new...

If its for some kind of report then you can go with generic column names like TodayDayMinus5 and dynamically name the column headers in the presentation layer/report.

I've had to do it the same way the previous poster described.

You might need to convert(nvarchar,@acctid).

You can also make it work using the @params option for sp_executesql.

This is even more convoluted, but it might work.

I would be inclined to unpivot the data, but that might be equally clumsy.

DECLARE @input_month INT

SET @input_month =...