Look back at the old Sybase SQL Server days. We had money and small money, as well as the date formatting options of convert (). The real reason it was....

Read the ANSI/ISO standards for this language, you'll see that the only display format permitted for dates is based on ISO 8601 (YYYY-MM-DD). We had to pick one display format...

>>I have a table as below, with example data in it <<

Why did you post any DDL? Do you know what that is? Have you ever read a single book...

In the old days, particularly with PL/1, we would do the multiple IF's. Because it was easy to slip a new punchcard in the deck when we found we had...

Wouldn't it be easier to add an ordinal number column to your calendar table? 36525 rows would give you an entire century of dates. Now the number of days between...

In the future, would you please follow forum netiquette? We would actually like to see DDL and not have to create it for ourselves. It would also help if you...

>> I have the below data in a SQL Server 2017 table: <<

First of all, failure to post DDL is just plain rude as well as a mess. For those...

I began my career decades ago, writing Fortran and scientific applications. We had to spend two weeks in our Fortran class learning how floating-point numbers at work. Floating-point numbers are...

You have given a vague, general generic description of your code. I will give you a vague general generic solution. The if-then-else construct is a flow control and we don't...

>> We have two tables, and are trying to populate a third table by selecting the first available processing number for each ID. The two tables are joined like this:...

I did an article called Constraint Yourself! back in October 2008 on how to use DDL constraints to assure data integrity. One of the topics in that piece was a...

>> i have 3 table that need to find out which id missing two tables

TABLES: Main,table1 and table2 <<

Why did you fail to post any DDL? If you had had...

>> I want to know what are the customers having missing month data based on the following data pattern. My data is present in table in below format. Please help...

CASE is  an expression, not a statement. Basics, please.

Unfortunately, a weekend is not always a Saturday and Sunday. You can have three and four day weekends, depending on how holidays fall. I've always found it better to calculate...