Kit G (2/17/2010)

---

cmallain (2/17/2010)

---

Or...has anyone considered that some of us do not know where to look and with being thrown into situations really do not have the time to...

Alvin Ramard (2/17/2010)

---

cmallain (2/17/2010)

---

Or...has anyone considered that some of us do not know where to look and with being thrown into situations really do not have the time to...

Or...has anyone considered that some of us do not know where to look and with being thrown into situations really do not have the time to do the research...

this is how I formatted the time (using msdb.dbo.sysjobs though...). I am fairly new to more advanced SQL so hopefully I didn't waste too much time after seeing that above...

All I needed was to number each row. I figured it out by doing the following:

select distinct

ListVal=count(a1.eventid) --listval can be any fieldname that you'd like

,a1.eventid

,a1.eventdesc

from...

HI, sorry if this is wrong place to put this but the example:

with

list as (

select

name as value,

row_number() over(order...