Maybe something like this?:

select textid, textline,

SUBSTRING(textline, percent_byte - length_of_percent + 1, length_of_percent) as percent_amount

from #T

cross apply (

select...

Jeff Moden (12/28/2016)

---

ScottPletcher (12/28/2016)

---

Then you encode the actual BankAccount value into a related int, as I stated above. That value initially could be gotten from an identity column in...

Jeff Moden (12/27/2016)

---

ScottPletcher (12/27/2016)

---

How do you query that table, and how does it join to other tables? If it's by BankAccount, then definitely cluster by BankAccount value. If...

How do you query that table, and how does it join to other tables? If it's by BankAccount, then definitely cluster by BankAccount value. If you need to...

100% agree. Definitely define as index as "UNIQUE" whenever possible.

Jeff Moden (12/26/2016)

---

Sergiy (12/15/2016)

---

ScottPletcher (12/15/2016)

---

I guess I don't see why that's so much worse than a non-bit comparison of "status =...

Here's the in-line code, hopefully it's trivial to convert it to an itvf once its logic has been verified:

DECLARE @baseDate DATETIME = '1/1/2006 07:00:00';

SELECT

@baseDate AS...

If the flag is significant enough, make it the first column in the clustered index. For example, in a 90%-10% situation where you mostly process the 10%.

Be aware that...

m.sams (12/16/2016)It seems to me that one could remove the primary key index and create a new unique non-clustered index and then add the necessary include columns and have a...

No, not unless you have an explicit BEGIN TRANSACTION outside of that code. By default, each statement is automatically committed once it completes.

Sioban Krzywicki (12/15/2016)

---

ScottPletcher (12/15/2016)

---

I guess I don't see why that's so much worse than a non-bit comparison of "status = 8"...

I guess I don't see why that's so much worse than a non-bit comparison of "status = 8" or "code1 =...

I'll offer a "template" approach just as a possible alternative. Often I find it easier because I get a better visualization of the desired result up front than from...

CELKO (12/13/2016)

---

Yes,...

You could also have another table that documented the bit value meanings. Here's a quick-and-dirty example, would obviously need fleshed out quite a bit more:

CREATE TABLE dbo.bit_values_master (

...