Hi,

I found this source in http://www.sqlteam.com. You may solve your problem easily.

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER  PROCEDURE CompareTables(@table1 varchar(100),  @table2 Varchar(100),

@T1ColumnList varchar(1000), @T2ColumnList varchar(1000) = '')

AS

-- Table1,...

Hi,

Try to do like this.

declare @no float

set @no=12

Select @no

Rafiq 🙂

Just do this SQL-Statement.

Select Convert(DateTime,Convert(Varchar(4),DatePart(YYYY, GetDATE()))

+'/'+Convert(Varchar(2),DatePart(mm,GetDate()))+'/'+'01') - 1

quote:

---

Do you have any idea how to find the last day of the previous month?

The select I have below works, however I...