Thanks for the heads up Rodders

😎

Firstly, do not use concatenated values in a column, just going to be a pain!

😎

Here is a simple ERD to explain the concept

...

Brandie Tarvin (7/15/2015)

---

I need to find a way to identify SPIDS where queries are connected to certain databases using the 4 dot notation instead of actually being connected to the...

WayneS (7/15/2015)

---

I didn't notice it before, but that's not quite the code that I posted, which is (after modifying to varchar(30) as Steve suggested):

CREATE FUNCTION dbo._tTVFN_tEEst2 (@countryNr INT, @telNr NCHAR(30))

RETURNS...

WayneS (7/15/2015)

---

XML shredding...

Jeff Moden (7/15/2015)

---

Or one version of ANSI Utopia to another. 😀 ANSI and...

...and an utter waste...

This one here is by far the fastest as Wayne's test clearly shows

😎

IF OBJECT_ID(N'dbo._iTVFN_tEEst') IS NOT NULL DROP FUNCTION dbo._iTVFN_tEEst;

GO

CREATE FUNCTION [dbo]._iTVFN_tEEst (@countryNr...

WayneS (7/15/2015)

---

Eirikur,

I changed your (very nice) test harness to put the results into a temp table vs. using @CHAR_BUCKET. My results are:

T_TEXT ...

Just piling on a little, here is a test harness with three different versions

😎

Echoing Wain's reply, don't recommend using the variable type concatenation as the order is not guarantied (but...

Raymond van Laake (7/15/2015)

---

Hi,

I am looking for the fastest way to strip non-numeric characters from a string.

I have a user database that has a column (USER_TELNO) in which the...

Changing the cardinality of the Match Set means having to case the self-join

😎

declare @tt table

( TagId int, TagType int, ReportId int)

INSERT...

Now come on you plinkers, here is a moving target practice

😎

Jeff Moden (7/14/2015)

---

Eirikur Eiriksson (7/14/2015)

---

Brandie Tarvin (7/14/2015)

---

So I'm testing a quick bit of code on a dev version of our bigger reporting database and it found something on the first...

farax_x (7/14/2015)

---

I want to get reports which have both (tagid=1000 and tagtype = 344 ) AND (tagid=71 and tagtype=300) and dont have any other tagid. so this query wont...