Looks like you've already asked elsewhere, but your query brings to mind some questions.

UPDATE T

SET SALE = SUM(Sale),

Exp = SUM(EXP)

FROM Sale T

INNER JOIN Exp S ON (T.Area = S.Area)

WHERE ordertype...

I'm curious, since you have a customer number already to group on, why don't you just ignore type 'B' rows?

WHERE t_col1 <> 'B'

Or if your number is actually character data. 😀

declare @number varchar(20) = '1000000017777'

select @number as before

select @number = RIGHT(@NUMBER,len(@number) - PATINDEX('%0[^0]%',@number))

select @number as After

I would while away the hours conversing with the flowers, discoursing with the rain....

Toto, I don't think we're in Kansas anymore.

Just out of curiousity, shouldn't the date also be greater than the latest date for that user? Or is that not a concern because you're always insterting the current...

ON needs to be on a different line in order to test if the code handle carriage returns/new lines correctly.

with JustInD as (select name

from sys.server_principals db

...

How about this?

WHERE not exists (SELECT 1 from sys.server_principals where

I'd probably lose the...

If you are talking about simply filtering a resultset, then the code below will work without resorting to dynamic SQL.

Declare @Region varchar(10), @SubRegion varchar(10)

Set @region = 'USA'

Set @SubRegion =...

Thank you for doing an excellent job of setting up the problem for us. Good job. Looking at the problem all you really wanted to...

Something like this?

BEGIN TRY

POST

END TRY

BEGIN CATCH

POST IN ERROR

END CATCH

😉

I'm wondering why you store staffed time in seconds. How much do you pay per second? 😛

I miss being coddled :crying:

Hmmmm... maybe it's a trap site that employers sponsor to spoon-feed wrong answers to job applicants who don't know any better! 😀