Viewing 15 posts - 9,106 through 9,120 (of 14,953 total)
You would simply have a table with CategoryID and NextProductID in it. As you use them, you increment the NextProductID column.
I've seen it used. It would do what...
July 7, 2009 at 6:47 am
WayneS (7/6/2009)
GSquared (7/6/2009)
... Heck, I once licked a live electrical cord to see what it would feel like.)Now that explains a few things.:w00t:
The results were simply shocking!
July 7, 2009 at 6:39 am
GilaMonster (7/6/2009)
Paul White (7/6/2009)
Yr stoopid M$. Yr updats rooning SQL. Im quitting!!!!!11111!!!!!!!🙂
k thx bye
Isn't that supposed to be all one word? (Alloneword, even.)
July 6, 2009 at 3:16 pm
GilaMonster (7/6/2009)
GSquared (7/6/2009)
July 6, 2009 at 3:14 pm
Paul White (7/6/2009)
Yr stoopid M$. Yr updats rooning SQL. Im quitting!!!!!11111!!!!!!!🙂
go ahead quit u luzer!! we pwz ur datebas anywhay! hahahahhahaha-lol-rofl!!
July 6, 2009 at 3:09 pm
You're welcome. I wish we could help more, but I'm glad that you can at least recover from this. I see far too many similar situations where there's...
July 6, 2009 at 3:06 pm
Inconsistent file formats are a major problem.
What you might be able to do is set up a CLR script that checks the file for format, and picks different data flow...
July 6, 2009 at 2:35 pm
Were you doing log backups? Or just full backups?
July 6, 2009 at 2:31 pm
Then the key thing will be to get your boss to articulate exact needs on the thing. What kind of reporting will it need to do? How about...
July 6, 2009 at 2:29 pm
Gaby Abed (7/6/2009)
GSquared (7/6/2009)
Gaby Abed (7/6/2009)
Steve Jones - Editor (7/6/2009)
We're a long way from needing bigint, but if anything were to get that large, this would be it.
Is this the...
July 6, 2009 at 2:17 pm
Glad to know it's being worked on.
I've had problems with the XML capitalization issue. Interestingly enough, it used to capitalize everything, but the sample posted earlier in this thread...
July 6, 2009 at 2:04 pm
Do you have a more recent backup than one week ago? If so, what do you have?
July 6, 2009 at 1:58 pm
Any reason to not use something off-the-shelf? There are plenty of payroll applications that you could buy much more easily than you can build one. Plus, they have...
July 6, 2009 at 1:57 pm
You could add a SortPriority column, assign Kim a 1 and everyone else a 2, and then use that in your Order By. Would that work for what you...
July 6, 2009 at 1:55 pm
When I run that in a fresh database, I get the expected data.
Break the query down into its component parts, and run each of those in the database that's not...
July 6, 2009 at 1:51 pm
Viewing 15 posts - 9,106 through 9,120 (of 14,953 total)