Viewing 15 posts - 106 through 120 (of 466 total)
Steve Jones - SSC Editor (9/28/2014)
that was a good move. Made a few myself. Hope one of them works out.
Looks like they might have. Rod has been the tough...
September 29, 2014 at 8:06 am
I'd assume that's where your problem is with your insert statement. I normally wouldn't bother with a merge for something like this. If it's just the two columns...
September 24, 2014 at 3:39 pm
Do you have duplicates on the key in your text file/temp table?
September 24, 2014 at 3:29 pm
rodjkidd (9/24/2014)
I just said to a colleague, excellent I now have a Tight End...American Football terms don't always translate well in a UK office.
Lol! It doesn't always translate in...
September 24, 2014 at 8:07 am
SQLDCH (9/22/2014)
iOS for me. I should have circled back and around and checked it again before Sunday but just never had the time.
Well, it looks like it didn't matter...
September 23, 2014 at 8:33 am
SQLDCH (9/22/2014)
Keith Tate (9/22/2014)
SQLDCH (9/22/2014)
September 22, 2014 at 4:12 pm
SQLDCH (9/22/2014)
iOS for me.
Well there's your problem. 😛 Maybe if you upgrade to the iPhone 6 the app will start to work correctly? You'll probably have to...
September 22, 2014 at 1:46 pm
SQLDCH (9/22/2014)
September 22, 2014 at 12:27 pm
EL Jerry (9/18/2014)
SQLDCH (9/17/2014)
El Jerry, update your lineup with an active Tight End. Tony Gonzalez is retired.
Just did last night. Now I have more reasons to not like/trust the...
September 18, 2014 at 8:17 am
SQLDCH (9/16/2014)
roryp 96873 (9/15/2014)
SQLDCH (9/15/2014)
I got lucky and didn't yank Marshall even though all reports said he wouldn't be playing. I'd rather be lucky than good.
HA! Glad I...
September 17, 2014 at 8:30 am
SQLDCH (9/15/2014)
I got lucky and didn't yank Marshall even though all reports said he wouldn't be playing. I'd rather be lucky than good.
HA! Glad I wasn't up against...
September 15, 2014 at 4:10 pm
Steve Jones - SSC Editor (9/7/2014)
Thanks, Romo. Way to start my season.
I thought everyone knew by now that you should not trust Tony Romo.
September 8, 2014 at 8:20 am
Probably not a big deal, but maybe you would want to order by the tContact.ContactID instead of the first name in case you have a situation like George Foreman where...
September 4, 2014 at 8:06 am
Or another way with an exists and no cte, there's probably a million different ways to do this...
select r.ContactId, c.FirstName, c.LastName, c.DOB, ROW_NUMBER() OVER (PARTITION BY r.ParentContactId ORDER BY r.ParentContactId)...
September 3, 2014 at 3:19 pm
Adding DOB in your cte select and then doing an exists in the main query should return what you are looking for I believe.
WITH cteMultipleBirths AS (
SELECT
t.ParentContactId, tContact.DOB
FROM #Relationship AS...
September 3, 2014 at 3:10 pm
Viewing 15 posts - 106 through 120 (of 466 total)