Does anyone else have access to this database or server? If so, what are they doing on it?

By default SQLExpress does not allow remote connections, so you need to go into Server Configuration Manager and Enable remote connections by enabling Named Pipes and/or TCP/IP in the network...

This seems to work with your test data:

--==== SELECT the records

;

WITH cteShipItems

AS (

...

Craig Farrell (4/13/2011)

---

WayneS (4/13/2011)

---

CirquedeSQLeil (4/13/2011)

---

Jack Corbett (4/13/2011)

---

Craig Farrell (4/13/2011)

---

Is it just me or does the constant resizing of the new ad 'Click here to monitor SSC' annoy the hell out...

select name, filename from master.dbo.sysdatabases

The driver for ORacle may not be 64 bit so you may need to run the job on the 64-bit server using 32 bit DTEXEC.exe found in the Program...

The report definitions are xml files so you could write something in powershell or .NET to query the rdl files.

Change the password and see who screams!:-P Then you can also fix the security holes in those applications. I'm only partly joking.

This is a question more than an answer, but wouldn't you want, RemoteMonitoringType_FK, to be part of the index used to satisfy this query as it is part of the...

YOu could do the counting in the query.

CREATE TABLE #test (Country CHAR(2), [STATE] CHAR(2), city VARCHAR(50), amount INT)

INSERT INTO #test

(

...

Duplicate post. Please post answers here

There is no way to close topics on SSC. They stay open for eternity and sometimes 5...

What...

I think something like this might work:

CREATE TABLE [dbo].[tblMeetingTypes](

[MeetingTypeID] [int] IDENTITY(1,1) NOT NULL,

[MeetingType] [varchar(20)]...

You should be able to do this:

=Format(sum(Fields!Total_Amount.Value), "#,##0.00")