Can you just update your position column and set it to 73 minus what it is now?

Hockey has it figured out with the review process IMO. They have a group of people in a "War Room" in Toronto watching all the games every night. ...

Being a Cubs fan, I don't follow the AL too much but I knew Pujols has been struggling this year. I went and looked at his stat line and...

Thanks Hector, I like that approach. I've used dynamic SQL so little that I forget about it sometimes.

There was only about 6,000 in the customer table and 7 patterns we were looking for so it really wasn't an issue. This just got my curiosity up and...

With out posting any table definitions or sample data it's hard to tell, but I assume that it is the getdate() causing you problems. It will return the date...

Lynn Pettis (4/11/2012)

---

Take a close look at the code...

You'll want to partition the row_number by year as well if you are going to have dates with different years.

Well one could argue that "maybe" is never a wrong answer for...

calvo (4/9/2012)

---

Yeah, wooo baseball!

I was fortunate enough to get to the final exhibition game when the Red Sox came to town! Great game, lots of fun to watch the...

http://msdn.microsoft.com/en-us/library/ms187819(v=sql.105).aspx Yup, datetime rounds to the nearest .000, .003, or .007 seconds.

Probably, I am on both sites, but I use gmail so I don't worry about spam at all.

FOR XML is used to return query results in XML format. You can read more about it in the documentation. I don't know the in's and...

This should help.

declare @a table (agentid int, name varchar(10))

declare @C table (cityid int, name varchar(15))

declare @x table (agentid int, cityid int)

insert into @a

select 1,...

capn.hector (4/2/2012)

---

roryp 96873 (4/2/2012)

---

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...