Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
UPDATE dbo.accountextensionbase SET new_ordercount = ( SELECT COUNT(SalesOrderId) FROM dbo.SalesOrder AS so, dbo.Product AS p WHERE (New_source_paid_amount <> 0) AND (DATEPART(year, so.New_source_event_date) = DATEPART(year, GETDATE())) AND (so.new_source_event_id = p.new_source_event_id) AND (p. new_include_in_rollup = '1')and(so.New_source_order_type not like 'S') and ((so.new_createdby LIKE 'W%') or (so.new_createdby LIKE 'P%')) GROUP BY AccountId )
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SHOWPLAN permission denied in database 'AdventureWorks'.||13||115|
|Why is the output of this function is like this?||4||44|
|SQL query with cast||38||59|
|LAG_ROWID - how do I get the right order using this query?||2||22|