I'm sure Jeff will come up with a more complete answer, but one example is that you'll create that view, then a few weeks later, someone else will use this...

You should be able to get this to work...

SELECT     TOP 100 PERCENT ITEMNMBR, SUM(TRXQTY) AS Expr1, SUM(CASE WHEN datediff(month, docdate, getdate()) = 0 THEN TRXQTY ELSE 0 END) AS period1

FROM         dbo.IV30300

GROUP...

First question : data warehouse or transactional database (reporting or working)?

It can be done, quite easily, I might add.  We're just telling you that it's a very bad idea.

If you insist, I can give you some working code to get...

Why would you want to do that?  Why would you have 4 different columns in the same table with the same data (time1, time2, time3, time4)?

Check out the case statement...

There seem to be some syntax error in the code you posted.  Are you able to post the exact code you are getting in the profiler?  Maybe we're just missing...

You got to write an article about this.  I'm sure you can win an award or something!!!

No need to point out that this is a bad idea.  Not even a...

I go with what I know... I never used osql.

Thanks for the tip .

I'm sure you checked that... but is there a default value to those parameters?

Are they set to something from the calling application?

If you run the script builder of enterprise manager, you can select all tables, then in the 2nd page, uncheck build create and drop scripts, then in the last page,...

Job make a sp that starts the job (sp_start_job?!).  Make a vbs file that uses windows authentication (so no login info is visible).

I never had to do this but I'm...

 This is the execution code of a procedure with outout parameters.  Check that procedure and see if the last 2 params are set to te joehack value somehow.

From his own words :

AFAIK only the Developer Edition will allow you install the actual database engine with all the extras on a non-server OS, that's why the client...

Use the union all version.  Then add the column name as a varchr description column.  The other way to do it is to le the application reversve engeneer this one...

SELECT CASE WHEN start proposal date < start review date AND start proposal date <  finish review date AND start proposal date < submit to client date THEN start proposal...