So I can use the data and create a Report and send Report to User in Excel format through Send Email Task.

Could you Please Help me to solve this...

Thank you for your reply.

Data Flow >> Ole DB Dource >> SQL Commands/ Exec My Store Procedure.

Here is the sample data that I just create FYI its a Sample data. The requirement are I don't want to Insert Customer data if Customer State is NY and...

I really appreciate your help. I need to change my SP Values and it will fix my problem.

Thank You,

Yes, I am so confused, Because I am getting different results if I switch values. See Example

Date

1/15/2014

1/14/2014

1/15/2014

1/11/2014

Set @StartDate = '1/15/2014'

Set @EndDate = '1/14/2014'

Or

Set @StartDate = '1/14/2014'

Set @EndDate = '1/15/2014'

if my...

Here is simple e.g

Here is my sample data

IDSIDFNAMELNAMEDOBCITYIsActive

2245SmithJohn1998-01-10Los Angles0

3298SmithJohn1998-01-10Los Angles0

4987SmithJohn1998-01-10Los Angles0

If I select in sp, SID = 245,Fname=Smith,Lname = John and DOB = 1998-01-10 is right, rest all the data...

Thank You for your reply,

That was a sample data that i post, User can select anything from front end to merge, it could be max sid or min...

Yes DOB in my DB is DATETIME, In my sample data i created, i am using varchar for DOB. I will change it to datetime for DOB....

Like i Said, I...

I am 100% agree what you are saying, however its really hard for us to fix this problem, due to lot of restrictions or human entries...

Any Code advise for...

Thank You for your reply....

That's a bad data the user is entering and its hard for stop, that's why i am merging through first/last and DOB.

Could you please shoe me...

Here is the Little Correction... Please guide

CREATE TABLE Table1

(

ID NVARCHAR(50),

FName NVARCHAR(50),

LName NVARCHAR(50),

DOB NVARCHAR(50),

Active bit

)

Create Table Table2

(

ID NVARCHAR(50),

PID NVARCHAR(50),

Phone NVARCHAR(50),

Address NVARCHAR(50)

)

Create TABLE Table3

(

PID NVARCHAR(50),

OInfo NVARCHAR(50)

)

--Insert Table1

Insert into Table1 (ID,FNAME,LName,DOB)

VALUES ('1','Smith','Tom','12/12/2011')

Insert into...

Any Advise guys?

Thank You.

Thats just a sample data, I just created.... Yes we can use DOB datetime, but ID not we can't use IDENTITY...

Please if u think, if u have some kinda solution,...

One more question.....

I think I got from Sample data what I am looking, Could you please guide me if i want to through your code in Store Procedure to grab...

I really appreciate your good thought!!!

I will definite take a look that link...I want to finish this task ASAP so I was trying to find a easy way....

Thank you...