Viewing 15 posts - 766 through 780 (of 1,195 total)
Hi - you've got some missing brackets here. You can either use:-
exec (@SQL)
or
exec sp_executesql @sql
If you use the second method you will have to declare @sql as ntext, nchar or...
-------------------------------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
May 10, 2013 at 1:27 am
crookj (4/30/2013)
L' Eomot Inversé (4/29/2013)
crookj (4/29/2013)
Revenant (4/29/2013)
BatmobileThe Black Beauty (and what show is this from?) 😉
Why switch from wheels or wings to legs?
Still talking very cool cars. Super hero...
-------------------------------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 30, 2013 at 8:21 am
Koen Verbeeck (4/26/2013)
Easy one to close off the week, thanks!
+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
April 26, 2013 at 1:01 am
Hi,
Firstly, you need to link the servers, after that it is fairly straight forwards:-
select * from database.schema.table1
inner join server.database.schema.table2
on . . . . . .
You only need to specify...
-------------------------------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 19, 2013 at 12:54 am
Thanks for the question Hugo - nice and easy to end the week on
-------------------------------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 19, 2013 at 12:44 am
Evil Kraig F (4/16/2013)
SQLRNNR (4/16/2013)
UniverseEgos
Id
-------------------------------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 17, 2013 at 2:42 am
Got my confirmation last week.
@WWDMark if it is as good as last years (my first) you'll enjoy it.
Know what you mean about the early start though!
-------------------------------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 28, 2013 at 4:46 am
Thanks for the question - easy point today
-------------------------------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 27, 2013 at 1:49 am
What is your criteria for the expected results?
The Name?
Id?
-------------------------------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 26, 2013 at 2:43 am
L' Eomot Inversé (3/22/2013)
Revenant (3/22/2013)
Terry300577 (3/22/2013)
YeggScrambled Yeggs
Not permitted in the USA: scambling a Yegg would be a cruel and unusual punishment.
True - but they might deserve it
-------------------------------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 22, 2013 at 11:23 am
You may need to check the servers this runs on for what @@datefirst is otherwise a quick stab at this is:-
IF DATEPART(dw, GETDATE()) = 1-- any time on Sunday
...
-------------------------------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 22, 2013 at 1:54 am
Slight change of topic (if there ever was one here). Over the past few weeks I have been trying to help out more with the questions posted here.
All I can...
-------------------------------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 21, 2013 at 12:35 pm
beat
-------------------------------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 21, 2013 at 12:04 pm
carlosaamaral (3/21/2013)
Sean Lange (3/21/2013)
carlosaamaral (3/21/2013)
MID=(CASE WHEN ID-100=0 THEN NULL
...
-------------------------------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 21, 2013 at 11:44 am
Eugene, quite right about the coalesce - it could end up being very messy and involved more that one query.
-------------------------------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 21, 2013 at 9:27 am
Viewing 15 posts - 766 through 780 (of 1,195 total)