Viewing 15 posts - 5,521 through 5,535 (of 26,490 total)
TomThomson (2/14/2015)
Lynn Pettis (2/7/2015)
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?Usually not - they're mostly American.
Okay, I'm insulted and I am not a Yankee fan.
That sounds as if...
February 14, 2015 at 10:52 am
... Mark one off, 14 days on the calendar to go. 14 days on the calendar to go, 14 days to go, ...
February 14, 2015 at 8:00 am
... Mark one off, 15 days on the calendar to go. 15 days on the calendar to go, 15 days to go, ...
February 12, 2015 at 7:15 pm
... Mark one off, 16 days on the calendar to go. 16 days on the calendar to go, 16 days to go, ...
February 11, 2015 at 10:50 pm
Sean Lange (2/11/2015)
Lynn Pettis (2/11/2015)
Sean Lange (2/11/2015)
Lynn Pettis (2/11/2015)
Sean Lange (2/11/2015)
Stubby Bunny (2/11/2015)
I have tried all of that, but nothing returns with the Top 1 clause, if I take that...
February 11, 2015 at 3:16 pm
Sean Lange (2/11/2015)
Lynn Pettis (2/11/2015)
Sean Lange (2/11/2015)
Stubby Bunny (2/11/2015)
I have tried all of that, but nothing returns with the Top 1 clause, if I take that out I get records...
February 11, 2015 at 3:10 pm
Sean Lange (2/11/2015)
Stubby Bunny (2/11/2015)
I have tried all of that, but nothing returns with the Top 1 clause, if I take that out I get records but it multiplies them...
February 11, 2015 at 3:04 pm
If you are wondering what the Duh! moment is, look at your sub query again. It will only return ONE row of data and that ONE row of data...
February 11, 2015 at 2:58 pm
Well, I just had a Duh! moment.
Change the LEFT JOIN to this:
outer apply (Select Top 1 strSn, strComputerName from Drat_Registration dr1 where dr1.strSN = dr.strSN group by strSN, strComputerName order...
February 11, 2015 at 2:56 pm
You may need to look at entry level positions like help desk or similar position. Unless you get hired on by a large corporation, you probably aren't going to...
February 11, 2015 at 2:46 pm
Also, looking back at what you posted, you only showed the data for one strSN. What you needed to look for was to see if any of them are...
February 11, 2015 at 2:27 pm
Stubby Bunny (2/11/2015)
it return multiple records on that side of the Join, but I only want the top record of that group, heres example
strSN ...
February 11, 2015 at 1:34 pm
Try running this and see what it returns:
Select strSn, strComputerName from Drat_Registration group by strSN, strComputerName, dttRegistration
Also, note the without an ORDER BY, you don't really know which pair of...
February 11, 2015 at 1:11 pm
... Mark one off, 17 days on the calendar to go. 17 days on the calendar to go, 17 days to go, ...
February 10, 2015 at 9:26 pm
... Mark one off, 18 days on the calendar to go. 18 days on the calendar to go, 18 days to go, ...
February 9, 2015 at 9:23 pm
Viewing 15 posts - 5,521 through 5,535 (of 26,490 total)