Viewing 9 posts - 1 through 9 (of 9 total)
Dave Ballantyne (11/3/2009)
Dave Ballantyne (11/3/2009)
select
@TIME1 + ' & a m p; ' + @TIME2
again with the spaces.
Sorry that should be WITHOUT the spaces
Thanks Dave,
I...
November 3, 2009 at 1:39 pm
Thanks Lynn,
I have tried the concatenation with ampersand on a clean query and it works fine. I went back to my query and tried it on other parts and it's...
November 3, 2009 at 1:24 pm
Dave Ballantyne (11/3/2009)
jay.jose (11/3/2009)
**the wysiwyg is converting the & a m p; to & so i put spaces between them
I didnt notice that
so in you sql use
select
...
November 3, 2009 at 10:05 am
Dave Ballantyne (11/2/2009)
try using '&'
Actually I'm trying to concatenate the ampersand to join 2 values like
select
@TIME1 + ' & ' + @TIME2
but it is always...
November 3, 2009 at 8:57 am
Dave Ballantyne (11/2/2009)
Try this linkhttp://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
Thanks Dave,
Now my problemn is that i need to escape the ampersand '&' on the concatenated TIME string...i have tried set escape '\' and set define...
November 2, 2009 at 5:17 pm
Hi,
I saw where the problem is..there are two [DATE] fields on the table (i guess 1 is the actual date and the second is the date when they encoded the...
July 21, 2009 at 8:24 am
Yup, it is a MONEY datatype.. Thanks for the input i'll look into it ^_^
July 20, 2009 at 5:32 pm
here are other result i'm getting
ORDER BY
AMOUNT DESC,
[DATE] DESC
1991-12-17 00:00:00.000 15.00
1992-07-18 00:00:00.000 ...
July 20, 2009 at 5:19 pm
Michael Valentine Jones (7/20/2009)
The date looks OK to me. Why do you think the date is "messed up".
DATE AMOUNT
1992-01-31 00:00:00.000 20.00
1991-05-13 00:00:00.000 20.00
1991-03-14 00:00:00.000 20.00
1990-12-08 00:00:00.000 20.00
2007-12-27 00:00:00.000 20.00...
July 20, 2009 at 5:08 pm
Viewing 9 posts - 1 through 9 (of 9 total)