Yes, we all know too well that sometimes the hardest problem we work on is right in front of our face. :hehe:

You're close ...

select count(*) as employeeCnt from foo

If the target table has an identity column defined, then don't include it in your insert statement and it will be automatically populated at the time of insert.

Jeff Moden (4/29/2008)

---

I guess I...

You can't do that type of conditional logic in views. Study up on stored procedures. 😀

then just change the CTE to a temp table. 😀

CREATE TABLE #pridLimits (prid VARCHAR(55), minDate DATETIME, maxDate DATETIME)

INSERT #pridLimits

SELECT

...

Karthik,

Take a look at this. It does what you want. See if you understand it, and if you should have any questions, I'd be happy to answer them... 😀

DECLARE @NullPform...

OOPS, you need to add in a zero, for the date selected to show up...

WITH mData

AS (SELECT

DATEDIFF(DAY,date_enrolled,'4/16/2008') AS dayNumber,

...

Set up test data ...

DECLARE @booksdata TABLE

(date_enrolled [datetime],

book_name varchar(50),

author_name varchar(100),

book_visited float)

...

Can there be more than one book_visted for one enrolled_date, or is that a count? Is there a maximum number of days they can select?

Please post your CREATE TABLE statement and some sample data (in the form of an INSERT statement) so we can help you more effectively. 😀

Karthik,

What is it that you are trying to accomplish? I understand that you want to go "Set Based", but what is the goal of the procedure?

ABC will never equal NULL.

you'd need to rewrite it. One possibility is

SELECT

...

WHERE

(ABC IS NULL AND @abc = '')

...

Since you have 2 instances of that column, you need to tell SQL which one to order by ..

select distinct a.cwono , a.dorder, a.drequest, a.lhold, a.csono, a.ccustno

from miword...

chinna (4/23/2008)

---

i am a bit weak in sql coding so let me know if it satisfies my condition which is if all the 4 columns are zero then we use...