Please define "calendar format".

If you're using the date in a query, you'll want it to remain a DATETIME field unless the dates in your table are in some weird format.

--J

iklektic (5/25/2010)

---

Hi everyone;

I need your help! I'm trying to create a report that is going to list out the customer ID of all those clients that meet a very...

I had to do this very recently (last few days), and I ended up creating the stored procedure as a CLR. I wasn't sure how I felt about it...

Is it returning NULL instead? You could:

SET @lastQuartRewardState = ISNULL(@lastQuartRewardState, 'Absent')

... at the very end.

Also, you are erroneously using the table alias "et", without actually declaring it. You need to do one of the following:

1. Declare et: "FROM earned_transaction AS et"

2. Use...

Which line is the error on? You should have two END statements, one to match the BEGIN, and another to match the CASE. I don't see the second...

Because your stored procedure returns a single value instead of a rowset, I recommend using a FUNCTION rather than a PROCEDURE. Functions allow you a little more flexibility (like...

Pat,

SELECT and SET do not belong together.

SET allows you to do simple operations with variables

SET @date = GETDATE()

SET @int = 1

SELECT allows you to set variables from data in a...

You can set a BIT field to 2, but it will resolve to 1.

DECLARE @bit BIT

SET @bit = 2

SELECT @bit

Returns 1.

Instead:

SET @isLockOutPeriod = CASE

WHEN CAST(@currentDate AS...

pattamuthu (5/19/2010)

---

Thanks, i hope this will work, before give a try can u help to add a small thing, is that possible to generate the start date and end date...

SET @theDate = GETDATE()

bagofbirds-767347 (4/22/2010)

---

yeah, i'm kind of ribbing my boss a little; his reasons for maintaining separate dbs are solid, just not from a db design point of view. i think...

It's also worth noting that I have never handed over a project that wasn't paid for. I accept a deposit, do the work, demo it from a development server,...

I'd be concerned about being paid yourself. If they're willing to screw a company, what are the going to do to a solitary consultant? I'm not sure if...

hein-1120388 (4/20/2010)

---

Thanks. Seems a glaring hole in functionality though :/

I'll have to look at the firewall route for blocking the ranges, but then some clients connect from anywhere in the...