hi

hope this helps

in my t-sql career sometimes solved this using temp table approach

just one way of many approaches depends on which way is suited best for your situation

tongue in cheek...

• This reply was modified 6 days, 18 hours ago by naumon765.

hi hope this helps

used an extremely short simple for loop code in powershell

( big fan ...  absolutely love terminal scripting .. does the same stuff ..very low resource intensive .....

• This reply was modified 1 months, 1 weeks ago by naumon765.

CREATE TABLE Customers (
CustomerID INT PRIMARY KEY,
CustomerName NVARCHAR(50)
);

INSERT INTO Customers (CustomerID, CustomerName)
VALUES
(1, 'ACME Corp'),
(2, 'AC Solutions'),
(3, 'AS Technologies'),
(4, 'Global AC Systems'),
(5, 'ASIA Services'),
(6, 'Universal Corp');



CREATE FUNCTION dbo.FilterCustomers...

lots of people # lots of different thought processes , situations, 3 different sources of income .. develop , as usual people are in all kinds of circumstances backgrounds economics...

another thing is #the rowcount of each filter # design depends on that # 10 or 100,000

-- Filtered Index

CREATE NONCLUSTERED INDEX IX_BillingReason_Filtered
ON dbo.YourTable (BillingReason)
WHERE BillingReason NOT IN (1,2,3);

WHERE 

            BillingReason NOT IN (1,2,3)
              OR 

          EXISTS (SELECT 1 FROM...

WHERE 

          BillingReason NOT IN (1,2,3)
          OR 

        COALESCE(NewInsID, OldInsID) IS NOT NULL

• This reply was modified 1 months, 4 weeks ago by naumon765.
• This reply was modified 1 months, 4 weeks ago by naumon765.

there are SEVERAL thought processes that go with the new age of

= ai    ROBOTS

all the usual stuff

depends on YOU

smiling wink

#intended purpose

casual , business , research etc etc etc

• This reply was modified 1 months, 4 weeks ago by naumon765.
• This reply was modified 1 months, 4 weeks ago by naumon765.

Jeff

classic SQL Server security gotcha

and you’re not alone in hitting it.

EXECUTE AS doesn’t automatically grant permissions

— it just changes the execution context to another principal.

If that principal doesn’t have the...

• This reply was modified 1 months, 4 weeks ago by naumon765.

have faced this ISSUE

one toooooooooooo many times

lots of ideas come to mind

some sort of workaround which is very easy to implement

most people  use

:PSYCHOLOGY:

in scams

easiest and the deadliest