Recent content by berryk

I am trying to divide two columns in a select statement that pulls information from two different views. I keep getting a 0 in the OOS column. I can Add, Subtract, Multiply, but Divide doesn't seem to work. Here is my select statement that works other than the OOS column...

jamesLean, Thanks. I will let you know how it works out. So far it looks good! --Ken

Jameslean, Thanks that worked as far as I know. I will have to see after 3:00pm if I have any records for today. It works great for looking at yesterday's records, however, I am unsure of the logic for today's records after 3:00PM Thanks for the help! --Ken

JamesLean: On yours, I am confused. Where do I put my criteria? Is the CASE.. THEN 1 ELSE 0 where I put it in? berryk

dbomrrsm: I tried the logic below and got the following error messages in Query Analyzer: Server: Msg 170, Level 15, State 1, Procedure vw_Today_OR_Yesterday_2ndShift, Line 7 Line 7: Incorrect syntax near ','. Server: Msg 156, Level 15, State 1, Procedure vw_Today_OR_Yesterday_2ndShift, Line...

Below is the code. Commented out is what I have tried both as IF statements and CASE statements. It works fine without the conditions, but what I am attempting to do is show one query when the computer clock is before 3:00 PM and a different query when it is after 3:00 PM. I got the...

Can If statements be used in views? I want one set of criteia if before a certain time and another set of criteria if after a certain time. I dont have any problem with the time and date functions, Im just not if it is possible to use If stanements in views and if I do how to implement them...

If I have a number such as 67.0450123 and I want to pull out just the last three digits i.e. 123, what SQL command would I use to get at this? Would I have to turn it into a character first? Kb

For those of us who would rather look at table information visually rather than write SQL Plus commands to search for a database table and fields and structure, what tools are available either on the Oracle 8i disks or a third party tool? k

When I try to install 8i client over 8.0 client it tells me I must uninstall 8.0 . When I try to do this from the 8i cd it wont let me. Should I go to Control panel and remove programs to completely get rid of my 8.0 client? Then my 8i client will be seen as a clean install? I am using...