skenzie (8/24/2008)

---

HI,

I've been thinking of applying for a job that involves looking after a Management Information System, i.e. mainly showing people how to use it and querying it to provide...

I am curious how...

I agree with Carl, breaking this function apart into a master function with separate subfunctions is your highest return.

You already have almost all of the code, you just need to...

amicusoft (8/22/2008)

---

please remember the first posting.

the statements are the same, only the way i call the statements is different.

....

the function-call takes 16 minutes, the script-call only 30 seconds.

the...

Grant: I think that the UDF listing is back on page one...

amicusoft: I seems very likely that the run-time difference here is due to "parameter-sniffing". You have lots of...

Can you write stored procedures and/or functions on the database?

?!?

Sure, try it.

JKSQL (8/22/2008)

---

Thanks I appreciate the feedback. We used the isolation on another solution that worked well. We are currently using timestamp all over to make sure we are...

Frankly, this looks like a SQL Server bug to me. Looks like the later build may have fixed it.

Create the execution plan in a Query Window (Ctrl-L). Then rgot to the results pane and right-click, pick "Save exectution Plan as.."....

OK, now that's weird.

Please post the function code listing also.

The way to check for a space at the end is:

Select Ascii(Right(@string, 1))

A space will return 32. Any other value is not a space (TAB returns a 9).

For instance,...

Back when I used to work in Artificial Intelligence we used tell a couple of one-liners that we actually made into pins to wear at conventions:

"Artificial Intelligence: It's better than...

John R. Hanson (8/21/2008)

---

These are Important Ideas even more so today, as Enterprise Data is growing. My concern with the solution is that you are inserting rows to the table,...