Sorry additional note. This too oddly enough fails with the same error.

select * from

(

SELECT

Dates,

(CASE WHEN DATEPART(dw,Dates) IN (2,3,4,5,6) THEN 1 ELSE 0 END) DOFW

FROM

(

SELECT

cast(

cast(nYear as varchar(4)) +

right('0' +...

I commonly find myself having to add dates to support tables which would on occasion be forgotten.

So I worked this out for quick drop in which met out needs. Plus...

kwitzell (1/16/2009)

---

Personally I don't think it is any ones business what I make however, working for a city government, we don't get a choice; our salaries are very public knowledge....

I for one don't care who knows my rate. However with that said there are just too many petty people out there. People who on the slightest think their pay...

I think you have to find a good mix but I think a lot of people get bogged down in documentation more than they should. Over a period of time...

I will first say this is a decent article and expresses a concept that some people can use. However a few things I would note.

1) If you loose the hanle...

rana_subhankar (9/30/2008)

---

Can U explain in detail when we are joinning 4 tables what will happen?

1. Joining type - Inner Join

2. Joining type - Left Outer Join

3. Joining type - Right...

Before I get into my first impression I will say it is a good article. And you should be aware people can have specific habits they don't realize which can...

Good item for starters, Brian. My only thought is you should have explained that you can submit values in variable order without specifying the names and that you can submit...

Good article. We have been using Op Manager for a while and even thou it isn't my responsibility to monitor I have certain events emailed to me as I am...

Yeah, just PM the details of how you are doing you oracle pulls and not what objects you use. Also include the message as I found instances where I had...

First off I will say it was a nice article and offers so good alternatives. However I will point out two things.

First, in part one there is a " missing...

I use INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN just for clarity. I realize that INNER and OUTER are implied, but that's just how I...

Steve Jones - Editor (7/8/2008)

---

It is a presumption that everyone here knows these basics. New people come to the site every day, and to SQL Server for that matter. We...

Crazy Canuck (7/8/2008)

---

Hmmm - I think someone should have taken a look at this article before it was published.

Cartesian products are rarely useful and are typically only used...