Try setting the RUN 64 BIT RUN TIME to FALSE on project properties in BIDS

this is one suggestion

with Windows as (

select part,

visit,

dateadd(mm,-6,aptdue) as bigwinopen,

...

see if this does what you want

;with myCte (memberid, claimno, primdate, net, seq, stoploss)

as (select memberid, claimno, primdate, net, seq, stoploss

from StopLoss

...

try this

left(replace(replace(replace(replace(convert(varchar(23),GETDATE(),126),'-',''),':',''),'T',''),'.',''),14)

In a very old post by D. Smith you can "modify your ReportServer/rsreportserver.config file on the server. Find the <Render> section and comment out any Extension entries you don't...

this should give you a start

for 2005

http://msdn.microsoft.com/en-us/library/aa337169(v=SQL.90).aspx

for 2008

http://msdn.microsoft.com/en-us/library/aa337169(SQL.100).aspx

the best explanation I've seen is in "Professional SQL Server 2005 Reporting Services" by Paul Turley, Todd Bryant,...

BOL instructions to copy database from earlier version

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/1f7ccfc6-c68a-4038-8ad7-8d896d041f1c.htm

I appears that your lat/longs are in reversed order.

to see how SRID returns values the following example from bol (STLineFromWKB (geography Data Type))

DECLARE @g geography;

SET @g = geography::STLineFromWKB(0x010200000002000000D7A3703D0A975EC08716D9CEF7D34740CBA145B6F3955EC08716D9CEF7D34740, 4326);

SELECT @g.ToString();

returns...

Jeff,

attached results --

charindex returns the start position of the searched for expression (":"), which is in position 21 of the string in this example; starting at position 14 of the string does...

try this

DECLARE @string VARCHAR(100)

select @string = '08/01/2010 - J.Smith: just some text'

SELECT

[Date] = SUBSTRING(@string,1,10),

...