I am using sql2000. Will it work ?

First of all, i want to know,

how much cost for its registeration?

how many days it will happen ?

who are all participate in this conference ?

As a developer, what are the...

Guru,

As you suggested,I have executed sp_who2.

i got the below result

310 Sleeping ...

Jeff,

vow...Plenty of uses...

Could you please give me examples for all those uses ? I am eagerly waiting for your reply.

Table: mgr_acc scan count 0, logical reads: (regular=0 apf=0 total=0), physical reads: (regular=0 apf=0 total=0), apf IOs used=0

Table: BmarkDesc scan count 1, logical reads: (regular=3 apf=0 total=3), physical...

Oh...Sorry...I though you talked...

Any Inputs ?

1) have you checked for blocking? These two tables are EXTREMELY small and even if they are a massive cross product and/or have to do a hash join they...

Sorry!

I have tried to delete it from there,even though i have pressed delete button,But i am unable to delete it.

Yes, I want to know.

Can anybody list out some important uses ( Apart from Splitting the string,Date generation) of Tally table ?

whether it comes under Set Based or RBAR or Hidden RBAR. I hope it comes under Hidden RBAR.

if yes, How to overcome Hidden RBAR in this kind of situation ?

I...

you can use @@error or @@RowCount.

Say for example,

[highlight=""]

CREATE PROCEDURE p1

(

@LoadFlag CHAR(1)

)

AS

BEGIN

DECLARE @RowCnt INT

IF @LoadFlag = 'Y'

BEGIN

SELECT @RowCnt = COUNT(*) FROM Emp WHERE LoadFlag = 'Y'

END

IF @@RowCount = 0

BEGIN

PRINT 'No...

So i have to use loop to insert those records.

Take a look at the following URL.

http://www.sqlservercentral.com/Forums/Topic490453-8-1.aspx#bm490573