Viewing 15 posts - 796 through 810 (of 14,953 total)
Eugene Elutin (9/19/2012)
ScottPletcher (9/19/2012)
Eugene Elutin (9/19/2012)
...
ISO currency and Country codes are a prime example of an when the natural key (ISO Code) can be used as an Identity column and...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 19, 2012 at 9:57 am
If you need to maintain backwards compatibility with versions of SQL Server prior to 2008, then don't use Merge. Otherwise, it does have advantages.
The main advantage, from my perspective,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 19, 2012 at 9:53 am
CELKO (9/18/2012)
And now you've got a salesperson and his manager on the phone to you. They need to insure an expensive (high premiums, low-risk) collectible car, which doesn't...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 19, 2012 at 6:23 am
When I was job hunting 2 years ago, I made sure to get the salary range before I bothered with even a first interview. They know what they're getting...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2012 at 10:01 am
Does the report require the user to have Windows authentication, or does it run under the SSRS account? If the user-account, then what you're probably running into is what's...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2012 at 8:03 am
Lowell (9/18/2012)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2012 at 7:59 am
Eugene Elutin (9/17/2012)
GSquared (9/17/2012)
Eugene Elutin (9/17/2012)
And you didn't respond to the basic assertion about e-mail, which is its horrible weakness as a primary key for human beings. I...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2012 at 7:48 am
CELKO (9/17/2012)
2 points here. First, What does an IDENTITY value do other than uniquely identify an entity?
Think of a parking garage (disk) and parking slot numbers (identity,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2012 at 7:42 am
David.Poole (9/18/2012)
hakim.ali (9/17/2012)
Good reading, thanks. The NoSQL movement is more than 20 years old? Didn't know that...
I think NoSQL is a new name for a much older concept.
In fact I...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2012 at 7:22 am
I'd dump the cursor, put set-based code in the trigger, and call it a day.
Or, better yet, use a proc for all updates/inserts into the table, and have the proc...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2012 at 6:14 am
Are you trying to exclude "_1_" and "_2_" in the same filename?
SET NOCOUNT ON;
IF OBJECT_ID(N'tempdb..#FILE_PROCESS_LOG') IS NOT NULL
DROP TABLE #FILE_PROCESS_LOG;
CREATE TABLE #FILE_PROCESS_LOG ([FILENAME] VARCHAR(25));
INSERT ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2012 at 6:10 am
ScottPletcher (9/17/2012)
GSquared (9/17/2012)
ScottPletcher (9/14/2012)
DECLARE @year int
SET @year = 2012 --<<-- chg as needed
SELECT
...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 17, 2012 at 12:08 pm
Eugene Elutin (9/17/2012)
And you didn't respond to the basic assertion about e-mail, which is its horrible weakness as a primary key for human beings. I still maintain that...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 17, 2012 at 11:27 am
CELKO (9/17/2012)
Both concepts also assume that all data will be for current-era entities. DUNS numbers only go back to 1963. E-mail for common use, even in tech-heavy...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 17, 2012 at 11:17 am
GPO (9/16/2012)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 17, 2012 at 9:48 am
Viewing 15 posts - 796 through 810 (of 14,953 total)