Viewing 15 posts - 16 through 30 (of 2,838 total)
GilaMonster (12/14/2016)
Sioban Krzywicki (12/13/2016)
I want to use a bitwise column because
I'm going to recommend against that. I'm busy (trying to) fix...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 14, 2016 at 6:15 am
ScottPletcher (12/13/2016)
To distinguish NULL values, I think you'd need another column of the same int type, with bits in it to indicate...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 13, 2016 at 3:00 pm
Hugo Kornelis (12/13/2016)
Sioban Krzywicki (12/13/2016)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 13, 2016 at 2:59 pm
Jack Corbett (12/13/2016)
Any chance you could normalize the structure so the Yes/No columns are in a separate or separate table(s). Maybe...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 13, 2016 at 2:58 pm
I want to use a bitwise column because there may be more columns added in the future. With a bitwise column, you just add a new value. With bit columns...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
December 13, 2016 at 9:02 am
TheSQLGuru (11/17/2016)
Sioban Krzywicki (11/17/2016)
TheSQLGuru (11/17/2016)
Anytime code works sometime and not others you need to take a REALLY close look at the...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
November 17, 2016 at 11:05 am
TheSQLGuru (11/17/2016)
Anytime code works sometime and not others you need to take a REALLY close look at the logic and especially...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
November 17, 2016 at 9:49 am
John Mitchell-245523 (11/17/2016)
Do the triggers (or either of them) have the NOT FOR REPLICATION property?John
Nope
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
November 17, 2016 at 9:45 am
Please see this MS reply. This is a known problem with 2008 & will not be fixed. This thread gives a workaround.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
July 1, 2016 at 1:20 pm
j-1064772 (6/15/2016)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
June 15, 2016 at 10:33 am
wojciech.muszynski (5/9/2016)
Sioban Krzywicki (5/9/2016)
SELECT (ABS(CHECKSUM(NEWID())) %20) + 1
This generates random numbers between 1 and 20. To...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 9, 2016 at 7:48 am
I believe I saw Jeff Moden of these forums post a simple, truly random generator.
SELECT (ABS(CHECKSUM(NEWID())) %20) + 1
This generates random numbers between 1 and 20. To have a different...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 9, 2016 at 7:14 am
Eric M Russell (4/29/2016)
create database [ ];
GO
use [ ];
GO
create schema [...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 29, 2016 at 1:53 pm
There is a Details file, but it is massive. Thanks for pointing me to it. I'm going to pass it on to the IT team and see if they can...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 29, 2016 at 12:34 pm
Grant Fritchey (4/29/2016)
Sioban Krzywicki (4/29/2016)
John Mitchell-245523 (4/29/2016)
Sergiy (4/28/2016)
The names don't affect performance or quality of the code anyway.
It's...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 29, 2016 at 10:56 am
Viewing 15 posts - 16 through 30 (of 2,838 total)