... if Given Value is date (ISDATE does not recognize CAST AS DATE)
IF @OrigLen=10
AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2
AND ISNUMERIC(SUBSTRING(@OrigVal, ...
... SET SQLStatement = 'SELECT * INTO SearchTMP FROM ' + Tablename + ' WHERE ' + substring(WHEREClause,1,len(WHEREClause)-5)
DELETE FROM @SQLTbl
WHERE WHEREClause IS NULL
...
... Given Value is date (ISDATE does not recognize CAST AS DATE)
IF @OrigLen=10
AND (LEN(@OrigVal) - LEN(REPLACE(@OrigVal, '-', '')))=2
AND ISNUMERIC(SUBSTRING(@OrigVal, ...
What?
I have a mySQL database table of room assets that has a field containing the ID numbers of images relevant to this room.
The Problem?
When I select specifying the statement "WHERE IN (c.RoomImages)", ...
... SUBSTRING(img_timestamp, 1, 8)>=20110922
ORDER BY
img_timestamp DESC
Note that I've commented out the lines which specify images modified since the 22nd of September 2011. I've left it in there ...
... - TIME_TO_SEC(s.DateTimeCreated)))/26640) AS PersonDays,
CONCAT(r.CapexCode, ' - ', r.ResourceName) AS Resource,
s.StaffActivity AS Activity,
s.AdditionalNotes AS Notes,
CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.