Are you sure? Post the code with your changes.

Looks like it is coming down to Monday Night Footaball to determine who moves on to the championships.

asranantha (12/2/2012)

---

thanks its working fine. in this query i want modify when max salary then display yes and remaing sal column display no and when min salary then display...

asranantha (12/2/2012)

---

hi friend i have a small doubt in sql server plz tell me how to solve

table data contins like id,name,sal

...

Another question, startdate is 2012-12-02 (a Sunday) and you add 1 day, do you want 2012-12-03 or 2012-12-04? What if you add 0 days to the same date? ...

As I think about this more, your apparent requirement is that everytime you cross Sunday you need to add an additional day, correct?

Example, if the startdate is 2012-11-30 (a Friday)...

Lynn Pettis (12/2/2012)

---

You are going to have to tell me more than that it doesn't work. ...

You are going to have to tell me more than that it doesn't work. If I...

I still like mine, just had to modify the partition by clause. I believe this is also one that Paul White post.

CREATE TABLE [REV_BINDERS](

[OFFICE_ID] [int] NOT NULL,

[BINDER_ID] [int] NOT...

The two default instances can use the same port value for database mirroring. The named instance on the second system has to use a different port since it is...

Based on the original post, I'm thinking you want something like this:

declare @TestDate date = '20120101',

@DaysToAdd int = 8;

select

...

CELKO (12/1/2012)

---

NO! Display formatting is done in the presentation layers of any tiered architecture. The proprietary MONEY data type is left-over...

I'm not quite sure what you are asking for here. Are you trying to add 30 days to a given date such that you get a date x days...

karthik M (12/1/2012)

---

All,

I have recently faced the below scenario.

i.e to add comma as the thousand seperator

I have searched here and found the below query

select convert(varchar,cast(12345678918 as money),1)

how this query is...

Knowing that one system has one instance of SQL Server installed (default instance?) and another has two instances installed (a default and a named instance?), we now need to know...