drop the C2 in the ORDER by inside DENSE_RANK(), i.e.

SELECT dense_rank() OVER (

ORDER BY c1) AS [Nu], c1, c2

...

That's what GSquared was getting at. Since you want to pad, you want all of the results to be a certain width, even if the non-padded has a variable...

Current process assumes that #emplist table provides the start and end dates specific to each person. Your permanent table would need to continue to provide that, or you can...

I'm with Lynn - add column, run update process, drop old column.

Mike DiRenzo (1/17/2008)

---

Try this:

Without sampling a large population of your nvarchar date data, I will assume the example you gave will be sufficient.

Here I simulate your scenario.

declare @TestDateValue nvarchar(50)

set @TestDateValue...

The only thing making the sequence go in the same direction or opposite from the date is this line:

create unique clustered index uc_empshifts on #empshifts(empid,shiftdate DESC)

By making the index DESCending,...

Not a genius - just another hammerer who's been playing with the hammer a little while longer:).

Glad it worked out for ya!

oops - that's what I get for editing on the fly:

if object_ID('tempdb..#emplist','U')<>0

Drop Table #emplist

if object_ID('tempdb..#empshifts','U')<>0

Drop Table #empshifts

go

declare @g datetime

select @g=getdate()

CREATE table #empList (

[empID] int NOT NULL,

[ShiftType] ...

Sure - go into the report you want to parameterize, and click on the data view.

You should have a SQL statement that looks something like:

select * from mytable

Modify the query...

Put the sub reports in a sub-project, and publish the sub-reports to another folder than the main reports. You can then hide the entire sub-report folder.

You sub-reports references would...

Sounds like Thanksgiving at my house: my faimly is entirely composed of Millers/Smiths and Joneses.

Like my wife would say - "it like walking into a witness relocation program...

Hard enough...

So - anyone up for a good round of sine/cosine/tangent/arctengent?

Remember: SOHCAHTOA...

Ahhh - high-school math....Nope - I still don't remember most of it@

That's HTML for ya:)...You could spend years formatting that and HTML will kill it in no time flat...

You just pull a fast one there - the Saturday rule wasn't there...

Reverse the date assignments as well as well the clustered index, and add the saurday rule

if object_ID('tempdb..#emplist','U')<>0

Drop...