Could we see the three UDF's and the query that uses them? Is the table scan occurring on a table which is being queried inside the UDF, or...

I just tried to look at the attachment for a recent Candidate Reviews post. Would someone carefully save it to disk first (without left-clicking on it), open...

Warning. Don't click on the link above. Save it and open it with notepad or some other editor first. I'm not quite...

Hey Paul, I was aware of how dropped columns are handled. I was just theorizing about how Michael got his one-second update. His later statement that...

Please post up a script to create a sample table with your date column, using the same datatype you are using in your production files. Populate it with...

I believe so, but I require further clarification. After rereading your initial post, let me give you the following examples and you tell me what the count should...

where date between '2009/05/01' and '2009/05/31' OR date is null

Using the sample table from the code above, will this do the trick for you? Ordering by newID basically randomizes it. Then the row_number() is assigned...

It creates yet another vulnerability, if you don't maintain control over who is allowed to execute which stored procedures. Someone more DBA focused could give you a...

So you are saying that you can't use the solution because it doesn't use the patindex, charindex functions? This sounds like a homework assignment to me. ...

You're very welcome, Michelle. Happy I could help.

(1) P-K4

(2) ...

Check this out. The basic plan is to populate a worktable with the last two orders for every serial#/categoryCode combination. RowNo = 1 is...

Hang on just a little while longer. Caught a rush job at my office.

I haven't forgotten you and the solution was half-coded before I...

The woman plays with edged weapons, Gus.

She can punt my posterior physically as well as technically 😉

I say this with GREAT respect.