>> GOOD SQL Developers use TOP in their code as well as anything else that their particular version of SQL allows them to use - the only things to avoid...

One of the rules we had from the early days of structured programming was that a procedure should do one and only one thing, have one and only one entry...

Number the days from whenever your calendar starts and repeat a number for a weekend or company holiday.

CREATE TABLE Calendar

(cal_date DATE NOT NULL PRIMARY KEY,

julianize_day_nbr INTEGER NOT...

One of the standard formats displaying a date in the ISO standards is YYYY-DDD, where DDD is a string between "001" and"365" or "366" (depending on leap years). However, I...

t actually in the set.

If you can find an old calculus, finance, statistics or algebra book, they had lookup tables in the back. Remember that the only computational tools students...

>> I have the table as in data below<<

Please look at my credentials. This will let you know I have some authority when I tell you you're doing everything completely...

I have a table where I have mix and match records [rows are not records] under "statement" column.

I am trying to filter based on CASE statement [sic: CASE is an...

In SQL the only format allowed for dates is based on ISO 8601. It is"yyyy-mm-dd" , however various products allow you to do proprietary local dialects if you don't give...

>> I'm a newbie to T-SQL. <<

Please read any book on basic RDBMS. As Dykstra used to say to his students, "you're doing everything completely wrong."

CREATE TABLE Tests

(person_id INTEGER NOT...

>>

I have a following table ..<<

No this is not a table at all. By definition, a table must have a key, yet all your columns can be NOT NULL, so...

>> I have a table [UPSBatchInvNo] with column [ batch_date] formatted as 112621.<<

First of all, we prefer that people post DDL and not a narrative. We have no idea what...

November 29, 2021 at 3:16 am

#3957742

REPLY | REPORT | QUOTE

I would like to ask your opinions and recommendations on how to properly write an update with a from clause. I'm putting this in the...

>>I have a table with the below data. <<

Where is the DDL? For over 30 years. Standard netiquette on SQL forums has been to post DDL when you want help....

Please read any book on basic data modeling or SQL. By definition, a table must have a key. A key is a particular subset of attributes in that table that...