Forum Replies Created
Viewing 15 posts - 1,501 through 1,515 (of 3,544 total)
-
RE: Do what I said?
Not if you sink the boat in the process. No Chance. I'd have thrown my boss out of the...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: audit trigger problem
...it's bad form on this forum to post the same question more than once... ticks people off. Go... Far away is close at hand in the images of elsewhere.
Anon. -
RE: How to traverse a table despite of unique identifer
Good lord, NO!!!!
Vamshi, I know you're kinda new at this,...Far away is close at hand in the images of elsewhere.
Anon. -
RE: CHARINDEX - CAPTURING TEXT TO LEFT
p.s. the above in SQL2K will return a maximum of 8000 chars (the limit for varchar)
Far away is close at hand in the images of elsewhere.
Anon. -
RE: CHARINDEX - CAPTURING TEXT TO LEFT
The use of
SUBSTRING([textcolumn],1,PATINDEX('%*%',[textcolumn]))
will not produce an error if * is not in the data but would produce erronous data depending on your view of 'erroneous'
If an empty string is...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Problem with Date
if u say my code is not very secure i agree since i am very new to this.... Far away is close at hand in the images of elsewhere.
Anon. -
RE: Eliminating Leading Char Zeros
Notwithstanding the answer to the 'all zero' question
if emptry string is required then
LTRIM(SUBSTRING([column], PATINDEX('%[^0]%', [column]+' '), LEN([column])))
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Round to Even (aka Banker''''s Rounding) - The final function
Do your homework first, then join the discussion. You answer my questions first
But I know that you cannot
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Round to Even (aka Banker''''s Rounding) - The final function
David, have you done your homework with one thirds? What has that to do with the questions I asked?
Are...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Round to Even (aka Banker''''s Rounding) - The final function
Absolutely precise numbers must have p = infinity. Sergiy, please define your interpretation of "precise number"
Please post a reference...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: return 0 when count=null
seems we were posting the same at the same time Yeah, looks like it
Far away is close at hand in the images of elsewhere.
Anon. -
RE: return 0 when count=null
my variables are actually strings NOT dates, that is why I was using substring.
Does not matter, the input dates will be implicitly converted, I explicitly converted the date on the...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: return 0 when count=null
COUNT clause can't find any claims for one of the categories, it simply does not return any results... Far away is close at hand in the images of elsewhere.
Anon. -
RE: Date sorting based on Varchar datatype
If you cannot change the sorted option on the combo box then nothing you do at the sql end will make any difference.
As you stated you cannot change the order...
Far away is close at hand in the images of elsewhere.
Anon. -
RE: Round to Even (aka Banker''''s Rounding) - The final function
Wanna start a third Jeff
Or should that be 1/3 or .33
Damn, did it again, oops
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 15 posts - 1,501 through 1,515 (of 3,544 total)