Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: filmr
  • Content: Threads
  • Order by date
  1. filmr

    STDEV domain error

    I'm getting a domain error when using the STDEV function. Seems to be keyed to specific numbers. Here is an example of the data being used: Create Table Test( Code varchar(10), Amt money ) go set nocount on declare @x int set @x = 1 while @x < 10 begin Insert into Test values...
  2. filmr

    CASE or DECODE with ORDER BY

    Can't get this to work: ... ORDER BY CASE v_OrderBy WHEN 'Col1' THEN 1 WHEN 'Col2' THEN 2 ELSE 3 END DESC Just seems to ignore the ORDER BY altogether.

Part and Inventory Search

Back
Top