Viewing 14 posts - 16 through 29 (of 29 total)
Hi Ron,
How do you know that the ItemID's in Standard and Order are different from each other? Is there an obvious way of telling the difference or are they just...
February 8, 2006 at 2:28 am
Not readily but their network is grinding to halt despit the network admins assurances that everything's working fine.
Do you think it's to do with the differences between the different editions...
June 17, 2004 at 7:41 am
The server that's executing in under 1 second is a better spec all round to the laptop however I don't believe there is enough of a difference in the specs...
June 17, 2004 at 7:24 am
Sorry I misread your post. A normal temp table is actually a table that gets deleted at the end of the sproc so if you call the sproc again before...
March 30, 2004 at 3:00 am
As the table variable is a local variable it should behave in the same manner as any other variable type i.e. it is visible only within the scope of the...
March 30, 2004 at 2:57 am
Table variables are created only in memory so there is no costly disk writing involved unlike temp tables which are pretty much real tables that just get destroyed once you've...
March 30, 2004 at 1:14 am
Further to the first part of phanikks answer. If you use a table variable in a statement involving a join you must give the table variable an alias e.g. myTable...
March 11, 2004 at 6:41 am
Unfortunately I don't think I've ever written any perfect code so I'm affraid I can't empathise.
March 10, 2004 at 2:50 am
I haven't got your immediate solution however I find that problems with missing commits and begins are normally due to errors in the preceeding SQL statements. I copied your code and...
March 9, 2004 at 2:44 am
Just on a matter of speed, you could try replacing your temp tables with table variables as these are handled in memory so there aren't any expensive writing to disk...
February 27, 2004 at 2:17 am
This should cover it. I've included Richard Lesh's conditions and made two select statements. The first one gets you a the first time slot for a specific worker based on...
February 13, 2004 at 3:11 am
Just as an after thought. Why not create the table outside of the if statements with any fields that are always present and then use Alter Table ... Add to add the...
February 11, 2004 at 9:55 am
Just thinking quickly, I might have missed something.
If I've read your columns correctly (I'm assuming that the date in tblBooking is actually a datetime not an int) this should return...
February 11, 2004 at 4:53 am
Further more to this. I've just found that if I put the non-letter characters in between letter characters it will return an index
declare @b-2 varchar(20)
set @b-2...
February 11, 2004 at 4:20 am
Viewing 14 posts - 16 through 29 (of 29 total)