DECLARE @test-2 NVARCHAR(250)

SET @test-2 = '1234 , 2345 , 4444'

exec('SELECT * FROM TABLE1 WHERE ID IN (' + @test-2 + ')')

cursor may come handy for the case.

Modified on top of your post. The cursor is not the problem.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_MySpaceUsed]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[usp_MySpaceUsed]

GO

create proc usp_MySpaceUsed

as

set...

Just a thought.

Does Sybase have convert function?

use four part name like server.db.owner.object

open c2

fetch c2 into @DbNm

while @@fetch_status=0

begin

 insert #Files exec (

  'select F.[name],F.,F.[filename],G.groupname 

  from ' + @SrvNm + '.' + @DbNm + '.dbo.sysfiles F left join...

xp_cmdshell 'net stop sqlserveragent'

One option.

A Computed column on the table, use case statement to cumpute the value.

Modify dimension, add extra level to the hierarchy.

Try something like

CREATE PROCEDURE MySQLSP

@P1 nvarchar(2)=Null,

@P2 nvarchar(2)=Null

AS

 Select * From MySQLTable 

 Where Field1Value = isnull(@P1, Field1Value)

 and And Field2 = isnull(@P2, Field2)

Order By MyIndexedField

The triggers and indexes are pre-defined. Use drop/create method. Indexes creation could take time, it worths the waiting to reflect the new reality.

One option:

Map a driver with right credential so you can read from the file.

Then bcp.

Try something like following, you can put them in proc as well.

use database2

go

exec database1.dbo.proc1

select TableName = o.name, ColumnName = c.name, c.ColID,

 t.name + '(' + rtrim(cast(c.Length as char(3))) +

  case when c.xscale > 0 then

--   '[' + rtrim(cast(c.xprec as char(2))) +  --xprec =...

convert(varchar(5), birthdate, 101) between '03/19' and '04/27'

=Iif(RowNumber(Nothing) Mod 2, "Gray", "White")

I mean isqlw.

Try this.

save following sql to file (test.sql)

select * from pubs.dbo.authors

Change default session setting

open sql query analyzer, Tools/Options,

In Results tag,

  tick Print column headers(*) check box.

  select...