Viewing 15 posts - 2,266 through 2,280 (of 14,953 total)
I'm more used to "funny" denormalization cases. Busy fixing a bunch of performance problems caused by an EAV structure right now.
In your case, it sounds like your bitmapping 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
January 13, 2012 at 11:31 am
Create a group called something like "LibraryExecutors" (sounds bad, you might think of a better name), put everyone in it, grant that group execute rights in your library 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 13, 2012 at 11:29 am
You won't be able to do text data (varchar) in the same column as binary data (image/varbinary).
It'll either need to be two separate datasets (some front end applications can deal...
- 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 13, 2012 at 11:25 am
You mention declaring Tag_image as image. Not sure what you mean. Do you have a variable or column named Tag_image, and you want to use the Image datatype...
- 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 13, 2012 at 9:49 am
Will the input value always be a formatted phone number with a 3-digit extension?
If so, you can brute-force it pretty easily:
DECLARE @Input CHAR(22) = '(915) 676-9090 ext 303', @Output CHAR(22);
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
January 13, 2012 at 9:09 am
jez.lisle (1/13/2012)
I need to be able to Insert or Update the fields depending on what the source table has done.
Yes, but if there are two (or more) rows 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
January 13, 2012 at 8:18 am
You'll need to dig into Kerberos in your case. It's definitely a double-hop issue.
Most often, Kerberos issues are handled by network admin personnel, not by the DBA. 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 13, 2012 at 8:17 am
L' Eomot Inversé (1/13/2012)
Divine Flame (1/13/2012)
L' Eomot Inversé (1/12/2012)
edit: I haven't looked at the posting history - just the the thread referenced here and the first thread it references -...
- 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 13, 2012 at 8:12 am
When you click Add Reply to a thread, there's an option at the bottom of the screen for what subscription you want. It sets that as your default when...
- 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 13, 2012 at 8:02 am
jez.lisle (1/13/2012)
One thing I do have a question on is this
I get this error below
Msg 8672, Level 16, State...
- 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 13, 2012 at 8:00 am
L' Eomot Inversé (1/12/2012)
Grant Fritchey (1/12/2012)
GilaMonster (1/12/2012)
Evil Kraig F (1/11/2012)
GilaMonster (1/11/2012)
Errrrr... Someone(s) want to tackle this? http://www.sqlservercentral.com/Forums/Topic1234441-61-1.aspxAlready responded. I'm waiting to see his answer before continuing.
I just had 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
January 13, 2012 at 7:04 am
I looked around a bit, and it seems the most common solution is to put a button on the page hosting the report, and have the button call a .NET...
- 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 13, 2012 at 6:52 am
In production code, I always use meaningful names, and avoid collision explicitly. I've never tried using temp tables with the same names in the same scope. I just...
- 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 13, 2012 at 6:45 am
L' Eomot Inversé (1/12/2012)
Jack Corbett (1/12/2012)
I don't see the only person who replied doing anything to get upset about or reply rudely or unprofessionally to.
I disagree with you...
- 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 13, 2012 at 6:38 am
Do I need to run file 04 before running 05, or are they separate processes?
I may have misread it. I thought 04 and 05 were two versions of 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
January 12, 2012 at 2:44 pm
Viewing 15 posts - 2,266 through 2,280 (of 14,953 total)