Viewing 15 posts - 646 through 660 (of 1,195 total)
Thanks for the update.
Irrespective of which solution you use, test it on your system. All of the solutions work against the 10 or so rows provided, but what's the hit...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 25, 2014 at 6:45 am
Hi,
Thanks for supplying the data - it makes life easier for anyone answering your question - and it means you will get an answer quicker.
One (quick and dirty) way of...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 25, 2014 at 3:05 am
crookj (4/23/2014)
Ed Wagner (4/23/2014)
Revenant (4/23/2014)
Ed Wagner (4/23/2014)
SQLRNNR (4/23/2014)
periwinkleBullwinkle
Rocky
Stallone
Rambo
Rainbow
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 25, 2014 at 1:32 am
Hi Tomyum,
I'm sure we can help out, but it will be easier with sample data and tables.
Please see the first link in my signature block for the best way to...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 25, 2014 at 1:19 am
One more response for you
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 25, 2014 at 1:06 am
Koen Verbeeck (4/25/2014)
Easy one, thanks!(at the time of writing, 100% had the correct answer (20 attempts). Never seen that before)
Nope that's changed 93% of 30 answers now - 3% reckon...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 25, 2014 at 12:48 am
crookj (4/22/2014)
Ed Wagner (4/22/2014)
BWFC (4/22/2014)
Ed Wagner (4/21/2014)
crookj (4/21/2014)
Ed Wagner (4/21/2014)
SQLRNNR (4/20/2014)
TomThomson (4/20/2014)
SQLRNNR (4/20/2014)
Revenant (4/19/2014)
TomThomson (4/19/2014)
rhythmk (4/19/2014)
Ed Wagner (4/18/2014)
Revenant (4/18/2014)
BWFC (4/18/2014)
crookj (4/17/2014)
Ed Wagner (4/17/2014)
SQLRNNR (4/17/2014)
pretenseassumption
postulation
Theory
Science
Thought
Concept
idea
horse
with no name
no pain
no gain
Amplifier
Loudspeaker
Mother-in-Law
Outlaw
Colt
Kid...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 23, 2014 at 2:03 am
For the sake of completeness (and maybe reference for others).
The AD objects were migrated with SID history and nothing untowards happened 😀
All users were still able to see all the...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 23, 2014 at 2:02 am
With out seeing your code, I can't give any pointers for where the error may be happening.
The only advice I can give is that it will most likely be generated...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 23, 2014 at 1:00 am
First of all, you need to link the two servers (under server objects -> linked servers-> New linked server)
Then query the table in much the same way you would...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 23, 2014 at 12:51 am
SQLRNNR (4/14/2014)
balderdash
Pebbledash
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 15, 2014 at 12:58 am
a4apple (4/10/2014)
TomThomson (4/10/2014)
Ed Wagner (4/10/2014)
Kurt W. Zimmerman (4/10/2014)
Revenant (4/10/2014)
Ed Wagner (4/10/2014)
SQLRNNR (4/10/2014)
trackerHunt
Dogs
Sun
Set
Up
Bottom
Feeder
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 11, 2014 at 1:23 am
Ford Fairlane (4/10/2014)
Interesting QotD - Learned something here.
+1
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 11, 2014 at 12:41 am
That's because there is an active connection to the database. You need to make sure that there aren't any connections before you restore a database
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 4, 2014 at 1:03 am
Spot on Steve - this is the same way I've been telling others to do this when they have lost their passwords.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
April 1, 2014 at 1:38 am
Viewing 15 posts - 646 through 660 (of 1,195 total)