thanks everybody,my prob is solved now

hi

ok i found it under database but in different schema,how to change schema to dbo

DEV,i tried it ,it showing over there,but it is under different schema,not dbo,thats y it is not showing,how to change schema to dbo

no its not in the master database or under system stored procedure.Any other option,while creating it i didint use 'USE DATABASENAME'.

but i know i have selected correct database on the...

i am connected to the right server,i am able to execute it,but its not showing in the list

i did it,still its not showing

thanks a lot DEV,that's what i was looking ,u solve my problem.

i want to order my result by 1,5 ..not with column name

no my prob is

select order 2, book_id,table_name,account_id,account_name

from book,account

where book.id = account.id

union all

select order 1,column1,column2

from table1,table2

where-----

union all

select order3,column1,column2

from table1,table2

where-----

union all

select order4,column1,column2

from table1,table2

where-----

in this query,every select has order column,mens if i do...

no.i want to use order by 1,5,do i need to include it in every select statement. i dotn know how to use it,coz every select stm has order by ,and...

how can i used order by, my function is like

select * from function_name('dae','account_name') order by 1,5

now the content of function is

select order 2, book_id,table_name,account_id,account_name

from book,account

where book.id = account.id

union all

select...

i tried it it gives me blank,not the valus,but i think rtrim and ltrim just remove blank spaces ,not the values

so it gives orderid values with no spaces on left or right ?

or it just says orderid should be blank.plz confirm me

account_date is declared as a datetime,but i want format CCYY-MM-DDThh:mm:ss

how to do it.coz i wan this parameter in cognos in this format

IS THIS correct

set @Account_date = convert(datetime,@Account_date,126)