Steve, would you consider a worktable as being the third type of a temp table? 😉

From...

WayneS (4/7/2010)

---

Some places use a 6 month contract to "try you out". If you do a good job, they'll turn it into a FT job. If not, bye bye. Can...

I'm not sure if I fully understood the requirement...

But I would consider building a permanent table holding all variations and query that one based on the number of shippings.

Maybe the...

Tom.Thomson (4/6/2010)

---

You know, the first time I played with a computer was in 1966 (it was the Ferranti-Packard Orion II at RHEL) and by the middle of 1970 I had...

That's easy: It depends 😀

You need to think about what's best for YOU. It's not relevant what we think would be best for us. Some of us might vote for...

Looking back without relevant trace files in place during that time is probably hard to do (if possible at all).

I would ask the developer to wrap that query into a...

I'd rather test for a number instead of using the ISNUMERIC function.

Among others, "+-.," are valid when testing against ISNUMERIC

Example:

DECLARE @test-2 CHAR(3)

SET @test-2 ='.10'

SELECT ISNUMERIC(LEFT(@test,1)),CASE WHEN @test-2 LIKE '[0-9]%' THEN...

Thank you, RV!

I hope one or the other method is useful, not only for the OP.

I'm working in project management, sometimes as a project manager, sometimes as a "link to translate" between business reps and software vendor.

Since I'm focused on SQL Server projects, I decided...

Hi,

here's a rather large sample of various methods using XQuery.

Unfortunately, you didn't provide a "translation list", meaning what nodes you'd like to see in what column. Therefore, I had to...

@ Paul:

Interesting!

What do I misread/misunderstand when reading BOL?

I thought what you just demonstrated wouldn't be possible...

It looks like query optimizer is using ISNULL to override the columns NULL definition.

VERY NICE!!...

Paul White NZ (4/6/2010)

---

The problem here is not one...

I'll second RV.

Using XQuery inside a stored procedure is most probably the easier way.

If you need assistance please post sample data and expected result in a ready to use format...

I guess I...

Why don't you use a view instead?

And, if you really want to use a UDF, at least use a table-valued function.

Something like

CREATE FUNCTION your_function (@ParentID int, @Keyword nvarchar(255))

RETURNS TABLE

AS

RETURN

(

...