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 3 hours, 18 minutes 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 2 weeks, 3 days ago by naumon765.
• This reply was modified 2 weeks, 3 days 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 2 weeks, 3 days ago by naumon765.
• This reply was modified 2 weeks, 3 days 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 2 weeks, 4 days 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

this is what i have seen in each and every company i have worked in       ### the same people issues  ### all people including me ..prone to the...

• This reply was modified 2 weeks, 5 days ago by naumon765.