Yes, it would also prevent Oracle doing a seek on an index.

If lastUpdatedDate is a date or datetime, just compare it directly to a variable of the matching type, or...

It's a waste of space to store dashes: simply char(9) will do.  Assuming this is some type of temporary table, otherwise you need to encrypt the data which means you'd...

You can do this easily with string functions, but it’s still a stinking kludge caused by bad design. Most of the work in SQL is done in the...

;WITH SampleData AS (
    SELECT * FROM (VALUES (''),('3#5'),('8063#0018375'),('8063#018375'),
        ('063#018375'),('063invalid018375')) Data(AccountNumber)
)
SELECT AccountNumber, RIGHT('000000' + SUBSTRING(AccountNumber, 
 ...

• This reply was modified 6 years, 8 months ago by ScottPletcher.

IF DATEDIFF(DAY, 0, GETDATE()) % 7 <= 4 /*0=Mon;4=Fri;5=Sat*/
AND NOT EXISTS(SELECT 1 FROM dbo.your_holiday_table yht WHERE yht.date = CAST(GETDATE() AS date))
BEGIN 
    INSERT INTO...

On top of that throw in that, the DDL and the DML have different rules. In DML, the {false, unknown} values are treated the same and reject a search condition....

Cluster the Attrib table on ( ClinicID, ItemID ) and any of the methods will likely run fast enough, although I like the CROSS APPLY approach myself.

Nothing's wrong with it, per se.  I thought checking LEN was a bit more efficient, but either will do.  Edit: SQL may actually convert { = '' } to checking...

1 Don't concatenate the strings, that's more overhead, just check the len of each:

LEN([address 1]) + LEN([address 2]) + LEN([address 3]) = 0 /*easier, to me*/

OR

(LEN([address 1]) = 0 AND...

We have to make many guesses here, since you didn't specify any details on these tables.

If you only need to lookup consolidation_ind if it is = 1, then create a...

As regards the original "1. Key column ...", it should at least be demoted to a secondary key (to make the clustering key unique).

This table almost certainly should be clustered...

Try this:

BEGIN TRY

BEGIN TRANSACTION [Tran1]

select top (1) @caid=ca.id from Cases ca WITH  (UPDLOCK)

where ca.applicationstatusentityID in (1,2,12,15)

Insert into CaseAssigned table the caseId selected above

Delete from the Cases table once a case...

I ignored the actual calc before, but Drew is quite right, of course, that needs corrected too:

SELECT TOP (100) PERCENT 
    DATEADD(SECOND, DATEDIFF(SECOND, base_date,...

I'd use RIGHT rather than PATINDEX, just because I think's it mildly clearer:

WHERE RIGHT(name, 2) LIKE '[0-9][0-9]'

You can also use a computed column for as_of_month, there's no need to physically store it again.

as_of_date date NOT NULL,

as_of_month AS CONVERT(varchar(6), as_of_date, 112),

That column is fully usable by all...