Viewing 15 posts - 5,821 through 5,835 (of 26,484 total)
Even with the picture I'm not sure what it is you want exactly.
Also, it may help if you provided more information including what you have tried so far. I...
October 25, 2014 at 7:51 am
After rechecking my sandbox, it looks like my code my still be valid, so here it is again.
CREATE TABLE #CandidateTable
(
ID INT IDENTITY PRIMARY KEY,
CandidateID INT,
Campaign INT,
Criteria VARCHAR(10),
[Status] VARCHAR(20)
)
CREATE TABLE #CriteriaTable
(
ID...
October 24, 2014 at 5:21 pm
Edit: Scratch my solution. Looks like not all the criteria are loading into the temp table.
October 24, 2014 at 5:09 pm
Is Campaign 3 not invalid since it does not exist in the CriteriaTable?
October 24, 2014 at 5:06 pm
Submitted and have received my approved TRF for redeploying back to the States at the end of February. Looks like I should seriously look at making plans to attend...
October 24, 2014 at 10:44 am
Steve Jones - SSC Editor (10/21/2014)
Good for you, Lynn. You coming back to the Springs, I assume?
Yes, sir. It feels good knowing that I will come home and not...
October 21, 2014 at 11:14 am
Lynn Pettis (10/20/2014)
What I was looking for was if there is a command line...
October 21, 2014 at 11:08 am
I thought there was a forum for the Redgate tools but I can't seem to find it.
What I was looking for was if there is a command line tool to...
October 20, 2014 at 5:34 pm
Ed Wagner (10/20/2014)
Lynn Pettis (10/20/2014)
Sean Lange (10/20/2014)
Lynn Pettis (10/20/2014)
October 20, 2014 at 1:20 pm
Sean Lange (10/20/2014)
Lynn Pettis (10/20/2014)
October 20, 2014 at 12:52 pm
Well, I was given good news and bad news today. Before I get to that, though, I go home for Christmas/New Years in 61 days! Only home for...
October 20, 2014 at 11:36 am
KoldCoffee (10/19/2014)
I guess you're not in Kabul, then.OK.
...
I was in Kabul initially, but we got "kicked out" of ISAF back in November 2013. I am now at Bagram Airfield....
October 20, 2014 at 7:13 am
KoldCoffee (10/19/2014)
In Left Outer JOIN everything is returned, period. That's because it's not an INNER JOIN but a LEFT OUTER.
Next, if there is a WHERE clause, results...
October 19, 2014 at 10:00 pm
KoldCoffee (10/19/2014)
the persontype comes from Person.Person. I aliased. Can you revise the explanation?
freakin' frustrating.
This looks simple enough and I understand the sentences and logic,...
October 19, 2014 at 9:19 pm
Hope this helps:
...
FROM
[AdventureWorks2008R2].[Person].[Person] p
INNER JOIN Person.PersonPhone pp
ON p.BusinessEntityID = pp.BusinessEntityID -- << Return all...
October 19, 2014 at 6:32 pm
Viewing 15 posts - 5,821 through 5,835 (of 26,484 total)