Thank you sir! 😀

One thing I did fail to point out that's probably worth mentioning...

It's not always desirable (or even acceptable) to do...

Alright... So instead of getting up a cutting the grass, I decided to do a little testing this morning...

For a test bench I used 1M rows generated by the script...

ben.brugman (10/2/2015)

---

Sorry, I think I was asking for something which is not obtainable.

And I wasn't clear enough in my question.

Because I want the code to cut and paste between the...

If that's what they're using as educational material... I'd...

For converting row data into a concatenated string, FOR XML is as good as it gets in SQL Server.

The real performance problem, in your current code, is that you're executing...

Eirikur Eiriksson (10/3/2015)

---

Jason A. Long (10/3/2015)

---

Eirikur - I'm with Chris on this one... VERY slick solution.

I have to confess that I'm baffled by optimizer's ability to do an index seek...

Looks like a huge waste of space not to mention a gross violation of the 1st normal form. The queries that would be need to be used to parse those...

Eirikur - I'm with Chris on this one... VERY slick solution.

I have to confess that I'm baffled by optimizer's ability to do an index seek with leading wildcards. That really...

ChrisM@Work (10/2/2015)

---

Jason A. Long (10/1/2015)

---

...

Also note that you will need to look at the Actual execution plan to see the plan change. The Estimated plan will continue to show the...

Code like the following can be an absolute killer because the optimizer will always assume the worst case scenario and force a index scan when it would otherwise be able...

If you're willing to spend a few $$$, Redgate's SQL Prompt[/url] adds this functionality (and more).

wendy elizabeth (9/25/2015)

---

In a t-sql 2012 sql, I see the following in a where statement:

where ISNULL(I.Active, 0) = 1 AND ISNULL(AN.AccountNumber,0) IN (@Account).

Would you tell me what the ISNUll function...

Another option...

DECLARE @table TABLE(ID int, value decimal (3,1))

INSERT @table

SELECT 1111,14.0 UNION ALL

SELECT 1111,14.0 UNION ALL

SELECT 2222,13.0 UNION ALL

SELECT 2222,13.0 UNION ALL

SELECT 3333,15.0 UNION ALL

SELECT 3333,11.0 UNION ALL

SELECT 4444,12.0 UNION ALL

SELECT...

Just need to change

where (YesNo=@YesNo or @YesNo=null)

to this...

where (YesNo=@YesNo or @YesNo IS NULL)

OPTION(RECOMPILE);

drew.allen (9/22/2015)

---

I also use SQL Prompt which can be configured to automatically add table aliases based on the table name. That also leads to consistency in table aliases while...