Search results for query: *

Thanks, RyanEK I thoght of a solution similar to yours , even without the subquery . I can join a table to itself and using row_num value sum the rows less than the current row_num (similar to what you wrote). However I am dealing with about 2 million records, so the query consumes resources...

Hi I need to create a new column in a table, that will hold a commulative percent values. Let's assume we have a table of this structure : Month Sales Percent 1 1000 0.1 2 7000 0.7 3 2000 0.2 I have calculated the 3'rd colomn (Percent). Now what I need is a commulative...

MDXer Thanks for your help. Erez

Hi Paul I found out the EvaluateAsExpression property, and managed configuring it. I put QueryToRun as a source variable in Execute sql Task control, after changing the property SqlSourceType property to variable. Is this what you meant? Thanks Erez

I understand the logic of your answer but I don't know how to technically implement it. I have to create 3 user variables of a type string? a. QueryToRun b. Codes c. QueryToRun ??? The first one's value property is the code, The second's value is the codes separated by commas (e.g...

Hi again The results from the code I sent you + other Sql Tasks, are eventually used for creating text file results,that contains a record for each person that the process found relevant for the the desease explored. The package is built from serveral Sql Tasks. The one I asked about is one of...

Thanks MDXer I am not familiar with the script task property, maybe it is the best the solution. I will try to be more specific, and simlify the example. Suppose I have a table containing visits of people at the the medical clinic. In each visit a medical code is writeen down. Now lets...

Hello I am trying to run sql script icluded in an Execute Sql script control. The code should run on a certain list values. The code is somthing like this this: where [tablename].[fieldname] in (value1,value2...) My question is: Is there a way to set the dynamic list in advance (I call it...