1. Use a SQL start up proc to create the table.  You could consider a regular table name in tempdb to make sure the table doesn't get dropped even if...

Perhaps a synonym would work for you here.

Why do the created tables have to have the same name?  Presumably it's because some common code needs to run against the tables?  If...

I've never seen a time system that didn't use separate system entries to record check in / check out.  If fact, I don't see how else they could work, for...

Btw, I too would process the rules tables with a cursor to create / generate the final code.  I think a cursor gives you much better control and more flexibility...

I suggest that the results of the dynamic SQL should be to create a view.  Your manager can then SELECT from the view.

Likely the view name would be the same...

I would like your opinion on this solution

First, you really need to go back and do logical modeling, aka normalization, before you create tables (you have a table but it...

• This reply was modified 5 years ago by ScottPletcher.
• This reply was modified 5 years ago by ScottPletcher.

SELECT 
    path AS original_path,
    LEFT(path, LEN(path) - CHARINDEX('/', REVERSE(path)) + 1) + 'this.bat'
FROM
(
    VALUES ('temp/a/g.txt')
  ...

It's better to put all conditions related to the LEFT table directly in the LEFT JOIN, i.e.:

SELECT
Names.productName
,NameProperty.Value
,NameProperty.Property
FROM Names

LEFT OUTER JOIN NameProperty
ON Names.productName = NameProperty.productName 
AND NameProperty.Property =...

Oracle dbms treats an empty string as NULL.  Don't ask me why, it's totally bogus to me, but it does.

Yes, definitely.  That's another reason I wrote the trigger that way, to allow sample value(s) to be pulled for use in the email, if needed.

For example:

DECLARE @min_number_of_entries_expected...

Or take the month difference and divide by 12.

Create a job to check on the data.  Even though it will check the last hour, you could schedule it to run as often as you wanted to check:

            
January 7, 2021 at 5:14 pm
            
#3828658

            
            
                                                
        

My first thought would be to simply take the difference of the year.  Do you want to adjust based on the month as well as the year?

SELECT...

• This reply was modified 5 years ago by ScottPletcher.

I don't see any view defs.  Instead of attaching them, you can post them using the "insert/edit code sample" button when you go to post a Reply.

If I'm overlooked them...

If you have some indexes that have woefully low (less than 80% average percent of page fullness [page density]), then rebuild (NOT reorganize) them at 82%...