You can write a CASE statement and return the greatest among the First Date Of The Month and the First Date Of The Week

DECLARE@from_date DATETIME

SET@from_date = '02-Sep-2011'

SELECTCASE

WHEN DATEADD( MONTH, DATEDIFF(...

Jeff Moden (7/22/2011)

---

Just for the record, it will also delete the wrong data if the right 3 occurs more than once...

hxkresl (6/30/2011)

---

In pl/sql it's possible to create a CHECK constraints based on a query of values in another table. Is the same posssible in SQL? My searches on...

Thanks for the replies folks. I will check the ARITHABORT and the ANSI WARNINGS option along with the connection settings.

I don't have much idea about the connection settings.

But i remember in my previous case, a query in a derived table was returning a zero value for a particular column...

You can create a single trigger for all three operations( INSERT, UPDATE and DELETE )

Inside the trigger you will have write programming logic to INSERT values in Status table based...

A trigger would be better as that would also help you to track if somebody has inserted, updated or deleted an Order from outside your C# Application.

I think...

Did you test if the results are correct? Adding a TOP 1 query would avoid the error but will most probably give you incorrect results. Please provide...

This should help you out

DECLARE @tbl_Table1 TABLE

(

Sequence_id INT,

idINT,

NameVARCHAR(100),

[Key]INT,

item_nameVARCHAR(100),

rule_idINT

)

DECLARE@tbl_Table2 TABLE

(

rule_id INT,

Name VARCHAR(100)

)

INSERT INTO @tbl_Table1 VALUES( 1, 6761, 'Includes', 0, NULL, NULL )

INSERT INTO @tbl_Table1 VALUES( 2, 6761, 'item', 160, 'abc', NULL...

This will give you the desired information

SELECTJ.name, J.description, JS.step_name, JS.database_name

FROMmsdb.dbo.sysjobs J

INNER JOIN msdb.dbo.sysjobsteps JS ON J.job_id = JS.job_id

WHEREJS.database_name IN ( 'database1', 'database2' ) -- List your databases here

When i run the code with a date of 15-January-2010, I get the CurrentYearBeginDate as 01-April-2010. Should it not be 01-April-2009?

New Commer (12/28/2010)

---

Abhijeet Chavan (12/28/2010)

---

Some changes

DECLARE @CYBeginDate smalldatetime, @CYEndDate smalldatetime,

@LYBeginDate smalldatetime, @LYEndDate smalldatetime

select @CYBeginDate = dateadd(year, datepart(year, getdate()) - 1900, '1900-04-01')

select @CYEndDate = dateadd(day, -1, dateadd(month, 12, @CYBeginDate))

select @LYBeginDate...

New Commer (12/27/2010)

---

DECLARE @CYBeginDate VARCHAR(10)

DECLARE @CYEndDate VARCHAR(10)

DECLARE @LYBeginDate VARCHAR(10)

DECLARE @LYEndDate VARCHAR(10)

DECLARE @CYDate DATETIME

DECLARE @LYDate DATETIME

SET @CYDate = GETDATE()

--Test Data

SET @CYDate = (Select Case When MONTH(GETDATE()) between...

New Commer (12/27/2010)

---

Sorry i didn't get you.

Actually the query willo be run at any time and it has to take care by itself to result with the current yr data...