Thanks! And here is the link again, for lazy clickers:

http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/04/16/sql-server-2014-service-pack-1-has-released.aspx

marc.heidemann (4/16/2015)

---

Notice: The SQL SSIS team has found an issue with SP1 installation if SSIS catalog is present in the SQL Server instance.They are currently investigating this issue including possible...

Can you include the proper DDL, as generated in SSMS?

Also, you have not asked a question, leaving us to guess.

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....