Okay, between the information you have been given on this thread and this one, you should be able to determine what you need to do at this point.

Jeff Moden (7/2/2009)

---

Lynn Pettis (7/2/2009)

---

Jeff,

Pretty sure I'm the first one SSC to use the Base 10. I just thought it reduced the number of cross joins to generate a...

scott_lotus (7/2/2009)

---

Thanks for the reply. Been chatting to a SQL contact at an ISP and he also mentioend NOLOCK (see below). taking into account what everyone has said in this...

Jay Tucker (7/2/2009)

---

Lynn,

The CONVERT function just wasn't doing anything, so I went back to what I usually use, which is DATEADD. I had forgotten that it was failing only...

Jeff,

Pretty sure I'm the first one SSC to use the Base 10. I just thought it reduced the number of cross joins to generate a large number of values....

Is this what you are trying to get?

select

aht.Asset_ID,

aht.To_User,

aht.To_Status,

convert(varchar(10),aht.Change_Date, 101) as Change_Date

from

...

I'm sorry, I don't know what you mean by UNIX format. When you select a datetime column from a SQL database, it displays a datetime value. I am...

I think part of the reason is that anyone can get the certification. Years ago when Novell began the...

Steve Jones - Editor (7/1/2009)

---

Perhaps not a great attitude, but that's not how I read it. Seems more like a cultural "terseness" that I see from many newbies in non-English...

Hey Barry,

What ever happened to the little green dude that was breathing down your neck a while ago?? 😉

Actually, I keep checking my calendar and I can't find ASAP. I can find Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday; but no ASAP. 😉 :w00t:

...

Digs (7/1/2009)

---

..Try It..

I am but my TEST data set only allows 30 or so selections..

Are you saying you are not sure if it can handle 100+ selections????

Please dont be...

Your Welcome, and thanks for the feedback.

Digs (7/1/2009)

---

Increase the size of the string.. I assume that means what I thought

String of different sizes

'1,2,3'

or

'1'

or

'1,2,3,5,6,7,9 ...etc to... 89,90,91,92'

So 92 IDs in the string, that would work also would...

jason brimhall (7/1/2009)

---

Why does it concern you? You may have moved all the user database objects out of the Primary filegroup, but that is where the system database objects...