zippity dodah - i got it right.

thanks for the question

This has limited testing - you can try it.

SELECT o.name AS ObjName,i.name AS IdxName,i.index_id

,c.name AS ColName,ic.column_id AS IxColumnID

FROM sys.objects o

INNER JOIN sys.columns c

ON c.object_id = o.object_id

LEFT OUTER JOIN sys.indexes i

INNER...

shhh - don't tell your heart

Hugo Kornelis (3/21/2013)

---

(My original reply was much longer, but I lost it due to that stupid SQLServerCentral bug that tends to eat a reply when you worked on it for...

masoudk1990 (3/19/2013)

---

Thank you Horatiu, mickyT, Erin Ramsay for your time and help.

@SQLRNNR

May you help me to trace your code on paper please?

Im a newbie and im not sure how does...

Jeff Moden (3/18/2013)

---

Evil Kraig F (3/18/2013)

---

Ahhh, bitvector (bitmask, bitwise operators, combined flags, flagfield, etc...), my old friend.

Alright, let's start with the basics. You said you've read up on it...

Try this, but not really sure since the expected output is not entirely certain based on the thread

/*ID | Value

---------

1 | 19

2 | 90

3 | 20

4 | 8

5 | 9

*/

DECLARE...

Nice question.

Goodnight Gracie

😀

A few things come to mind real quick.

The use of cursors

The...

Lynn Pettis (3/15/2013)

---

Lynn Pettis (3/15/2013)

---

I am really trying not say anything more over ther, but is really difficult. Group time at the TitD.

Hi, My name is Lynn and I...

Lynn Pettis (3/15/2013)

---

SQLRNNR (3/15/2013)

---

Lynn Pettis (3/15/2013)

---

SQLRNNR (3/15/2013)

---

Jeff Moden (3/14/2013)

---

foxxo (3/14/2013)

---

http://googlereader.blogspot.com.au/2013/03/powering-down-google-reader.html

Sign up to the petition to keep it:

https://www.change.org/petitions/google-inc-please-do-not-shut-down-google-reader

I use it daily to keep track of several SQL blogs and it keeps...

Lynn Pettis (3/15/2013)

---

Naw, wait until we...

T - 845

And yes that would...