Viewing 6 posts - 136 through 141 (of 141 total)
Loreena McKinnet - Live From Paris & Toronto
Les Miserables - Original Cast 10th Anniversary
February 9, 2007 at 5:51 am
I believe with standard edition sql 2005 you will be limited to 3gb of memory.
summary of my understanding:
32 bit system can use 4gb by default. (2gb to usr applications 2gb...
February 6, 2007 at 7:57 am
other than setting ansi warnings off
I believe the only way is to modify your application code
select count(distinct col1) from testing_bug where col1 is not null
or in 2005 using TRY CATCH
February 2, 2007 at 6:02 am
you could also do something like this...
update table
set field1 = CASE
December 29, 2006 at 8:49 am
A couple ways to do this.
With CTE...
WITH ReturnDetailsFor (db1, dc1, OriginalDate)
AS
(
SELECT DISTINCT
[db1],
[dc1],
[date1]
FROM [T1]
WHERE ([date1] IN ('2006-09-01','2006-10-01','2006-11-01','2006-12-01'))
AND ([dc1] IN ('A1', 'b1','C1','D1','E1'))
)
SELECT DISTINCT
t1.*
FROM [T1] t1
JOIN ReturnDetailsFor RDF ON...
December 29, 2006 at 8:24 am
Try something like this.
=Fields!addresslineone.Value &
IIF(
NOT ISNOTHING(Fields!addresslinetwo.Value), chr(13) & CHR(10) & Fields!addresslinetwo.Value, "") &
IIF(
NOT ISNOTHING(Fields!addresslinethree.Value), chr(13) & CHR(10) & Fields!addresslinethree.Value,
December 29, 2006 at 7:03 am
Viewing 6 posts - 136 through 141 (of 141 total)