Viewing 15 posts - 1,321 through 1,335 (of 14,953 total)
sturner (6/26/2012)
GSquared (6/26/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
June 27, 2012 at 6:26 am
jbnv (6/26/2012)
patrickmcginnis59 (6/26/2012)I'm pointing out that you have not addressed the free market response to a visibly bad actor. There very well could be an answer here, thats why I'm...
- 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
June 26, 2012 at 1:51 pm
sturner (6/26/2012)
archie flockhart (6/26/2012)
eventually you have to provide a viable service and actually make a profit or you go bankrupt.
Or you need to accept that there are some things...
- 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
June 26, 2012 at 1:42 pm
Agreed. This isn't a video game, where undocumented "easter eggs" are fun to discover. It's supposed to be an enterprise-level toolkit for managing data.
Imagine if you bought a...
- 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
June 26, 2012 at 6:52 am
You're welcome.
- 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
June 26, 2012 at 6:39 am
Jan Van der Eecken (6/25/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
June 26, 2012 at 6:32 am
I'd need to see the code for the triggers and the create scripts for the tables, before I could offer any help on this.
- 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
June 25, 2012 at 11:50 am
Nah. It's a perfectly good question.
Another thing to keep in mind about IsNull vs Coalesce is that Coalesce is ISO-standard SQL, and has some slight advantages because of that.
However,...
- 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
June 25, 2012 at 11:26 am
Matt Miller (#4) (6/25/2012)
GSquared (6/25/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
June 25, 2012 at 11:19 am
I'm not sure "we" are the right people to be marketing this career. Maybe "we" are, but doesn't that sort of get into the whole guild concept (master/journeyman/apprentice, 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
June 25, 2012 at 11:13 am
There are options beyond GetDate that may be more appropriate. Check here: http://msdn.microsoft.com/en-us/library/ms188383.aspx
Some of them include the time offset from UTC, so you can easily use those for EST/CST/EDT/CDT/Arizona-time/etc.
- 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
June 25, 2012 at 11:10 am
Matt Miller (#4) (6/25/2012)
GilaMonster (6/25/2012)
Matt Miller (#4) (6/25/2012)
Because the CHAR data type is defined as a fixed length type. What's the "length" of NULL?
One byte in the...
- 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
June 25, 2012 at 11:08 am
I'm going to recommend doing this in something other than T-SQL. Like a .NET assembly. Where you can use RegEx functionality for it.
However, if you insist on doing...
- 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
June 25, 2012 at 11:02 am
Matt Miller (#4) (6/25/2012)
Brandie Tarvin (6/25/2012)
Matt Miller (#4) (6/25/2012)
SQLRNNR (6/25/2012)
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?
Or the...
- 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
June 25, 2012 at 10:44 am
L' Eomot Inversé (6/20/2012)
But I may not find...
- 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
June 25, 2012 at 10:15 am
Viewing 15 posts - 1,321 through 1,335 (of 14,953 total)