Viewing 4 posts - 106 through 110 (of 110 total)
You can take hlp of the extended stored procedure sp_table_privileges.
May be this will you.
Relationships are like Banks.You Invest the Principal and then get the Interest.
He who knows others is learned but the wise one is one who knows himself.
August 8, 2003 at 3:42 am
What I feel is you can atleast do the following
1)Create a SQL Server account.This Account should having restrictive privileges i.e. appropriate rights like read and write on appropriate database...
He who knows others is learned but the wise one is one who knows himself.
August 8, 2003 at 2:47 am
What you need to do is create a store procedure which accepts a date as parameter.
Then using a where clause filter out the records for this date.
Then use the group...
He who knows others is learned but the wise one is one who knows himself.
August 8, 2003 at 2:05 am
Try something like this, The only problem is that we will get 2 recordset wjere the no data is returned for the date passed..
select productid,orderdate from invoices where orderdate=@orderdate and...
He who knows others is learned but the wise one is one who knows himself.
August 7, 2003 at 3:13 am
Viewing 4 posts - 106 through 110 (of 110 total)