did u "refresh" your enterprise manager and check whthr the procedure still existed.

if you want to query only 1 level then what about this

select reportinglevelid ,

STUFF ((select (',' + Position)

from SampleOrg where reportinglevelid = 5

group by Position

for xml path ('')),1,1,'')

FROM SampleOrg...

check out Books Online on how to use cursors. Why do you need cursors. They are really performance drags.

use Datepart(mi,date1,date2)

Hi

During installation it asks for a instance name. The default instance name is the computer name. This option is selected by default. Maybe u did not notice it and went...

arjun.tewari (8/22/2008)

---

arjun.tewari (8/22/2008)

---

sg (8/22/2008)

---

create table #Temps

(

num int, OP_Bal int, quantity int

)

insert into #Temps values(1, 234, 12)

insert into #Temps values(2, 234, 08)

insert into #Temps values(3, 234, 9)

insert into #Temps values(4, 234,...

nice solution amit.

Hi

I agree its part of a mindset but using them makes it clear where procedure starts and ends... Especially when you have lot of Control flow statements.

Hi

Do you mean to say that the products table has rows and you want to update the cost column . Then you are looking at a update statement not insert.

OR...

gr8 article Jeff. Keep them coming.

for a second i thought :w00t:.... nice question

thanks for the info.

Steve - I think the question ought to have been clear...

True varchar(max) cannot be a part of a index. But it has its uses. Its much easier to store and manipulate large strings compared to sql server 2000.

Varchar(fixedlength) has maximum capacity of 8000. i.e you can define varchar(8000). If you want to store more than this in a varchar column you need to use varchar(max). The maximum...

i get an error "'MIN_ACTIVE_ROWVERSION' is not a recognized built-in function name. "..