If you are trying to split the lines into a table, why are you just returning the separators? Do you actually want separate rows in a table or???

If the...

It would be better, in the long run,...

Just curious... what does you "simple CLR function" do?

Just curious... what columns are you returning fo this?

You still haven't answered the very important question of...

What have you written a CLR for that you think can't be done in T-SQL? Dude... 😉

Since that's basically the correct way to do it, tell me... what do you mean it won't work?

It's a whole lot easier than you think...

SELECT Date-1

FROM Calendar

WHERE Day(Date) = 1

Oh, no... sorry if this sounds nasty but I wouldn't use any of those... especially (sorry to say) the "Celko" version...

Try this instead, please...

First, create a function like...

The bottom line is... if you expect the database to grow back to the same size in the next week or two, don't shrink it...

I've already proven that it will return more than one NEWID()... just not the way you did it because the view only returns one row. Go back and look...

ywb (7/6/2008)

---

Hi Jeff, just fyi, it's for a marketing application. We send promotion info to our users on a regular basis. Different promos are available to different number of users,...

I agree... WHY? The methods shown on those links do not accomplish the task requested (eventually) by the original poster....

colin Leversuch-Roberts (7/6/2008)

---

I have to agree with Jeff - there needs to be a better way of becoming certified without cramming with transender. I did one exam which I failed,...

There is no doubt in my mind... you would pass with flying colors because you never lie. 🙂

rbarryyoung (7/5/2008)

---

Jeff Moden (7/5/2008)

---

If you...