If looks like it being used as a hierarchyID (new in sql2008), quite clever really.

Books online is the best resource for checking syntax, though im not sure what you are expecting to find.

no , but you can wrap the declare within an IF

if(1=1) begin

declare mycur cursor for select 1 from sys.tables

end else begin

declare mycur cursor for...

I could give you the solution , but i would urge your to play with the code and attempt to find it for yourself. Its quite simple. After all...

meriantok (9/3/2009)

---

Sometimes these procedures have a duration of 40 or 50 seconds

But if i re-run these procedures WITH EXACTLY the same arguments

after 0.5 or 1 minute they return the data...

For this query the index seems wrong , should be c1,c2,date.

NextDate is just an alias for table1 within the subquery.

The still could be a whole host of reasons why its...

Thats the number of seconds from 01-jan-1970.

Select dateadd(ss,1220438820,'19700101')

Exactly as above

create table #table

(

id integer,

receiptnumber integer

)

go

delete from #table

go

insert into #table values(1001,1)

insert into #table values(1001,2)

insert into #table values(1001,3)

insert into #table values(1001,4)

insert into #table values(1001,6)

insert into #table values(1001,7)

insert into #table values(1001,8)

insert...

subtitle differences but the same advice still holds true

http://msdn.microsoft.com/en-us/library/ms187644.aspx

If you just need something 'quick and dirty' this should do.

create table #table

(

id integer,

receiptnumber integer

)

go

insert into #table values(1,1)

insert into #table values(1,2)

insert into #table values(1,3)

insert into #table values(1,5)

insert into #table...

Hi , please try to keep your related issues to one thread

http://www.sqlservercentral.com/Forums/Topic781966-324-1.aspx#bm781978

I think its more that a recommendation ,...

will this do ?

update table1 set Result = Datediff(dd,date,(Select top 1 date from table1 NextDate

...

Its really hard for me to judge your technical abilities.

Does this link help ? http://aspalliance.com/673

SQL Server has no native way of interacting with a user.

You will have to find some other Language to present the user with a textbox, and then pass that into...