Hi Romina,

Are you still using the looping? I don't think that will help. Just use a SCD transform and select it as a 'Historical Attribute' for the change type property...

One of the things a ETL developer will invariably encounter is data that is not trustworthy. And though we can argue that it should be (It should be!), it still...

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...