Having looked closer at the example I have now realised I have miss read what it is doing. So to make things really simple. If I have the following sales...

I'm trying to achieve what this article says Quartile will do.

http://www.sqlservercentral.com/articles/Miscellaneous/sqlserverstatisticalfunctions/1255/

Specifically and I quote from the article.

"Another way of looking at extremes is to use something called the...

CREATE TABLE [dbo].[Products] (

[ProductId]char(20) NOT NULL,

[UnitPrice]float NULL

)

GO

INSERT INTO [dbo].[Products]([ProductId], [UnitPrice])

VALUES('214700 ', 0.65)

GO

INSERT INTO...

The problem I have is that the viewer can connect to the live database and select from any tables. I have had to execute deny select on payroltab to viewer...

Lets just say I have good reasons for wanting to do it my way is there a way of preventing a user connecting to a database but also still being...

All I'm trying to do is give access to live data in read-only mode on a small selection of tables. I know that if I don't use NOLOCK then the...

How do I give viewer access to schema scheme. I tried GRANT SELECT ON SCHEMA::scheme to viewer but go the message

Server: Msg 156, Level 15, State 1, Line 1

Incorrect syntax...