Mark Fitzgerald-331224 (5/30/2012)

---

Think this is the required query. Could be tidier and perform between other ways but this passes all your suggested outcomes.

-- Sample data

declare @ProductRate table (

[ProductID] [int]...

Hi stewart

for the following values it fails

DECLARE @fromdate DATETIME =...

For the following set of value

DECLARE @fromdate DATETIME = '2012-05-23';

DECLARE @todate DATETIME = '2012-05-27';

ProductID FromDate Rate

1 ...

Thanks for the reply..it almost solved the problem

But for this Set of values it is not displaying anything

DECLARE @fromdate DATETIME = '2012-05-29';

DECLARE @todate DATETIME = '2012-05-30';

It should display like this

ProductID...

I tried this also

DECLARE @fromdate DATETIME = '2012-05-24';

DECLARE @todate DATETIME = '2012-05-26';

SELECT @fromdate = (SELECT TOP 1 FromDate FROM #ProductRate WHERE FromDate <= @fromdate ORDER BY FromDate DESC)

SELECT @fromdate

SELECT...

Actually we had the ToDate field..but due to some date range overlapping validation we removed that ....

The FromDate is not fixed it can be any date ..we can insert any date

anthony.green (5/17/2012)

---

if its only procs they need to see then create a role and just grant view definition to the procs instead of the whole database that way they only...

so it is not possible without denying the view definition..

In my company the application developers want to see the procedures...so it is not possible to deny the VIEW Definition.

The problem...

thanks for the reply...yes it is true when i deny the VIEW DEFINITION to user,he cannot generate the script.

But i cannot deny the user the VIEW DEFINITION...is there any workaround...

If i do this developer cannot see the procedures....all the procedures will be locked out

anthony.green (5/16/2012)

---

I have just tested this against my test user limiting permissions to db_datareader only and they cannot export the scripts. They can get all the way through the...

what you mean by restricted to...

Is it possible to do that

thanks paul for the...