RonKyle (11/19/2015)

---

Is there no need or use for a table with the two fields as the primary key? On the face of it, it's more than an odd situation....

Phil you sir, are a gentleman and a scholar!!! Thank you!

I had dismissed the idea of a unique index simply because those two columns alone aren't unique... For whatever reason,...

The reason you're seeing the implicit conversion (and the warning) is because you're treating it like a number in your query.

WHERE tb.SomeColumnName = 0123456789

or

JOIN dbo.TableB tb

...

Something like this???

IF OBJECT_ID('tempdb..#temp') IS NOT NULL

DROP TABLE #temp;

CREATE TABLE #temp (

ColA INT,

ColB INT,

Colc INT,

Formula VARCHAR(100)

);

INSERT #temp (ColA,ColB,Colc,Formula) VALUES

(1,2,3,'(ColA + ColC) * ColB'),

(11,22,33,'ColA + ColB + ColC')

;

SELECT

t.ColA,

t.ColB,

t.Colc,

t.Formula,

REPLACE(REPLACE(REPLACE(t.Formula, 'ColA', CAST(t.Cola...

Based on your vague description option B would be the preferred way to go.

I think that's an over generalized statement... "Catch All"...

Luis Cazares (10/30/2015)

---

Ian Scarlett (10/30/2015)

---

Really? I understand the grief nulls can cause, but without them how...

The only way to prove it is to test it. Put two copies of you table in a test environment one with the current collation and the other on the...

Alan beat me to the punch... But this is a different approach, w/o using a TVF...

DECLARE @MyString varchar(256) = '$I10~TESTING1$XYZ$I10~TESTING2$~';

WITH n (n) AS (

SELECT 1 FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) n (n)

),...

xsevensinzx (10/12/2015)

---

Let me start of by saying that I am one of those accidental DBA-types who kind of jumped head first into the data. I'm still very much learning the...

There are a few things...

#1) There's no need to use the NOLOCK hint here. It's a temp table which means you have exclusive access to it.

#2) Why are are you...

There are a couple ways of doing this. The simplest method is to use a recursive CTE.

Something like the following...

-- Create some test date...

IF OBJECT_ID('tempdb..#temp') IS NOT NULL

DROP TABLE...

On 2nd thought... I'm not stuck with a scalar udf... Just use the...

Finally got to do some testing.

First and foremost... Getting the UDFs out of the function did allow the C&P column to index and I don't see the function showing up...

mister.magoo (10/9/2015)

---

Here's an alternative that will work, but not got around to performance testing yet, sorry.

CREATE FUNCTION dbo.GetInvoiceIDFromBillID(@Input VARCHAR(20))

RETURNS VARCHAR(20)

WITH SCHEMABINDING

AS

BEGIN

-- Function to extract all characters from the first...