Viewing 15 posts - 49,291 through 49,305 (of 59,066 total)
Heh... Nope! Doesn't make a bit of sense... all the rows you posted are identical and there is no question column.
Please see the link in my signature before you...
July 9, 2008 at 9:02 am
rbarryyoung (7/9/2008)
July 9, 2008 at 8:57 am
You might want to double check... CROSS APPLY is a fancy name for "Correlated Subquery" and can have all the same problems with performance.
July 9, 2008 at 8:43 am
I believe you're thinking of blocking.... deadlocks do not resolve themselves in a nice manner... there is always a "victim" that get's rolled back... always.
July 9, 2008 at 8:39 am
Heh... if more than one user has to use it even just once, it's not "one time"... 😀
July 9, 2008 at 8:38 am
ggraber (7/9/2008)
DECLARE @Table TABLE
( BatchID INT
,TransactionID INT
)
INSERT INTO @Table
SELECT 101, 1
UNION ALL...
July 9, 2008 at 8:11 am
No problem and thanks for the feedback, Phil... I've made similar mistakes... just wanted to be sure...:)
July 9, 2008 at 8:09 am
sbalaven (7/9/2008)
Thanks Jeff.But i need to store them as well in the primary key column.
Thanks and Regards
Bala
That would be a problem... only way I can see to do it...
July 9, 2008 at 8:07 am
I'm with Gail... but a bit more stringent on the subject. If you have any deadlocks, something is wrong in the code somewhere and you need to fix it....
July 9, 2008 at 7:59 am
There are three reasons I can see for it... and I use neither because of what Grant said... would probably be a bad design...
Someone already said to build "user defined...
July 9, 2008 at 7:53 am
Ummm... the best thing to do would be to create a stored proc and send the users instructions on how to run it with the correct parameters.
July 9, 2008 at 7:45 am
Nah... not a problem Kent... I just had more coffee than you 😛
July 9, 2008 at 7:43 am
Swamy m (7/9/2008)
Thank u.Actually i donot know the rows in the temployee table
It's just a way of showing that it actually works... the temporary table is just for demonstration purposes....
July 9, 2008 at 7:42 am
While COLLATE will take care of case sensitivity and the like, trailing white space is a huge PITA... I think anyone that depends on trailing white space is asking for...
July 9, 2008 at 7:39 am
You should still take the time to read the article about Tally tables whose link I posted, but here's the solution to the problem you posted. Also, take a...
July 9, 2008 at 7:26 am
Viewing 15 posts - 49,291 through 49,305 (of 59,066 total)