Viewing 15 posts - 661 through 675 (of 1,195 total)
You would need to do an "insert into" based on the results from an inner join.
This might be a useful link http://technet.microsoft.com/en-us/library/ms188263(v=sql.105).aspx
-------------------------------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
March 31, 2014 at 2:55 am
Koen Verbeeck (3/31/2014)
WTH?The script doesn't mention sysadmin but database owner.
The created user doesn't have sysadmin permissions, so the table will be created using the default schema.
Points back please!
What Koen said...
-------------------------------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
March 31, 2014 at 1:49 am
Grant Fritchey (3/24/2014)
We're going to need you to come in this weekend to work on those TPS reports, mmmkay?
^ normally said at 3:30 Friday afternoon
-------------------------------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
March 25, 2014 at 2:02 am
BWFC (3/24/2014)
Revenant (3/23/2014)
TomThomson (3/23/2014)
Ed Wagner (3/21/2014)
BWFC (3/21/2014)
crookj (3/21/2014)
EricEyster (3/21/2014)
Ed Wagner (3/21/2014)
BWFC (3/21/2014)
WhoPinball
Wizard
Prestidigitator
Sleight
Hand
Pass
Mountain
Goat
Herd
-------------------------------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
March 24, 2014 at 4:35 am
BWFC (3/20/2014)
Ed Wagner (3/19/2014)
crookj (3/19/2014)
Revenant (3/19/2014)
Ed Wagner (3/19/2014)
SQLRNNR (3/19/2014)
parsenameQuotename
Delimiter
Pipe
Plumbing
Depths
Charge
-------------------------------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
March 20, 2014 at 2:20 am
Most of it comes down to personal / team preference - you should be trying to make life easier for yourself by knowing what something will be called rather than...
-------------------------------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
March 19, 2014 at 3:07 am
BWFC (3/18/2014)
SQLRNNR (3/18/2014)
EricEyster (3/17/2014)
Eric M Russell (3/17/2014)
JAZZ Master (3/17/2014)
Ed Wagner (3/17/2014)
Eric M Russell (3/17/2014)
JAZZ Master (3/17/2014)
Daniel Bowlin (3/17/2014)
Revenant (3/17/2014)
Eric M Russell (3/17/2014)
Ed Wagner (3/17/2014)
Eric M Russell (3/17/2014)
inaugurationStart
dissonance
discord
record
breaker
Peacemaker
Cheesemaker (or any maker...
-------------------------------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
March 18, 2014 at 7:29 am
You would at least need someone who knows what scripts to run in which order.
A junior DBA in other words 🙂
-------------------------------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
March 17, 2014 at 10:16 am
BWFC (3/14/2014)
Gaul
bladder
-------------------------------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
March 14, 2014 at 4:02 am
EricEyster (3/12/2014)
The Dixie Flatline (3/12/2014)
Ed Wagner (3/12/2014)
JAZZ Master (3/12/2014)
Ed Wagner (3/12/2014)
Kurt W. Zimmerman (3/12/2014)
Revenant (3/12/2014)
Ed Wagner (3/12/2014)
SQLRNNR (3/12/2014)
outputInput
Throughput
IOPS
FLOPS
Flop
Beach
Sonova
Sonoma
Wine
-------------------------------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
March 13, 2014 at 3:33 am
BWFC (3/12/2014)
SQLRNNR (3/11/2014)
crookj (3/11/2014)
EricEyster (3/11/2014)
Ed Wagner (3/11/2014)
EL Jerry (3/10/2014)
JAZZ Master (3/10/2014)
Kurt W. Zimmerman (3/10/2014)
SQLRNNR (3/10/2014)
trickoutwit
nitwit
Nitpick
User
ID-10-t error
picnic error (Problem in chair not in computer)
I like that one.
So do I....
Pickernick Basket...
-------------------------------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
March 12, 2014 at 2:31 am
OK - I'll jump in Jack.
Like you, to make managing security easier, we organise the folders / reports on business area so that the HR reports are in their own...
-------------------------------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
March 11, 2014 at 9:26 am
jaminbw (3/9/2014)
Thanks for this article. I relate to this so much.
I do want to be responsive to needs of operations but, I hate how often I am seen as...
-------------------------------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
March 10, 2014 at 8:36 am
One option is the bcp command. This link http://technet.microsoft.com/en-us/library/ms162802.aspx gives more info.
-------------------------------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
March 10, 2014 at 8:18 am
SQLRNNR (3/9/2014)
Woohoo, it depends.
+1
Thanks for the question
-------------------------------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
March 10, 2014 at 1:53 am
Viewing 15 posts - 661 through 675 (of 1,195 total)