Viewing 15 posts - 1,921 through 1,935 (of 11,676 total)
Roy Ernest (9/4/2014)
There was not SQL Saturday this year. We will have one during memorial day weekend next year.
Jack, hopefully we can meet each other this time...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 1:32 pm
Grant Fritchey (9/4/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 1:31 pm
nishav2 (9/4/2014)
In C: drive i have many folders .
For example folders named like ABC,ARD,AVB,BGT,BHT etc...And these folders has many subfolders and files in it.
My Task is to search for a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 10:50 am
jcrawf02 (9/4/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 7:49 am
tbs.jignesh (9/4/2014)
You should provide the table and insert script for the same
Why? So you could cheat on the question?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 7:28 am
andrew gothard (9/4/2014)
Gazareth (9/3/2014)
I've just been told: "We don't recommend running SQL commands against the database"Right. May as well go home then!
You know Chris Date? Cool
Nah, Chris Date would...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 5:36 am
brett.y (9/4/2014)
It is true (of course) that the WHERE clause sorts out the LEFT OUTER JOIN (thanks). The only niggle is I remember moving the a.batch...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 4:39 am
With a LEFT JOIN, you take all the rows from the left table.
If AP4_packing_leg1_HSM_status has 7 rows, you will get 7 rows.
Putting a.batch = 105 in the ON clause doesn't...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 3:11 am
Knut Boehnert (9/4/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 2:25 am
smart_analyst (9/3/2014)
Does anyone else...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 12:40 am
Nice one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 12:33 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 12:32 am
This is a blog post, not a technical article.
Nice story, but I expected at least some scripts...
I hope this is an introduction to a great series about the combination of...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2014 at 12:26 am
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 3, 2014 at 1:18 pm
CELKO (9/3/2014)
You doing everything wrong.
Well, at least his English wasn't that bad 😉
And he didn't use ISNULL, seeing you have quite the aversion for T-SQL.
CELKO (9/3/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 3, 2014 at 1:15 pm
Viewing 15 posts - 1,921 through 1,935 (of 11,676 total)