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 =...

I'm not suggesting this is a good idea, but if avoiding dynamic sql is your only consideration then this might work.

Edit: I assumed you wanted the rest of the year...

This is a common problem with medical codes, 008.8 is not the same as 08.80.

I have always had to save as a text file, or open excel and add a...

This may or may not be relevant.

A while ago I had to set up a sql version of an oracle database(s).

I went with one sql database and multiple schemas that...