Viewing 15 posts - 1 through 15 (of 155 total)
Yes the ASP side is very tricky - not many ASP Classic coders left to ask!
August 9, 2016 at 11:32 am
Well done that fixed that results page but I don't understand why as I just checked all the tables in the SELECT statement and the ONLY one with a column...
August 9, 2016 at 11:05 am
I know they shouldn't that's why I am so confused to what is going on. I will try and insert some screen captures so you can see.
If you go here...
August 9, 2016 at 10:40 am
Yes as I said in the reply I only did the CONVERT on the SELECT column NOT the order by statement which is why I am so confused.
I had added...
August 9, 2016 at 9:50 am
I've been into IIS and changed the
.NETGlobalization - Culture and UI Culture to English (en). English (United Kingdom) en-gb
at both the server level and on the website levels as well.
August 9, 2016 at 9:03 am
So your saying that all my SQL settings ARE correct then?
I don't suppose you know any GOOD (as in expert) forums that would deal with sort of issue.
I am guessing...
August 5, 2016 at 9:08 am
Come on this must be a standard issue many people have faced before - I am sure I used to come here years ago to find the answer.
Someone must have...
August 5, 2016 at 12:38 am
I just want to quickly add that putting
'Set the server locale
Session.LCID = 2057
At the top of the ASP pages does force the site to show the dates correctly as UK...
August 3, 2016 at 5:55 am
okay cool, Ill have to change my template for stored procs around then to use that format
June 3, 2015 at 10:40 am
Ok, I totally get that as I do use TRY CATCH and all the ERROR_MESSAGE() ERROR_LINE() ERROR_NUMBER() ERROR_PROCEDURE() functions to get detailed errors in TRY CATCH statements and log...
June 3, 2015 at 9:20 am
Regarding the GOTO statement, are people saying it has no place in TSQL either?
I know VB and remember on my Amstrad 64 having to use GOTO statements constantly so...
June 3, 2015 at 5:34 am
April 21, 2015 at 11:01 am
Don't worry I was being a numpty. I could just DISTINCT on table but I would like to know if the
AND [sp].[modification_counter]/[sp].[rows] > 0.10
is the right sum is your...
April 21, 2015 at 9:10 am
So I guess I need to change my SQL for the loop then as it is showing multiple indexes / statistics for each table. I have tables in that...
April 21, 2015 at 8:46 am
UPDATE STATISTICS [dbo].[tbl_TRAFFIC_VISITORS] _WA_Sys_0000000C_1DE57479 WITH FULLSCAN
April 21, 2015 at 8:02 am