To keep the record straight, the ANSI/ISO SQL standards allow only the ISO – 8601 "YYYY-MM-DD" format for dates. The. The reasons we pick this one were:

1) it's not ambiguous,...

What you posted is by definition not a table at all! The table must have a key. You cannot embed spaces in the data element name in any of the...

This is a common misconception about the three valued logic and SQL. We have three logical values: true, false and unknown. The search condition used in WHERE or ON clauses...

>> I have a customer table and than a customer group group table which is basically grouping customers <<

Why did you fail to post any DDL? Why is the sample...

>> ]This is how the data is stored in the system. There is no start or end date in the system. Any actual day off is recorded in a row...

Incentive trying to mimic procedural (recursive) code in SQL, I would've used a nested set model. You can Google it and see that it's very set oriented so it works...

http://www2.cs.arizona.edu/~rts/publications.html

This also has his other books on temporal SQL, etc.

You don't know how to do a data model for temporal data. Please get a copy of Rick Snodgrass's book from the University of Arizona on temporal queries in SQL....

I strongly agree with your decision to clean the data before it goes to the database. However, we never designed SQL to be a string handling language. If you can...

Have you ever considered normalizing your table? Or following ISO 11179 naming rules? What you did post is a mess. First of all, a table has to have a key,...

>> I want to find runs of at least three 1s, and return the result below. The 0s would be any test_values that are not 1. <<

This is been a...

>> failed to convert the below scalar function to table valued function, i tried many times and always got error <<

Actually, your problem is that you're not writing SQL yet!...

>> I have a table, around 320 fields... <<

You might want to read the SQL standards, so you'd know what the term "field" means in this language. It is a...

DATE and TIME are available data types that can be combined into the newer DATETIME2(n) data type. Just use the CAST() function and simple math. The use of an integer...

>> I need to generate a sequence AlphaNumeric characters based on a certain condition. <<

You talk about a sequence, but that's how filesystems work. Perhaps you meant to think about...