I couldn't see the code until I quoted the post for reply, then my post was also hard to see.  I pasted it in regular text as I couldnt make...

• This reply was modified 1 year, 2 months ago by  Ed B.
• This reply was modified 1 year, 2 months ago by  Ed B.

duplicate

• This reply was modified 1 year, 2 months ago by  Ed B.

Here's an example with an artificial column. I did try COUNT(ID), but it said invalid column.

DROP TABLE IF EXISTS dbo.Activities;

CREATE TABLE dbo.Activities
(   ID INT,
 ...

You could use sp_MSforeachtable to avoid writing a loop, but it will only work in the database it's run from, so you couldn't query two databases at the same time...

Are the dimension columns you need unique without Company Code and is Company Code irrelevant? If so, can you join to a distinct query of the columns you need?

It appears...

Since you're not using SQL Server (based on the INT4 datatypes you used), it may be that the RDBMS you're using doesn't allow CTEs (Common Table Expressions), which is...

Does this give you what you need? It sounds like General Purpose tier serverless autoscaling databases will turn off automatically after a certain period of inactivity and they can be...

I know you solved it already, but I think the issue only happens when the milliseconds of GETDATE() end in a 3, which is why it was unpredictable.

SQL considers DATETIME...

Do you want the devices with the max syncdate, or the max syncdate per device ? Your test data returns the same either way.

The max syncdate is 2023-08-23. If you...

Identify the ins_nums, then join/semi join back to the table.

SELECT i.ins_num
     , i.pat_id
     , i.bp_id
    ...

Does this work?

DROP TABLE IF EXISTS #tb_pat_ins 

CREATE TABLE #tb_pat_ins
(   pat_ID INT, 
    ins_num VARCHAR(20) 
)

INSERT #tb_pat_ins (pat_ID,ins_num)
VALUES (111807 , '100449401H'),
(461261, '100449401H'),
(106820,...

Do you mean Query Analyzer that came...

I still don't understand why an AWS server that costs more per month to rent than the entire cost of buying my laptop new should take 10 times longer...

The explicit cast to varchar(15) is potentially truncating longer values, with either normal or special characters after the 15th position.

If the Tenant_ID is always supposed to be a number, you...

Edit. Solution above

• This reply was modified 1 year, 10 months ago by  Ed B.