You mean like this?

SELECT BENCHMARK,

SUM(Number_of_INC) AS [Sum of Incumbents],

AVG(Number_of_INC) AS [Average of Incumbents],

AVG(AVG_SALARY) AS [Average Salary],

AVG(PAY_RANGE_MIN) AS [Average Pay Range Min],

AVG(PAY_RANGE_MIDPT) AS [Average Pay Range Mid],...

Brandie Tarvin (9/10/2010)

---

It's like a raspberry, sticking one's tongue out, making the phbbt noise, and probably drenching everyone in the vicinity in the process.

You're the...

If you think there's room for improvement, then post it - don't be shy, we're all learners here.

Anyway, the coffee lands...

Brandie, what's @=Pbbt?

It looks like Cyclops eating a bacon butty badly.

Jeff's excellent article will explain string splitting - if you're unsure of anything, just ask.

This

(SELECT TOP 200 [n] = ROW_NUMBER() OVER(ORDER BY [name]) FROM master.dbo.syscolumns) n is a mini...

Similar to a groundsman then - who walks every day, frequently in circles 😛

There is no guarantee that rows will be returned in any particular unless ORDER BY is specified.

There is also no guarantee that rows will be inserted in a particular order,...

vani_r14 (9/8/2010)

---

[font="Tahoma"]

I have a function called Split and i would like to know - If can call that function in the where clause of Select Statement. This is a Table...

the_rutter (9/10/2010)

---

I'm actually a .NET developer with little SQL experience. I noticed this circular reference in a new project I am working on and it raised alarms in my head....

Look at it again. A cross join doesn't have to generate millions and millions of rows, and since you've got a filter on the derived table, this one won't, it...

The question is moot really. Since neither the derived table mostRecentStatus

nor the table orderlinestatus are joined to orders or orderlines, you have a cross join.

Try this instead:

SELECT

o.[Order],

ol.product,...

This couldn't have come at a better time, Wayne & I had something similar this week. Can you post the ddl for the table, along with a few INSERTs to...

Please post the ddl for the table, and the complete update statement which you are currently using.

Alvin Ramard (9/9/2010)

---

Jeff Moden (9/9/2010)

---

dave-dj (9/9/2010)

---

wow. Thanks for all the quick responses!. That's perfect thank you.

As always the ladies and gents of sqlserver central have been a great help.!

Everyday...

-- the stored procedure returns a DATETIME data type:

DECLARE @MyDate nvarchar(255)

SET @MyDate = GETDATE()

SELECT @MyDate

-- 'Sep 9 2010 4:46PM'

-- You need to CONVERT the output to a character...