Roy Cross (5/9/2007)

---

Found it. For anyone else who may be interested...

' Add the input parameter and set its properties.

Command.Parameters.Add("@SKU", SqlDbType.VarChar).Value = SKU

...

Thank you for the answer.

Here is all I can see.

http://www.oracle.com/technology/software/products/oracle9i/index.html

OK here goes, for my example let''s assume I know a query performs better if @Param2 is not included when not set and @Param3 has no effect on performance. Additioanlly...

OK think I got it now

select

* from hr

WHERE

terminate_date IS NULL OR

cast(cast(TERMINATE_DATE as varchar(8)) as datetime) >= DATEADD(day,-30,GETDATE())

Sorry can you provide an example of the raw date value as it is stored and if is not 20070109.071400 wheere the date is 01-09-2007 7:14 AM then how does...

What do you mean numeric? your example shows yyyy-mm-dd. What is the format of the data that you must convert from?

I think I misunderstand your requirements. You state you need to calculate the avergae length of stay for each quarter per patient. But you are doing it by year. Do...

I think you might be going overboard unless I misunderstood you

SELECT

*

FROM

hr

WHERE

(CASE WHEN [EMPLOYEE_STATUS] = 'Terminate' AND hr.terminate_date < DATEADD(d,DATEDIFF(d,0,GETDATE()) - 30,0) THEN 0 ELSE 1 END) = 1

The hard part for me is the need to stay ahead of the curve. Just watch how many people are impacted by the fact they have only worked on Mainframes...

Ramesh (11/6/2007)

---

As I said earlier, the limit only applies for fixed length columns....(i.e. the total length of fixed length...

Glad you found your answer, and thanks for posting the answer so others might find it faster. 😀

Look at the execution plan in Query Analyzer and see if you can spot maybe a chance for a better index which may have impact in spades in some cases.

Also,...

K. Brian Kelley (11/7/2007)

---

Also, there are always volunteer opportunities and short consulting engagements you can take on with SQL Server. Having the skillset is only a bonus, even if you...

I would suggest contacting Oracle for a 64-bit version driver. They show releases here for 10G

http://www.oracle.com/technology/software/products/database/index.html