Look up the syntax for ROW_NUMBER - it has an optional PARTITION BY clause. You can use this to assign a 1,2,3,etc to each value of NUMBER in one...

You've got two choices. First, you can issue DENY statements on the objects that you don't want members of the first role to access. Second, and the one...

In a properly normalised database, you'd usually model a many-to-many relationship with a junction table. If you don't have any control over the structure of your database, then you...

Users that don't have specific permissions on any particular object will not be able to access that object if you revoke the permissions for the public role on the object.

John

It would help if you could provide sample data in the form of INSERT statements, together with what results you would expect to see based on that data. Also,...

Priyank

Check what permissions have been given to the public role.

John

It's a long time since I used DTS, and I don't even have it installed any more, but I think you can use something called dynamic properties to achieve what...

Ah yes - you're right. If you can't be sure that all names appear in both tables then an inner join won't work.

John

Almost... you need an INNER JOIN on the Name column.

John

This is a simple JOIN and SUM query. Please will you show us what you've tried so far?

John

Be careful about standardising your users in this way. Although it simplifies administration, it's a security risk since it means that giving someone (or something) access to one thing...

Without seeing the script you used in your job, it's difficult to comment.

John

Group by CartesisRU, CartesisBU and HFMEntity and use a HAVING clause.

John

OK, you've got an NTFS permission issue. You need to make sure your SQL Server and SQL Server Agent account have read-write access to that folder on your X...

Dan

Although I suspect it won't make any difference to performance, I don't think you need the ISNULL, since SUM ignores NULLs.

John