Try this. No loops or recursion.

SELECT

b.BranchID

,(CASE

WHEN b1.Grp1_Inherited = 1 THEN

...

Very useful. Thanks!

 

Another option (scripts to create tables, indexes, and sample data attached):

SELECT

a.AraziID

,a.MantagheID

,a.EndUserID

,a.MahaleTakhrib

,a.MasahatArazi

,a.AraziImage

...

Thanks for the corrections/comments everyone. If I get the time I will study them and update my notes on temp tables. Most of that was pulled together from multiple sources...

When you create your temp table you can define primary keys and indexes as well. This may improve performance.

Here's a copy of some notes I put together for my...

Another option using a table valued function. In this example I use an outer join but if you only want the code '82' values an inner join would work as...

This will do it:

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

DROP TABLE #TempTable

CREATE TABLE #TempTable

(

[ReportHistoryID] [int] IDENTITY(1,1) NOT NULL

,[Report_id] [int]...

GilaMonster (9/26/2012)

---

Yes, those two will be identical.

While the string manipulation's in the select, that derived column is used in the where, so it's absolutely the same as having the string...

+2

So I will chime in that I too...

Here's another option that moves the string manipulation and identification of NULLs to the SELECT statement instead of using it in a JOIN or WHERE clause where the 'SARG-ability' of...

If your question was more than just theoretical, another way you could get the NOT 'a' values including NULLs would be to create a temporary column. I have no idea...

Here's a solution that seems to be what you are trying to do...joining one table to another table where the source table has a delimited list of key values in...

The point above about not using VARCHAR for date values is a good one. However, I recently had a situation where the application was not doing a good job of...

Leaving off the day value from my first posting above and casting the result as a TIME datatype works for me. In every scenario I tried even if the end...

ScottPletcher (9/6/2012)

---

The INT can't overflow returning billionths of a second -- the max possible value is 99,999,999, which...