Why not? The only thing folks can do is execute a Bulk...

Absolutely. And, since you can't use an index by name in the...

There's no need for any local variables nor the flow control of IF in this function...

CREATE FUNCTION uf_future_classes --uf_future_classes 15

(

...

Thanks Tony. Just one more question... is your goal to create a text file for Lucene or are you just going to pass it through the API?

Just a note... if I need a decimal of a certain precision and scale, I always lookup the number of storage bytes for that precision and go for the highest...

The term "don't want to rock the boat" is frequently practiced at all levels of management in a large number corporations that I've been exposed to. They should practice...

pshvets (2/13/2009)

---

Hello,

I have a column which is integer data type and it represents number of seconds.

I need to convert it into MINUTES:SECONDS format.

Conversion of int into time is prohibited in...

Tony (2/13/2009)

---

Very nice! It's working and performs well.

I'll have to try this in similar places using functions and CTEs, and see what performs better.

I can end my week on...

Just an FYI for everyone in case there's a doubt... I've recently (10 minutes ago) had reason to move TempDB on one of my 2k5 dev boxes... it worked perfectly...

sushila (2/13/2009)

---

Jeff Moden (9/20/2007)

---

Thanks John and Rog... much appreciated!

You may be using the wrong layer to do database things in. The type of activety that you've both described should probably...

DURGESH (2/13/2009)

---

hi all,

i have a string as 'a;b;cde;f;ghi;d' or 'a;b;cde;f;ghi;defg'

now i want to split the given string as 'a;b;cde;f;ghi;' or 'a;b;cde;f;ghi;'

i tried using substring,left,charindex functions but i did not...

I think you'll find that Michael's solution is absolutely the fastest because it uses only 1 implicit conversion and it's not character based.

The term is "alias"... 😉

- do not Select INTO ____ , define the table and...

Please see the article at the link in my signature below. 😉

Grant Fritchey (2/12/2009)

---

GilaMonster (2/12/2009)

---

Eeep..

http://www.sqlservercentral.com/Forums/FindPost655667.aspx

I want to do a PhD in the area of database optimisers. Can anyone suggest a good topic?

Gees, it took me months of reading to decide on...