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...

Quick question, can you post the DDL (create table scripts), some sample data in the form of an insert statement and the expected results?

😎

Quick suggestion, add a NOT IN clause to exclude the unwanted members

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @tt table

( TagId int, TagType int,...

Quick question, any indices on the table?

😎

Have a look at this thread from last year

😎

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 table it hit. Nothing...

Brandie Tarvin (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

Eirikur Eiriksson (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

I know that an OP posted a question with the following error:

Cannot create a row of size 8071 which is greater than...

...and SQL MCP => SSC 😀

😎

Lynn Pettis (7/14/2015)

---

Eirikur Eiriksson (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

I know that an OP posted a question with the following error:

Cannot create a row of size 8071 which is greater than the allowable...