Jeff Moden (4/27/2014)

---

priestxandar (4/27/2014)

---

Hi Jeff,

Thanks for trying to help me, i read those articles you send me, but i cant figure out how to use the info inside to help...

Hi Jeff,

Thanks for trying to help me, i read those articles you send me, but i cant figure out how to use the info inside to help my self. Dealing...

Thanks for the solution you provided to me, what i have realized is that when you unpivot the table i'm going to have duplicate values i need to omit them,...

ScottPletcher (4/17/2014)

---

DECLARE @parameter int

SET @parameter = 2 --NULL=ALL; spec. value = that value

SELECT

col1ID,

CASE WHEN COUNT(DISTINCT Col2ID) = 1 AND

...

Bit column will be bit data type only need to return 0 or 1.

when you query the temp table you will notice that:

col1ID|col2ID

1 ...

Could anyone help with this ?

Thank you

Hello again,

I've stacked on another cursor which is far more complicated for me. I would like to know if is possible to be rewritten to set-based and also to iTVF.

here...

Luis Cazares (3/31/2014)

---

It seems almost fine, but it's weird. You're not summing up the values. I added the SUM() and converted it to a iTVF. You need to test it...

Luis Cazares (3/28/2014)

---

This function can certainly be converted into an inline table-valued function. It's tricky, but it can be done and it has nothing to do with parameters as the...

WayneS (3/27/2014)

---

Well, hello there.

Luis - thanks for linking to my article. However, I'm afraid that it doesn't do much for helping to learn how to remove cursors. For that task,...

Its me again with another cursor (more difficult i think, at least for me 🙂 ) which i need to handle it to set-based, for any help, code suggestion I'll...

@SSCrazy

Thanks for explanation this was extremely helpful, couldn't find and ask for better explanation, thanks again you are awesome bro, great example!

how do you mean ? can you explain a bit ?