Viewing 15 posts - 1,531 through 1,545 (of 14,953 total)
Sean Lange (5/2/2012)
The "Having" clause allows you to do "Where clause" type stuff on aggregates, like Max(), Min(), Avg(), and so on.
sheesh in looking at my post I could have...
- 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
May 2, 2012 at 1:40 pm
Yes, the import/export tool will automtically copy schema names over if it doesn't find them. That's by design.
- 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
May 2, 2012 at 1:39 pm
I'd expect a statement complete event at the end of it, unless you've filtered the trace somehow.
- 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
May 2, 2012 at 1:36 pm
Try this:
SELECT Matters.FeeEarnerRef,
Entities.Code,
Matters.Number,
Entities.Name,
...
- 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
May 2, 2012 at 1:31 pm
DBA_SQL (5/2/2012)
Thank you so much. I actually need to mask the data. so i found this would be good option.
Figured as much.
Does the reason and solution make sense?
- 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
May 2, 2012 at 12:58 pm
That error message almost always means you're trying to pass Windows credentials more than one "hop". Search online for "Kerberos double-hop" and you'll find the details on what 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
May 2, 2012 at 12:52 pm
I keep a log of all DDL changes to all my databases, and I get that kind of information from there. Source control works as well if not better....
- 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
May 2, 2012 at 12:48 pm
Exact reason for the problem and solution to it posted on the other copy of this thread.
- 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
May 2, 2012 at 12:46 pm
Lynn Pettis (5/2/2012)
GSquared (5/2/2012)
Ignoring the infinite loop about where to post.Your update statement doesn't specify which row in Scramble matches which row in your random select.
Gus, use the other one.
Too...
- 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
May 2, 2012 at 12:45 pm
What you need is something comparable to this:
IF OBJECT_ID(N'tempdb..#SCRAMBLE') IS NOT NULL
DROP TABLE #SCRAMBLE ;
CREATE TABLE #SCRAMBLE
(FNAME VARCHAR(10),
...
- 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
May 2, 2012 at 12:45 pm
Ignoring the infinite loop about where to post.
Your update statement doesn't specify which row in Scramble matches which row in your random 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
May 2, 2012 at 12:38 pm
SQL Kiwi (5/2/2012)
GSquared (5/2/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
May 2, 2012 at 12:07 pm
Something like this?
IF OBJECT_ID(N'tempdb..#mytable') IS NOT NULL
DROP TABLE #mytable ;
CREATE TABLE #mytable
(event INT,
event_date DATE)
INSERT #mytable
VALUES...
- 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
May 2, 2012 at 11:54 am
Honestly, all I can say for sure is that it looks massively over-complicated for a standard purge process, and that I'd have to work with it in your data 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
May 2, 2012 at 11:34 am
RobertYoung (5/2/2012)
L' Eomot Inversé (5/2/2012)
The idea someone had that salesmen should be paid more because they have to look good doesn't hold water
I guess you not noticed the harlot hussy...
- 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
May 2, 2012 at 11:23 am
Viewing 15 posts - 1,531 through 1,545 (of 14,953 total)