My guess would be that a document number should be an identifier. Identifiers are always measured on a nominal scale. Therefore, you document number should have been a string of...

>> Obviously I agree with that principle, as a general rule. Would you say I am way off beam when using temp tables for actually doing the tidy up of...

>> Would that work with a row goal? Are you suggesting to use a CTE pattern instead of itvf? The purpose is to make it simple to use a tally...

Any time I've needed to populate a table of sequential numbers, I just done it by brute force. No recursion or fancy stuff. Remember the definition of place valued numbers?...

I've always defined "big data" as having two important characteristics. Volume and velocity. Volume is sort of obvious; the sheer volume of data is more than we've had in the...

>> Trying to CREATETrigger on View to insert the records [sic] in other table like below. <<

Your whole approach this problem is wrong. By definition, not by option, a table...

>> need to run a stored procedure that will UPDATE all records [sic] DATE field [sic] (meeting_date) to the following week.<<

In SQL, a field refers to a meaningful subset of...

CREATE TABLE Foobar

(rin CHAR(10) NOT NULL

CHECK(rin LIKE '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'),

provider_name VARCHAR(255) NOT NULL,

license_nbr NVARCHAR(50) NOT NULL,

pickup_timestamp DATETIME2(0) NOT NULL,

dropoff_timestamp DATETIME2(0) NOT NULL,

modifier_code NVARCHAR(519) NOT NULL,

calulated_fare_amt DECIMAL(10,2) NOT NULL,

PRIMARY KEY (rin, ??));

INSERT INTO...

A simple table read to a computed column, versus a cross apply with multiple tables should not be cheaper or equal to each other. I'm not sure if they would...

Discount rates don't usually change that much. They are usually mandated by law or company policy. The most dynamic data element in this table is going to be the prices!...

I have a data as below.

Why did you fail to post any DDL? But more than that, why do you think that SQL and the relational model use any kind...

The description my body. A something>> I've a little problem with a SQL View ... <<

No, your actual problem is with the DDL. You don't know how relational databases work...

>> I have a table called TableA, the record [sic] in TableA already in order sequence as below: <<

NO! Rows are nothing like a records. By definition, a table has...

>> relatively new to SQL development so hoping this isnt a silly question but here goes... <<

No, it's not silly, but it is based on a lack of experience and...

I did a problem like this a few decades ago for emergency services. We had to include driving time and consider the time of day. There is also the problem...