Both of the plans look fairly...

jackimo (4/15/2015)

---

Thanks for all the replies.

I tried Phils suggestion of the not exists with the select 1 and I get 0 rows returned.

I'm expecting 2 rows.

I also tried MadAdmins edits...

As an aside, you will find that your SQL becomes more readable if you use meaningful aliases.

NOT EXISTS would possibly help:

select m.lID

from Message m

join Message_Cc mCC on m.lID = mCC.lMessage

...

Your question is difficult to read. Can you reformat it to make things clearer?

Actually, this version should be faster:

select * from @SAMPLE_DATA sd

where @strname like sd.SD_TEXT + '%'

select * from @SAMPLE_DATA sd

where @strname like '%' + sd.SD_TEXT + '%'

Ville-Pekka Vahteala (4/14/2015)

---

These did not have those numbers what I asked, but they...

That link does not work for me.

We have a TeamCity (TC) server which we use to automate many repetitive jobs, in the spirit of CI.

Such things include:

1) Moving changes from source control to QA databases

2) Building...

This works, as long as the folder hierarchy depth is always the same. If not, you'll have to get more complex & use TOKENCOUNT too.

token(token("c-Drive\\Files\\Data\\Claims\\Current Load\\31 Dec 2012.xls","\\",6),".",1)

rawatsonika4u (4/13/2015)

---

I’ve forgotten the password of SA account, therefore I am not able to login to my SQL Server 2008 R2. I have another account, but with no special privileges....

ankithimmatlalshah (4/13/2015)

---

Hello Phill,

Thank you for the response.

I've finally managed it with script component, wherein I replaced the column separator with vertical pipe and row separator as TAB character and managed...

ankithimmatlalshah (4/10/2015)

---

Hello Phil,

Seems like you are trying to tell the following solution.

http://visakhm.blogspot.in/2014/06/ssis-tips-handling-embedded-text.html

Actually I tried to achieve it but the replace expression is throwing an error. It does not allow me...

Try this:

if object_id('tempdb..#dates', 'U') is not null

drop table #dates;

create table #dates

(

RecordId int primary key clustered

,RecordDate datetime

);

insert #dates

...