Something like this ?

WITH myCTE

AS (

SELECT row_number() over (partition by EmployeeID, Firstname,Salary

ORDER BY EmployeeID, FirstName, Salart ) as Colm1,*

from Employee_salary

)

DELETE From myCTE where Colm1> 1

If you are concerned about how it will run in a job, you can deploy it to a test machine with the job service running under the same credentials ...security...

Hi,

Since I don't have sample data to work with I took the AdventurWorks database as my foundation. I am not totally clear how your data looks like but below is...

I understood you are loading the records from another system. Why not stage the records locally (on your local server) and perform your needed operations there while moving from the...

One thing that you might try, call the procedure to populate all the rows and have the user do the slicing and dicing in Excel using a pivot table. This...

Are you embedding the SQL in the report or is the report calling a stored procedure? The latter would be preferred if possible.

wendy elizabeth (8/14/2014)

---

In answer to your questions and with my additional questions:

1. SystemAdmin privledges under Site Settings > Security , can you tell me what I am looking...

Or if you want less than the last day of the prior month (instead of less than the first day of the month)... just subtract a day from the answer...

I've noticed in the case of a multi value parameter, the Select ALL option shows when the code is embedded in the reports. That is, a stored procedure is not...

reddychaitanyakrishna (7/22/2014)

---

Hi Friends,

Please Help me......

I Have the below requirement........

1. Design the DB for ‘Retail Stores Business’ where various products are on sale in both physical and online stores across the...

Have you tried to connect to the reporting service through management studio? Are you able to to see the reports folder there?

What version of SSRS are you using? You should have a radio option to not set a default value for the parameter. Also, run your query by substituting a null...

WILLIAM MITCHELL (7/22/2014)

---

Back to the OP, in the event that somebody actually needs help...

If Access is prompting for a password, but there was no database password set - then the...

Some use triggers in these cases to potentially record changes to important information. These do add overhead to a tables performance but they exist for a reason.

It helps to be able to see what you are seeing. If this is still an issue for you can you post a sample of your xml data? Have you...