on a join condition it does not make much sense for the join condition to reference the same table.

does tableA have a column named rowno ?

also on a join condition it does not make much sense for the join condition to reference the same table

I would add a conditional split to the data flow and split based upon the primary key of the text file , if there is no primary key then...

It can depend on your exact situation, but in general i would say that it is not a good idea, as you want the data in your database to be...

Also have you considered using Full Text search instead of using Like ?

It could be worth a test.

No we were not able to implement CSS changes so we left the dashboard as is.

Maybe you could use Firebug for Firefox to inspect the page and find the correct...

Kenneth Wymore (3/17/2011)

---

We were trying to do this same thing and never found any work-arounds. There are supposed to be some new Performance Point books coming out later this year....

Sorry i was expecting a T-SQL script, i havent done any VB for a while but it looks like you are on the right track

you may have to add...

That's not clear we need more information about what you want to do in order to provide a helpful response

have a look at the SubString Function it should do what you want.

You can find some of this information from right-clicking on the database and selecting reports --> standard reports --> Schema Changes History.

It can be a tricky to track down specific...

You are getting the error because you do not have anything that makes the rows unique.

The way the rows are presented in SSMS are different than how they are stored...

you could change the datatype at the destination table and then either impliciitly or explicitly convert the data in the data flow.

Its adding 100 to the day and then taking the last two values.

Where i think this is being used for , is to convert single figure days (eg, 1,2,3,4 etc..)...

I don't think SPs will speed things up.

are these just new records that are being added? if so you could look at using SSIS or Bulk Insert.