I don't know if it's possile to draw shapes in reporting services... but you could always create a jpeg of a circle and then put a picture box on...

HTH.

You have to setup a job that checks periodically for the file arrival, then you can have that job start a dts package.

This could give you the time range to present in the select :

DATEADD(HH, DATEDIFF(HH, 0, TIME_STAMP), 0)

This does a group by on each our of each day... You'll have to either do some gymnastics on the server to get back the hour number into a...

Remove the /24 (in the select and group by)... it's just a mix of 2 ideas.

SELECT CAST(ROUND(SUM(ACCTSESSIONTIME) / 60, 2) AS DECIMAL(18, 2)) AS SessionTime, DATEDIFF(HH, 0, TIME_STAMP) / 24 AS Hour

FROM ACCOUNTING

WHERE...

I can't find anything on yahoo that would lead me to believe that this is possible. Nothing in books online either.

Can you post the statement and what you are trying to accomplish?

I had already came upon that link... but I'm not really the kind of guy to miss work for a movie...

Ya gonna need it... 3 days week-end here.

So it's time to log off now.

Ok... but I preffer being referred as Neo or Luke .

Not sure you need the not null... cause if there's no price then there's no row so the join won't update the line at all.

Yes, you should always specify the column names for the insert before inserting the valu.

ex :

Insert into dbo.DummyTable (col1, col2, name) Select col1, col2, name from dbo.Table2.

That way sqlserver...

My mistake.. I was referring to this script :

CREATE TABLE [dbo].[TypesCommentairesADPS] (

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

[DescTypeCommentaireADP] [varchar] (50) COLLATE French_CI_AS NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[TypesCommentairesADPS]...