Viewing 15 posts - 2,131 through 2,145 (of 14,953 total)
Jack Corbett (1/26/2012)
IF 1 = 1 -- Placeholder in case there is an actual conditional 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
January 27, 2012 at 6:23 am
Koen Verbeeck (1/26/2012)
GSquared (1/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
January 27, 2012 at 6:18 am
Honestly, you're going to have to go with two (or more steps). Do a Merge into the UsersAuth table using a join between your staging table and the Users...
- 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
January 26, 2012 at 12:25 pm
SQLRNNR (1/26/2012)
GSquared (1/26/2012)
Brandie Tarvin (1/26/2012)
jcrawf02 (1/26/2012)
swell. http://arstechnica.com/business/news/2012/01/symantec-says-anonymous-stole-source-code-tells-customers-to-disable-security-product.ars
Well, that explains a few things.
Humor for the day. I just gave a speech at our workplace communications club based on a blog...
- 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
January 26, 2012 at 12:11 pm
It's not an IMEX issue. Those cause NULLs instead of text/numeric data, depending on which one it thinks the column is based on a 4-row sample. They don'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
January 26, 2012 at 11:37 am
The only way I can think of to divert an insert from one place to another would be to do the Merge command on a View that queries both tables,...
- 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
January 26, 2012 at 11:04 am
There's another problem with the stored procedure definition in the first post. "Return" in procs can only work with integer values. It can't return strings, but it's defined...
- 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
January 26, 2012 at 10:56 am
Brandie Tarvin (1/26/2012)
jcrawf02 (1/26/2012)
swell. http://arstechnica.com/business/news/2012/01/symantec-says-anonymous-stole-source-code-tells-customers-to-disable-security-product.ars
Well, that explains a few things.
Humor for the day. I just gave a speech at our workplace communications club based on a blog post 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
January 26, 2012 at 10:04 am
Encrypt your input parameters using the same encryption method as you data. Compare the encrypted parameter value to the encrypted column value in your Where clause. That should...
- 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
January 26, 2012 at 7:17 am
Okay.
Here's one way that might make this more efficient:
IF OBJECT_ID(N'tempdb..#raw') IS NOT NULL
DROP TABLE #raw ;
CREATE TABLE #raw
([tableID] [int] NOT NULL,
...
- 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
January 26, 2012 at 7:14 am
The lack of a proper dev environment is the real problem, most likely.
Lots of companies, perhaps most, have policies in place that only the DBA has access to production database...
- 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
January 25, 2012 at 2:03 pm
Stefan Krzywicki (1/25/2012)
Evil Kraig F (1/25/2012)
SQL Kiwi (1/25/2012)
Steve Jones - SSC Editor (1/25/2012)
SQL Kiwi (1/25/2012)
Steve Jones - SSC Editor (1/25/2012)
Maybe you can do this?
If we had ever met in...
- 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
January 25, 2012 at 1:56 pm
jcrawf02 (1/25/2012)
Steve Jones - SSC Editor (1/25/2012)
SQL Kiwi (1/24/2012)
Steve Jones - SSC Editor (1/24/2012)
But you can ski?
I tried snowboarding once (in a supervised inside environment[/url]) and that was enough to...
- 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
January 25, 2012 at 11:44 am
Okay.
8950 isn't a valid Zip code, but I get the idea of what you're saying.
Are there potentially fields with numeric data in them that might mimic a Zip code, but...
- 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
January 25, 2012 at 11:41 am
Judging by the business rule, one cancellation matches up to one and only one regular transaction, and a regular transaction can have zero or one cancellations, but not more than...
- 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
January 25, 2012 at 11:37 am
Viewing 15 posts - 2,131 through 2,145 (of 14,953 total)