Viewing 15 posts - 8,491 through 8,505 (of 13,876 total)
jackimo (4/15/2015)
Here are the two execution plans - one for the left outer join and one for the not exists.Thanks again for all your help!
Both of the plans look fairly...
April 15, 2015 at 7:19 am
jackimo (4/15/2015)
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...
April 15, 2015 at 7:07 am
As an aside, you will find that your SQL becomes more readable if you use meaningful aliases.
April 15, 2015 at 6:01 am
NOT EXISTS would possibly help:
select m.lID
from Message m
join Message_Cc mCC on m.lID = mCC.lMessage
...
April 15, 2015 at 6:00 am
Your question is difficult to read. Can you reformat it to make things clearer?
April 15, 2015 at 3:05 am
Actually, this version should be faster:
select * from @SAMPLE_DATA sd
where @strname like sd.SD_TEXT + '%'
April 14, 2015 at 6:06 am
select * from @SAMPLE_DATA sd
where @strname like '%' + sd.SD_TEXT + '%'
April 14, 2015 at 6:05 am
Ville-Pekka Vahteala (4/14/2015)
Grant Fritchey (4/14/2015)
OK. Fair enough. Let's try this one. It might also be found somewhere in here... maybe.
These did not have those numbers what I asked, but they...
April 14, 2015 at 5:17 am
Grant Fritchey (4/14/2015)
I believe it's part of this report.
That link does not work for me.
April 14, 2015 at 4:31 am
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...
April 14, 2015 at 1:07 am
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)
April 13, 2015 at 8:47 am
rawatsonika4u (4/13/2015)
April 13, 2015 at 6:34 am
ankithimmatlalshah (4/13/2015)
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...
April 13, 2015 at 4:27 am
ankithimmatlalshah (4/10/2015)
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...
April 13, 2015 at 3:57 am
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
...
April 13, 2015 at 2:11 am
Viewing 15 posts - 8,491 through 8,505 (of 13,876 total)