I'm afraid you're going to have to explain what you're looking for a little better. See the link in my signature for some tips on asking questions / posting...

Probably:

CPU

Reads

Writes

Duration

Number of total rows you are working with

Number of rows being replaced by the function. (Number of NULLS)

Nuber of rows in the final output.

Execution plan

SELECT *

FROM mytable

WHERE SUBSTRING(mydata,10,1) = 'F' AND SUBSTRING(mydata,11,1) IN ('1','2','3','4','5')

If you want multiple values in the list format you stated, you cannot. However, if you convert it to a local table variable and use that instead, you can...

Not entirely accurate:

[font="Courier New"]USE NorthWind

DECLARE @A TABLE(

NameLetter VARCHAR(20))

INSERT INTO @A(NameLetter)

SELECT 'M' UNION ALL

SELECT 'J'

DECLARE @B VARCHAR(20)

SET @B = 'R'

DECLARE @C  VARCHAR(20)

SET @C = 'First'

SELECT *

FROM Employees

WHERE LEFT(FirstName,1) IN (@B)...

While my subquery seems to fit all that criteria, I'm not sure that it's creating a triangular join in this case. The subquery method is blazingly fast, it was...

*considers a world without aliases*

...

*dies a little inside*

...

*goes to get a beer*

In re-reading this, it seems you only want to go 1(Rows from T1 not in T2) way, not both ways. That's even easier.

I would do this as

SELECT T1.*

FROM Table1...

This should be fairly easily accomplished with a couple of outer joins. Please post some table definitions / sample data according to the link in my signature and I'd...

Thanks Matt, and good catch. I guess that's the downside of having perfectly ordered test data =).

Not allowed to use loops or cursors? I like that =). Add this after #DailyBalance is generated.

[font="Courier New"]ALTER TABLE #DailyBalance

ALTER COLUMN RowNum INT NOT NULL

ALTER TABLE #DailyBalance

ALTER COLUMN...

This solution is a variation of Jeff Moden's Running Total Technique, which can be found here:

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

This is the setup for this solution, please post sample data in this fashion in...

Oh yeah, that's much better than letters =). Jeff might have been doing this for so long that he just intuitively grasps it all, but I still need my...

This still seems like a semi-poor way to do it, but I believe a very long case statement would probably beat out your 135 update statements.

EG:

UPDATE large_table

SET...

And if you have something like:

1 A B C

2 A D...