capn.hector (4/2/2012)

---

roryp 96873 (4/2/2012)

---

Something like this?

declare @myDate date

set @myDate = '2012-04-02'

select @myDate as myDate

Obviously this is really simple, but you can use the @myDate in calculations or comparisions like you...

Something like this?

declare @myDate date

set @myDate = '2012-04-02'

select @myDate as myDate

Obviously this is really simple, but you can use the @myDate in calculations or comparisions like you would any other...

No problem. Checking out the documentation can help give you a better understanding of the difference between the two if you are still having troubles.

Inner Joins

Outer Joins

Just do an inner join instead of a full outer join.

Also, in case anyone missed it, Magic Johnson's group is to purchase the...

http://www.sqlservercentral.com/Forums/Topic1269914-391-1.aspx

Only if there are no single quotes within the address field.

capn.hector (3/20/2012)

---

roryp 96873 (3/20/2012)

---

I figured as much as well, but if...

I figured as much as well, but if they can't even...

This is a pretty popular problem and can be googled for numerous solutions. Here's a slick one courtesy of the DBA I work with:

;WITH fb as(

select * from...

john.arnott (3/19/2012)

---

Sure, there's a point to be made about going out with dignity, knowing when to quit and all that, but the competitive spirit that makes an athlete commit his...

If ALL addresses have the start and end quote, you could do something like this:

select stuff(stuff(MyAddr, LEN(MyAddr), 1, ''), 1, 1, '')

from MyTable

I agree with Lutz, it is a little unclear what you want here. You have max date in your query but you have all the same dates. Do...

Nice easy question. Still got me to go dig into BOL to make sure I had the right answer before I clicked submit though, so thank you!

Either way I think it is pretty stupid to have different rules between the two leagues, make it the same for both leagues. Although I would take the more...