Hi,

try this code

declare @var1 char(10)

,@var2 char(10)

,@var3 char(10)

,@var4 char(10)

, @searchvar char(10)

select @var1 = null

,@var2 = null

,@var3 = null

,@var4 = '123'

select @searchvar = case when @var2 is null...

Try this statement

select * from tbldeals

--where trade_date = '2009-03-06 00:00:00'

where convert(datetime,(convert(int,trade_date,101)))= '2009-03-06 00:00:00'

ARUN SAS

Hi,

Try this codes

declare @sample table ( id int, name varchar(30))

insert into @sample

select 1,null union all

select 2,'123' union all

select 3,'234' union all

select 4,'345' union all

select 5,'456' union all

select 6,null

Select isNull(name, 'N/A')...

hi,

refer the topics

http://www.sqlservercentral.com/Forums/Topic551602-1325-2.aspx#bm567224

(Home » Article Discussions » Article Discussions by Author » Discuss content posted by Susantha Bathige » LIKE operator)

ARUN SAS

Ya,

thanks.

ARUN SAS

Thanks Lynn Pettis

but if i create the #temp with SLNO identity,then the clustered index realy needed?

ARUN SAS

Thanks J

ARUN SAS

Thanks Ramesh,

I got the point

ARUN SAS

Hi,

Thanks Ramesh,

I already understood this concept,

I too wrote this update statement, see the earily,

All I need is how I solve this without using while.

ARUN S.A.S

thanks Ramesh

But this articles only for the order by and its related,

i need the tips to slove this issue

ARUN SAS

Tray this

simple

Create table #t(rating int,bookid int)

insert into #t

select 97, 201

union all

select 96,100

union all

select 95,300

union all

select 50,100

union all

select 10,201

union all

select 30,300

select a.rating,b.bookid from #t a, #t b

where a.rating =...

Hi,

your passing the int (round no) value as @Period,already in 2 also then int type

try this

CREATE FUNCTION TEST(@Period FLOAT)

RETURNS FLOAT AS

BEGIN

...

Adequate and nice to learn

To get the exact result

select * from #Like_Test

where Col1 Like '%Cu[_]%'

‘_’ is escape so

[_] is the valuable one