ORDER BY CASE WHEN N IS NULL THEN 1 ELSE 0 END,N

How it is working ? I am unable to understand...

So..I have to change the query like

select SNo,CATEGORY,PROJECT ID,PROJECT NAME,BILLABLE,BUDGET,ACTUALS,REMAINDER FORECAST,FULL YEAR FORECAST, VARIANCE

from

(select SNo=count(*),

a.FinCategory as 'CATEGORY',

a.ProjectId AS 'PROJECT ID',

a.ProjectName AS 'PROJECT NAME',

a.Isbillable as 'BILLABLE',

a.Budget AS 'BUDGET',

a.ProjectActuals AS...

Actually i didn't executed the above actual query... But i did the above R&D work to identify the problematic area.. also i found that the problem is ORDER BY clause......

is there any other work around to do the same without generating script and replacing them with varchar(255) ?

my actual requirement is

"I want to update/replace varchar(255) to varchar(2000) for that (may be 25 or 30 out of 81) procedures".

Can't we update or replace the TEXT column of syscomments...

Thanks Peso !

I used Tally table to split the values.

#1,

do you feel any performance difference using Tally table logic and your logic ?

#2,

I want to update syscomments...

Hi Jeff,

Why can't you publish it as an article ? So that it will be useful to lot of folks like me.

Hey,

Why can't you use the below one ?

http://forums.oracle.com/

Jack,

Thanks for your suggestion. Is there any other workaround to check the NULL values (Apart from OR method) ?

Note: My manager said that we should not change the Table...

I tried the below code

declare @d float

declare @d1 float

select @d = 34343.454

select @d1 = 676.1566545

select cast (@d as varchar(50))

select cast (@d1 as varchar(50))

I got the below output.

34343.453999999998

676.15665449999995

Is the whole point to remove nulls? If so you need to change the columns so that they do not allow nulls. Finding nulls is easy:

Select

...

And... I have to throw an error message to enduser like 'Upload the correct data into ...'

Karthick,

1. what are you planning to do once you've found a null and stopped "the process"?

2. what is the process for? Is it for finding nulls?

...

do you mean to use like below

Create table #tmp

(

eno int,

ename varchar(25)

)

go

insert into #tmp

select 1,'Karthik'

union all

select 2,'Keyan'

union all

select 3,'Ravi'

go

Declare @Name varchar(50)

select @Name = 'Karthik,Keyan'

Select @Name = ',' + @Name + ','

Select...

Hey..Hey.....Sergiy

I am not fighting with you, I am ready to take all your comments,suggestions and advices. But there is a way to give all those things. The way you are...