Hi,

routine_definition is returns with only nvarchar(4000)

so try

exec sp_helptext 'SP'

ARUN SAS

Hi,

see again your ListcolumID remain static

USE SAME STATEMENT

ARUN SAS

hi,

your listcolid is more consent order then

this enough

select

distinct (select b.listcolumnid from @abc b

where b.listrowid = a.listrowid and b.listcolid = 1) column1,

(select c.listcolumnid from @abc c

where c.listrowid...

Hi,

try this

declare @abc table (listrowid int, listcolid int,listcolumnid varchar(15))

insert into @abc values (1,1,'1name1')

insert into @abc values (1,2,'1name2')

insert into @abc values (1,3,'1name3')

insert into @abc values (1,6,'1name4')

insert into @abc values (2,1,'2name1')

insert into...

Hi,

No need to put the ROWTERMINATOR, when the records in the line ie it row alignment.

So try to put all row data in one line then second row data in...

Hi,

Slight misunderstand

You have the format like

slno,

pono,

sku,

qty,

date

And you need like this

slno,

sku,

pono,

qty

Is this correct?

ARUN SAS

Hi,

try this

declare @abc table ( UserID int,Score int, Event int)

insert into @abc values (1,100,1)

insert into @abc values (1,200,2)

insert into @abc values (1,150,3)

insert into @abc values (1,100,4)

insert into @abc values (1,100,5)

insert...

Hi,

Create the trigger for you requirement, when inserting the data it’s validate the each data type

ARUN SAS

Hi,

try this statements

declare @HOS table (

Doctor_Code char(5),

Patient_code char(10),

TotalTests int)

--

insert into @HOS values ('A1','12121',56)

insert into @HOS values ('A1','0000',12)

insert into @HOS values ('B1','111',5)

insert into @HOS values ('B1','0000',111)

insert into @HOS values ('B1','4533',11)

--

--select *...

Hi,

Show the coding in the SP

ARUN SAS

Hi,

instead of giving the '' you give null

create table #test

(col1 varchar(30),

col2 varchar(30),

col3 varchar(30))

--

insert into #test (col1, col2, col3)

values('hi there', '111', null)

--

insert into #test (col1, col2, col3)

values(null, null, 'Hello')

--

insert into #test...

Thanks Gail Shaw & ADI

ARUN SAS

Thanks ADI,

Is same works in 2k? If no means, how these handle by other way in 2k?

ARUN SAS

Hi,

What you written is correct, but do the round off for the AVERAGE

Like

declare @abc table (

Center varchar(15),

FCR numeric(8,3),

DATE1 datetime)

insert into @abc values('El Paso - NC',0.63,'2008-12-31')

insert into @abc values('El Paso -...

Thanks ADI,

What I need is simple table and trigger (with out any ref), when the table drop by somebody in development, the trigger won’t allow to drop the table.

ARUN...