kryknot is wrong.

SQL will always return RETURN value. You have no control over it. The only thing you can do is to change the default value of 0 to...

I think Nirmal might need something like this

declare @skills table (Resource_Id int, Skill_Id varchar(20))

insert into @skills

select 101, 'sqlserver' union all

select 101, 'vb.net' union all

select 101,...

I wish the encryption worked. The current implementation is a joke and as such is useless. I think there are many cases when one would like or must encrypt the...

Gift Peddie (4/7/2009)

---

I have just looked at that application the US government will not even issue trade mark for crap people like me can create in our sleep with most...

Chris,

I thought you were heading to a pub...:-P

Drop the last grouping

Change from

GROUP BY Col_1, Col_2, Col_5

to this

GROUP BY Col_1, Col_2

Does it work now?

maybe my typo messed it up.

The line

GROUP BY Col_1, Col_2, Col_3

should be

GROUP BY Col_1, Col_2, Col_5

5 instead of 3

If it is not this then I think I am...

Chris Morris (4/6/2009)

---

Jack Corbett (4/6/2009)

---

Chris Morris (4/6/2009)

---

Jack Corbett (4/6/2009)

---

One problem with your first query is that it includes the columns you want the MAX for in the GROUP BY so...

Is this what you need? (It is hard to figure out what do you really need)

SELECT Col_1, Col_2, Col_3, Col_4, Col_5

FROM Table

INNER JOIN (

SELECT

MAX(Col_3) AS max_col_3,

MAX(Col_4) AS...

No problem.

Been there, got burnt... 😉

The biggest surprise was that this is ANSI_NULLs independent. Regardless how you have this option set. ON or OFF the NULLs are not equal. I...

CONVERT alone will not help you.

You need to do a little string manipulation.

If your date field is a string

DECLARE @Date VARCHAR(10)

SET @Date = '2009-31-12' --YYYY-DD-MM

SELECT @Date =...

Florian Reischl (4/2/2009)

---

David,

What about this:

SELECT *

FROM mytab

WHERE col1 = ISNULL(@col1, col1)

AND col2 = ISNULL(@col2, col2)

...

That might be an old habit of people who worked with earlier versions of SQL Server. The 255 was the maximum supported by the server.

No problem, great script.

I could not resist the temptation and was trying to play an April's Fool joke on you. 😀

Thanks.

Can you provide a link?...