but when i m passing only one values to that parameter it is working and for more then one its not working, actually i wanted to know the reason of...

if u want u can use

Begin try ....End try and Begin catch...End Catch

In Try block put ur insert statament and in catch block put ur rollback and raiserror statament...

Mithun

are u sure u have records with this conditions.... TimeIn = '3/31/2009'

seems like u must be storing time also with date

try giving the condition "" TimeIn between '2009-03-31...

yeah this seems good one today i will be trying it will post it back the results,,,, thanks for it and also the reply earlier one also very help ful...

yeah but the problem with us is that we are planning to break the current db in two db and will be moving second part to differnet server .... so...

yeah true, no need to write drop for #temp table, it will get dropped auto... i just forget that....sorry

yeah u better use create tabel #temp and drop the same , rather then ##temp..

I think this is not the expected and best of ur reply....

but fine,,, i respect u sir....dnt get angry on me....

I m just raising my doubts........

I will check and will...

Chris Morris (3/31/2009)

---

mithun.gite (3/31/2009)

---

Dear Friend,

I think when u use case in select statement it has to process it row by row just like the function we use....so it might hit...

yeah ramesh seems fine,, i need to find out the tables which i want to archive ,,,,fine

thanks very much sir...

regards,

Mithun Gite

Dear Friend,

I think when u use case in select statement it has to process it row by row just like the function we use....so it might hit the perofrmance then...

may be this can help u..

create FUNCTION CONV(

@TIME VARCHAR(20)

)

RETURNS VARCHAR(20)

as

begin

SELECT @time=CONVERT(VARCHAR,(SUBSTRING(@TIME,5,2)+'/'+SUBSTRING(@TIME,7,2)+'/'+SUBSTRING(@TIME,1,4)+' '+

SUBSTRING(@TIME,9,2)+':'+SUBSTRING(@TIME,11,2)+':'+SUBSTRING(@TIME,13,2)),101)

RETURN @time

end

select dbo.conv('20070423142807')

Dear Friends,,,,

I wanted to know about Data Archiving.....In fact we have one situation in which we want to keep only 3years older data on our production server...so as any data...

hi,

as per me avoid using cases in select stmt... and better u go with the union all option , i think i would have opted for union all as i...

hi,'

try this one

select a.rgt from bulk_1 as a, todos2 as b

where a.rgt <> b.rgt and a.bictb=b.bictb

OPTION (MAXDOP 1)

or

EXEC sp_configure 'show advanced option', '1'

RECONFIGURE

GO

sp_configure 'max degree of parallelism', 0

RECONFIGURE

GO

thanks

Mithun