Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
R.Prabu
Starting Member
33 Posts |
 Posted - 2008-07-01 : 15:53:11
|
| My Table name is IncomeDetails in this table havingName TypeofIncome Month Year---- ------------- ---- ----A Rent 2 2007A Rent 3 2007I need to display Remaining arrears months except 2 and 3 I am also having the month Table The DDL IsSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[HSSPMS_Tbl_Month]([Id] [int] IDENTITY(1,1) NOT NULL,[Month] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,CONSTRAINT [PK_HSSPMS_Tbl_Month] PRIMARY KEY CLUSTERED([Id] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFtell me how to display Arrears monthRegards,Prabu RRegards,Prabu RRegards,Prabu R |
|
|
|
|
|
Rent Arrear Months