I want create a Incrementing row through a variable in Derived Column Transmition,For that i created a variable called 'Increment'..in the derived column iam creating a new column with this expression
@[User::INCREMENT] == @[User::INCREMENT] + 1
Is anything wrong with this statement..bcoz iam getting 0 or the value which i assigned (1000)to all the rows.
Can you pls suggest some solution
Niru
Problem with Incrementing variable
Hot Topic
- creating a database
- Syntax error converting the varchar value 'a' to a column of data type int
- Can't run param server reports using ReportViewer control.
- Table Column Change causing errors in Cube
- Intermittent rsProcessingAborted - rsErrorOpeningConnection across all reports, users
- Blob as text
- Making SSAS Developer Edition act like standard edition
- ForEach Config validation errors
- Two Digit Year Format - Loading Data
- Can't Start SS Business Intelligence installed from SS 2005 Express Edition Toolkit
SQL Server
- Since I execute a pakete from t-sql
- Execute a package on a remote server
- SQL 2005 “LEFT OUTER JOIN” ISSUE
- Variables Window
- Uploading images to SQL Express
- User Instance Errors
- Execution not found when using Dynamic Windows Impersonation
- Memory Error: Dimension Processing on Analysis Services 2005
- SQL Server 2005, MS Access Merge Replication?
- Disable exporting in RS
Problem with Incrementing variable
Toni
If I have 4 incrementing fileds in a table ,can I create 4 variables with in a single script and map those variables to respective fileds (Or) I have to create seperate script for each and every variable
Thanks
Kumar
Troy
You can do it all in one script.
-Jamie
stiversj
Yeah, that won't do what you want. if you want to generate contiguous IDs then look here: http://www.sqlis.com/default.aspx 37
-Jamie