Can you help me with where exactly I need to place the distinct ?

The destination database will have several stored procedures and views that should not be wiped off . Hence simply restore cannot be done.

I temporarily moved the log file to a different drive.

As of now , auto growth/maxsize is set to By 10%,Limited to 2097152 MB. Can we change anything here.

Thanks,

PSB

I receive

The transaction log for database is full due to 'ACTIVE_TRANSACTION'.

and

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count =...

Also I get

The transaction log for database 'ITT' is full due to 'ACTIVE_TRANSACTION'.

Date1 in the resubmit.

For Desired Open Count ,7/17/2015, (1+4+3) = 8 and DesiredOpen for 7/16 = 3 so 8 + 3 = 11 is the cumulative sum for 7/17 . We have different...

Thanks All for your response . I basically want the cumulatives to be grouped by Open or Closed Date . Example shown below .

CREATE TABLE #TestTable(

[IndividualDate] [datetime] NULL,

ClosedCount INT,

[ClosedDate] [datetime]...

Here you go ...

CREATE TABLE #ListString

(

JobNo VARCHAR(10),

InvNo VARCHAR(MAX),

Address1 VARCHAR(100)

)

INSERT INTO #ListString ( JobNo, InvNo ,Address1)

SELECT '3079', 'abc' ,'Add1'

UNION ALL

SELECT...

I am not getting distinct values .

CREATE TABLE #ListString

(

JobNo VARCHAR(10),

InvNo VARCHAR(MAX),

Address1 VARCHAR(100)

)

INSERT INTO #ListString ( JobNo, InvNo,Address1 )

SELECT '3079', 'abc' ,'Add1'

UNION ALL

SELECT '3079', 'abc'...

I am already this expression in the 'Use this image' text box and it works correctly in the default run .

=IIF(First(Fields!FirmID.Value, "dsDataset1") = 1, "Logo1", "Logo2") .

The users should be...

It will be used in a temp table for a report procedure . Not stored in the db.

Great ! Thanks a bunch . 🙂

Please attach the sample report and thanks so much for helping!

Thanks for the solution . I want Order2 to utilize (Legend1 + Order1) space and not shift to the left .

Example Legend takes = 3cm and Order1 takes 4...