Give this a try:

CREATE PROCEDURE ...............

@LanguageID Int,

@Type Int,

@DateStart DateTime,

@DateEnd DateTime

AS

BEGIN

SET NOCOUNT ON;

with ClientExitCount(

ClientUrlID,

...

I think this is what you are looking for:

declare @PayWeek int;

set @PayWeek = 1; -- just a value for illustration purposes

select

jkt.Mechanic,

sum(case when...

It's simple why you wouldn't want to do that. First of all the data types VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) are blob data types that can hold up to 2...

I'd like to see a little more, including the DDL for the tables, some sample data for the tables (in a readily consumable format, not like how you posted the...

Which is...

Gaby Abed (4/29/2009)

---

GilaMonster (4/29/2009)

---

tosscrosby (4/29/2009)

---

Lynn Pettis (4/28/2009)

---

You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is...

That is dependent on how and where you use the SQL functions in the WHERE clause.

GSquared (4/28/2009)

---

I don't watch TV, so I have absolutely no clue what...

Bruce W Cassidy (4/28/2009)

---

[font="Verdana"]This morning I had an idea. After I had had a bit of a sit down to recover from that novel feeling, and to reassure myself...

Albatross ...

Check COLUMNPROPERTY in Books Online. You can use this function to determine is a column is an identity column.

gserdijn (4/28/2009)

---

This was what I intended for the problem on page 8 which happens to look much the same as Samuel Vella's solution.

SET ROWCOUNT 5000;

SELECT IDENTITY(INT,0,1) AS id INTO #Tally...

William Plourde (4/28/2009)

---

Thanks for the replies. I was able to get both examples to work and since I have not been using CTE it was a good excuse to read...

Well, if you must know... this is his latest thread

😉

GSquared (4/28/2009)

---

Lynn Pettis (4/28/2009)

---

Bob Hovious (4/28/2009)

---

Somewhere that man is getting...