It would be cool if there were a WITHOUT keyword.

...

FROM <table> WITHOUT (INDEX(<index(s) you dont want to use>))

Redgate SQL Prompt is useful for this kind of thing. It's not as intuitive as you would describe but it will help you identify unused variables, parameters and columns, which...

And thanks to your lack of netiquette, we have no DDL.

I think what I posted should answer the OP's question as well as yours Joe.

You can use TOP and ORDER BY NEWID() like this:

-- Sample data
DECLARE @yourdata TABLE 
(
Family INT,
Room INT,
subfamily INT
);
INSERT @yourdata VALUES (1,5,6),(2,5,7),(3,5,7),(4,2,3),(4,2,4);

-- Number of Rows 
DECLARE @rows INT...

. This particular article, well I regret reading and discussing it. Yet again, SSC disappoints.

I would ask for your money back.

As already mentioned - you don't want to pass other people's experience off as your own. I would never hire someone who did this nor would I respect someone who...

"UK to stay in Interrail scheme after U-turn"

ba dum chhh

Speedy Pletcher beat me to it... More details about the requirement are in order. Here's my solution:

DECLARE @startDate DATE = '20181230', @endDate DATE = '20191230';

WITH 
E1 AS...

• This reply was modified 5 years, 4 months ago by  Alan Burstein. Reason: Forgot ORDER BY

PatExclude or PatReplace can do the trick.

For example, this will remove any characters that are not alphanumeric while preserving spaces (note the space after the "Z"):

            
July 22, 2019 at 9:59 pm
            
#3665222

            
            
                                                
        

Old thread, I know but there is something that has not been discussed here that I think is super important. Correctly designed CLR scalar UDFs don't have the problems that...

• This reply was modified 5 years, 4 months ago by  Alan Burstein.

You forgot to change the WHERE to ON for the INNER JOIN

Good catch John, thanks.

Does anyone know why you shouldn't use CROSS APPLY for everything? Or does it sometimes come...

Emph mine...

ANSI-89 style may have been a standard back in the day, but has long been supplemented. In fact it returns incomplete sets. There used to be a page in...

• This reply was modified 5 years, 4 months ago by  Alan Burstein.
• This reply was modified 5 years, 4 months ago by  Alan Burstein. Reason: Changed WHERE to ON for INNER JOIN

I have this type of problem when I have too many SQL windows open or too much stuff running on my PC. The problem persists, often, even after closing the...

My $0.02 about the new site...

First, I miss the count of likes (for threads and individual comments). No nobody knows if you "liked" a thread or comment.

As someone with articles...

I would do something like this:

DECLARE @date DATETIME = getdate();

SELECT WeekStart = CAST(DATEADD(DAY,f.Dt+1, @date) AS date),
WeekEnd = CAST(DATEADD(DAY,f.Dt+8, @date) AS date)
FROM (VALUES(DATEPART(WEEKDAY,@date)-1)) AS w(Wd)
CROSS APPLY (VALUES(-IIF(w.Wd=0,7,w.Wd))) AS...