28,350 reputation
771121
bio website
location United Kingdom
age
visits member for 3 years, 1 month
seen 3 hours ago

Email: stackoverflowmartinsmith@gmail.com


Sep
23
comment Inserting variables into another variable
Is that your actual code? I don't see any initialisation of @counter
Sep
23
revised Inserting variables into another variable
added 147 characters in body
Sep
20
awarded  Enlightened
Sep
20
revised How to resolve stored procedure output parameter error?
added 96 characters in body
Sep
19
comment Tsql Query speed slow due to Or within where clause, causing index scan instead of seek
What version of SQL Server?
Sep
19
comment Why does a simple select query produce a deadlock?
@Shanky - I prefer the code here for the reasons here
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
@AaronBertrand There seems to be a reasonably significant number of cases where it does not even meet that intention too.
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
Though from NCHAR(0) - NCHAR(65535) I see 112 discrepancies. Including characters such as ₁,₂,₃,4,5,6,7,8,9 which look numeric but don't cast successfully to anything for me. Fiddle
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
@Jeroen - It's on Wikipedia FWIW
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
Ah that's an interesting theory. It is money that it casts to as well.
Sep
17
comment What is the logic behind ISNUMERIC for certain special characters?
The only ones that seem incorrect to me are that it falsely reports 0 for five of the values that actually cast fine to money. The others seem accurate. SQL FIDDLE
Sep
16
comment Converting a Unicode value to a non-Unicode value (SQL Server)
SQL Server uses what this paper calls homoglyphic transformation and often converts characters that can't be represented to near equivalents. Such as losing the accent on a character or changing smart quotes to plain quotes. I agree that doesn't look very close though! I'm not sure if or where these transformations are documented.
Sep
15
awarded  Enlightened
Sep
13
comment Inserting to table: Insert rows with Left Outer Join or Insert rows then Update?
If you tag "performance" and "optimisation" you should generally tag the RDBMS you are using too.
Sep
10
comment Explain plan shows a table not in the query
And my guess is that it is CAUFV that is the view referring to AUFK as I don't see that in the explain. Maybe the V is a clue.
Sep
9
awarded  Good Answer
Sep
9
awarded  Enlightened
Sep
9
awarded  Nice Answer
Sep
9
reviewed Approve suggested edit on Sql Server - Select while insert on another transaction gives unexpected results
Sep
9
awarded  Nice Answer