This may not answer your question directly, but I think it will help you figure it out, read this blog post: A Variable Length Random String.

I think you will find...

You know, there are a few people who just need to walk away from the computer and get a job flipping burgers or something.

aprasy (5/20/2009)

---

Hi All,

I am newbie in dba side. I have a question in backup. I had tried to backup the database...

If you really must, he's here.

Bob,

Steve locked the other thread before I could reply to you (that's what i get for reporting it to him).

Yes, we are getting close to 5,000 posts here.

Did you notice...

cos_ta393 (5/20/2009)

---

Hi,

I am experiencing an issue with missing job history and I am not sure what is going on. I do have SQL Server Agent properties for History configured using...

Best place to start, lookup functions in BOL (Books on-Line).

Looks like this post is now here.

Would you please post your query.

Not having any DDL or sample data available (sorry, but I'm not taking the time to create it), the simpliest way to do it based on what you have provided...

punsaonline (5/19/2009)

---

If Microsoft would have think that then you might not get 2005, then 2008 so on, as database service was working fine earlier with 2000 also.

I was just looking...

Then why worry about rewriting it in a different format?

Please post your query that uses this function.

In your original post, you said the first query returned in seconds. Did it return the expected...

punsaonline (5/19/2009)

---

Hi,

My Query previously looks like that

Select A.A1,B.B2

FROM A_TABLE A

INNER JOIN B_TABLE B

ON A.A1 = B.B1

WHERE B.B2 = 'XYZ'

This query executed in seconds but when i changed this query to

Select...