Have you tried...

AndrewSQLDBA (2/10/2010)

---

Hello Everyone

Is anyone snowed in like me?

I am trying to add a single day to a date data type value

DECLARE @TodaysDate Date

DECLARE @TomorrowsDate Date

SET @TodaysDate = 2010-2-14

SET @TomorrowsDate =...

MauroPichiliani (2/10/2010)

---

Well, talking seriously now I made an attempt to run SQL Server in Linux through WINE (WIndows is Not an Emulator). If you guys want check out the...

I ran the following: select convert(datetime, '8/12/1430' , 131) and it returned 2009-11-25 00:00:00.000. Is that correct?

pink_panther (2/9/2010)

---

Hi Chris,

Actually zzzCovers table is not a real table in the database, I used it just to describe the issue isolated from the rest of the process. Let me...

Tom.Thomson (2/9/2010)

---

Because each answer tries to select from a table with a particular name in an completely...

Tom.Thomson (2/9/2010)

---

Rupal Raval (1/5/2010)

---

what error does it throw?

have you written

'declare @tablevariable varchar(100)

set @tablevariable = 'any valid table name'

Before code C?

map @tablevariable to one of your database table, select that...

Tom.Thomson (2/9/2010)

---

OK, I answered C because A and B are so completely wrong that C is the only option where we can reasonably guess that the setter of the question...

Are you getting an error of any type?

Are you still having problems opening the article? Just wondering, as I was able to click on the url and the article opened just...

Steve Jones - Editor (2/9/2010)

---

Didn't see that, but please do.

I was tempted to leave it. I'm still waiting for someone to go for an interview and have one of these...

Steve Jones - Editor (2/9/2010)

---

Roy,

Apologies on behalf of the community. I have removed the comment, which was inappropriate. I did not mail the guy since I don't think it would...

BaldingLoopMan (2/9/2010)

---

Lynn I do apologize for my comment to Roy. I also apologize for making an improper assumption about you gender. It was not intentional even though it sounded that...

BaldingLoopMan (2/9/2010)

---

You're right, we are. And we also can decide who we will help and who we won't.

Bye.

Lynn Pettis

===========================================================================

Food for thought and I think this is something we should all...

Nothing says we can't continue to work on a better solution, especially if it may benefit others that may be more appreciative of our efforts and are more professional in...