Another possibility:

declare @mv_int int

declare @mv_char varchar(10)

set @mv_int = 8

if @mv_int >7

select @mv_char ='Yes'

else

select @mv_char ='No'

select @mv_char

May be you can store this db names in a separate table with code assigned to each table and if the update this table when your DB name is changing,...

Do you want to change columns order in the table?

If you run a query

select name,colid from syscolumns where id = object_id("table_name")

and insert into temptable with identity column...

From MSDN:

User-defined functions always return a value. Depending on the type of value it returns, each user-defined function falls into one of three categories:

Scalar-valued function A user-defined...

Check the article: "Support multilingual sorting using SQL Server 2000's COLLATE keyword"

http://www.fawcette.com/Archives/premier/mgznarch/vbpj/2000/12dec00/ss0012/ss0012.asp

From BOL:

Temporary Tables

You can also create temporary tables. Temporary tables are similar to permanent tables, except temporary tables are stored in tempdb and are deleted automatically when no longer in...

Have you used ##temptable or #temptable? - it would make a difference for the scope

quote:

---

Only problem with that is the potential 27+ different variations that I'll have to create....also it doesn't sit well for expansion if...

I would also go with the stored proc and included all available variatins of joins in the different select statements. Then using IF statement and distinct flag that was passed...

Have you considered using function Round()?

From BOL:

ROUND

Returns a numeric expression, rounded to the specified length or precision.

Syntax

ROUND ( numeric_expression , length [ , function ] )

Arguments

numeric_expression

Is an expression of...

quote:

---

Not sure if I understand what you are needing to do or what Oracle does with those keywords exactly.

---

May 13, 2002 at 6:57 pm