@lowell,

Thank you

@sean

HI,

yes, i have an index on that column..

@Jones,

I'm deleting from parent->Child->GrandChild

And i'm looking at Recent expensive Queries in activity monitor to get the averageduration.

My Table Structure is like

Student Table in which i have student id as the...

@drew,

Thank you so much, can you explain me how i can do that with output clause as i never experienced that.

Table A is a staging table and we are pulling data from that table to tableB and tableC

Thank you so much toddasd

I should kick myself for not lookin into that.

Actually that is just sample statement according to my original query.

Hi

No linked server. We are just trying to pull data from another server to my local machine.

Thank You so much Guys:-)

Sorry for confusing you. We get a record inserted today and may have an update for that record as well today.

It's my mistake that i haven't gone through that...

Actaully it's working fine with exec sql task but getting stuck if i use dataflow task. I'm bit unsucessful to find out why its getting stuck with dataflow task when...

But i'm getting an error when i execute this code

Query:

select name , ' Geo: ' + Geo + ' Sci: ' + Sci

from name

Error:

Msg 245, Level 16,...

Create Table A

(

Name varchar(5) null,

ID Int null,

DateCreated Datetime null

)

insert into A

Values('Card',1,'2011-09-02 13:48:22.320')

insert into A

Values('Comm',2,'2011-09-01 12:35:12.367')

insert into A

Values('Synt',3,'2011-09-02 11:20:36.128')

insert into A

Values('Rubi',4,'2011-09-02 09:48:23.417')

Table A is the actual Table

Table B

Create Table B

(

ID...

@r.p,@sean,@lutz: thank you so much guys..

Hey,

I tried it but couldn't get the logic for that.

I tried to use case statement but wasn't successful with that as it will be helpful for returning single cloumn.

I'm not...

Thanq so much guys. Your answers helped me out...