What's the data type of the following columns?

If they are character fields, how are the date strings formatted?

BW1.dbo.qryIntermediate_CIS_BrentEvents.EV_DATE

BW1.dbo.qryIntermediate_CIS_BrentEvents.REF_DATE

Also the following isn't a reliable way of calculating a person's age -...

I think that you could argue with your "senior programmer" that "a <> b" is more readable and maintanable and is thus the preferable method. A "senior programmer" should understand...

How about this.

By setting @firstWeekday, the code can be made to work for any day being the first day of the week, or you can set it to @@DATEFIRST for...

How are you defining the start and end of a week and how are you defining week numbers?

For instance, if your week runs from Sunday to Saturday, if the 1st...

Doubled single quotes rather than double quotes.

[font="Courier New"]EXECUTE('Select ''A'' as [Test],* From myTable')[/font]

You could set the MaximumValue of the top ranked entry in the TblMasterData table to NULL and use the following amended query.

UPDATE C SET C.rank = M.ReputationValue

FROM TblComputedData C...

There's a potential problem...

How about this

/* If you are starting from a datetime */

DECLARE @date datetime

SELECT @date = '2009-01-01'

SELECT DATEADD(year, DATEDIFF(year, -1, @date), -1)

/* or */

SELECT DATEADD(year, DATEPART(year, @date) - 1899, -1)

/* or...

The following works regardless of the value of @@DATEFIRST

DECLARE @today datetime

DECLARE @weekday int

DECLARE @startInterval datetime

DECLARE @endInterval datetime

SELECT

@today = DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0),

@weekday = DATEDIFF(day, 0, @today) % 7,

@startInterval...

Does this work?

It's untested.

SELECT

T.bol_no,

T.rev_no,

T.trailer_id,

C.comm_code,

DC.prod_storage_id,

C.comm_um,

DCO.quantity,

C.end_scale_wt,

C.quantity,

extended_weight = (

SELECT multiplier * DCO.quantity

FROM BDS_COMMODITY_UM_CONVERT BCUM

WHERE (BCUM.comm_code =...

One quick question.... What's the logic behind the bounding box?

Where Longitude between @Longitude-.1 and @Longitude+.1

And Latitude between @Latitude-.1 and @Latitude+.1

Is that...

You were previously given sufficient advice that should have enabled you to amend your own query, but I've done it for you here, plus tidied up a few details. I'm...

There are several other ways of splitting a delimited string, some of which are more efficient than using recursive CTEs.

You could use a Tally table, convert to an XML string...

Quite right - apologies for my sloppy terminology.

Given that January 1st is the first ordinal day of a year, the example TSQL scripts above are 1 day out.

If the date and time fields are stored as integers...