Database

DECLARE @Mth1 varchar(5)
DECLARE @Yr1 varchar(5)
DECLARE @Mth2 varchar(5)
DECLARE @Yr2 varchar(5)

SET @Mth1 = '5'
SET @Yr1 = '2007'
SET @Mth2 = '8'
SET @Yr2 = '2007'

DtCol >= Convert(datetime, '01/' + @Mth1 + '/' + @yr1, 103) 
   AND DtCol < DateAdd(m, 1, Convert(datetime, '01/' + @Mth2 + '/' + @yr2, 103))

WDI wrote:

How can i kill all sessions from database to solve my problem?

sacheesach wrote:

I would like to mention that these lines have been coded by seeing Microsoft Help and I have not used the Wizard for creating this.

sacheesach wrote:

The problem that this code doesn't give any error

catch(SqlException e){} 

Affan Toor wrote:

There is a scenario in my application where i need to compare rows of a table with each other and if they match then store its one copy in another table

Declare YourCursor Cursor For
Select Coulumn1,Column2,Column3..... from your table
Open YourCursor
FETCH NEXT FROM YourCursor into @Columnvar1,@Columnvar2...
WHILE @@FETCH_STATUS <> -1
BEGIN
   --Select rows from table and insert to new table
   Insert into newtable
       Select columns fom table where column1=@Columnvar1, column2 = @Columnvar1
   FETCH NEXT FROM YourCursor into @Columnvar1,@Columnvar2...

END
Close YourCursor 
deallocate YourCursor
select * from newtable