Hi

Sorry I don't have a copy of SSRS on this PC so can't check my answer, but I seem to remember that if you look at the properties of the...

If you want to keep the field to be the same length as it was, but leave a maximum of 4 chars kept at the end, use

UPDATE tablename

SET fieldname=replicate(‘*’,len(fieldname)-4) +...

ramadesai108

Your sample data is unique. Is the data in your database unique? If so, no you don't need to use an order by clause as your stored proc will...

Hi

Firstly, I'd recommend splitting up the table if possible!

If that's not possible, is each question's score always only one character? If so, I would use the SUBSTRING function like this:

SELECT...

The first answer that springs to mind is to add a parameter to stored proc A:

CREATE sprocA @calledby char(1)=NULL AS...

Then when you call it from sprocB, call it by...

Hi

Would this give what you need?:

selectcol1,

col2,

cast(col3 as nvarchar(max)) as col3,

col4

intodbo.TableB

fromdbo.TableA

Alun

Hi PH

I think this should do what you need:

SELECT Name, Time,TotalRevenue, CASE WHEN Time=LatestDate THEN TotalRevenue ELSE 0 END as SortOrder

FROM

(SELECTcompany.Employees.Name, data.Operations.Time, SUM(data.Operations.Revenue) as TotalRevenue,

(SELECT MAX(data.Operations.Time)

FROM data.Operations

WHERE...

Hi Ramu

I'm at home and don't have SSRS installed on this PC, so can't guarantee that my syntax will be right, but what I would aim to use is something...