Viewing 7 posts - 331 through 337 (of 337 total)
Oh I'm just getting started here.
andyb: Whats your solution?
Your comments have been non constructive and have not answered the origional post.
My solution works, no...
September 21, 2007 at 4:20 am
There is a difference between asking for help and having someone do your work for you.
One thing that everyone should learn is how to phrase a question with sufficient detail...
September 21, 2007 at 3:29 am
Unless you mean to not use the MAX function
and use something like;
SELECT @NEXTID = (SELECT TOP 1 [id_Column] FROM <table> ORDER BY [id_Column] DESC) + 1
to get the value.
September 20, 2007 at 2:26 am
If this is a serious question you need to reword it and give more detail.
There is not enough information here, as it stands you have not stated any context to...
September 20, 2007 at 2:17 am
Due to the fact that having duplicate records within a relational database means somebody somewhere had a stupid attack and created a system without checks and constraints to prevent it...
September 11, 2007 at 1:59 am
I find this question extremely annoying.
September 3, 2007 at 1:59 am
When you want to switch to OUTER JOIN for testing purposes JOIN syntax wins out right.
"Fix the problem, not the blame!"
August 17, 2007 at 3:29 am