I'm accustomed to doing this via VB.NET CLR functions in SQL Server 2005...

"as" then column alias in a Where clause.

Which won't parse.

Which means it's not the actual...

Because it's not actually a hierarchy, a recursive CTE isn't the right way to do this. You'll just frustrate yourself with that approach to it.

Recursive CTEs are really only...

Lynn Pettis (4/25/2012)

---

Gus, walk away. You will never get a full answer to any of...

Then there's something else wrong.

If you're getting that error message, some piece of your query is trying to convert a string (NVarchar) to a floating point value, and it's incompatible....

I currently use Confio Ignite to do that. I'm doing some testing on Quest Performance Analyzer to see if it works better for what I need on that.

m.eissa85 (4/25/2012)

---

I don't think that case work in where clause, But I didn't check it. You can rewrite the condition as following:

My query is

DECLARE @var AS VARCHAR(4)

SET @var =...

Then the error is somewhere else in your code. Post the right part.

Yeah, I couldn't resist. Or, more honestly, I could have, but chose...

Either column "PortfolioBaseCode" is datatype Float, or variable "@Portfolios" is. Can't tell which one from your post, but it's one or both.

Something like this will work:

SELECT *

FROM ( VALUES ( '123-45-6789'), ( '123-54-6789'), ( '923-00-1234'), ( '123-00-1234'), ( '123-45-0000'),

(...

You might still have problems with that function.

If, for example, you have a double-space inside the string, instead of just at the end of it, then you won't end up...

You've misunderstood what a Case statement is for in T-SQL. It's a common confusion. What you wrote looks like Visual Basic or some language related to that.

In SQL,...

The inserted and deleted tables behave a little differently than regular tables. No indexes, for one thing. No stats. So querying them can be a performance issue....

The problem rows have DIDOC# values. Your subquery (the Cross Apply query) requires that they be the same as per the first item in the Where clause. You...