hi,

When i try this @[User::Exec_Path]+"\\"+ @[System::TaskName]+".dtsx"

i get below error message

------------------------------

The variable "System::TaskName" was not found in the Variables collection. The variable might not exist in the correct scope.

Attempt to parse...

Hi

Article was really simple to understand which helps in solving complex queries.

My Humble request could you also post on other JOINS as well.

Waiting for those articles

Thanks,

Suresh

Hi Frank,

So ur suggesting to have new row in tb_reports table for each modification so that querying will be easy.I will try that.

Thanks & Rgds,

Surjit

Values in the tables

table tb_user

###############

id_user;name;email

1; abc; abc@abc.com

2; xyz; xyz@xyz.com

3; pqr; pqr@pqr.com

table tb_report

###############

id_report;posted_by;title;description;modified_by;modified_date

1; 1; ...

tb_user table

_____________

id_user(PK) auto_increment

firstname varchar(50)

last_name varchar(50)

email varchar(50)

....

tb_report table

________________

id_report(PK) auto_increment

posted_by ==id_user which is PK of tb_user

title varchar(100)

description text

modified_by varcgar(100) which gets updated as [previous value of modified_by + new value and then...

Hi Frank,

When i run ur query i get number of records posted by particular user.But i want list of all users who has edited the report something like below

Monthly Report...

Hi all,

Actually i have 2 tables :tb_user and tb_reports.Now whenever anybody modifies the report i update in tb_reports table with user id which is Primary key in tb_user. Table tb_reports...

Hi Frank,

Thats true....i need to change my business logic.

Thanks a lot for ur quick responses.

Rgds

Surjit

Hi Frank,

Thats right when u select distinct...when i query only select...then it should display all records..i need all records for my application which tracks history...so i think by default Sql...