Viewing 15 posts - 11,146 through 11,160 (of 13,872 total)
Difficult to be sure without sample data.
First off, I do not recommend repeated use of SELECT INTO - you've got the overhead of deleting and rebuilding the table every time....
September 12, 2011 at 2:35 pm
Why not just do a GROUP BY on all of the columns?
September 12, 2011 at 10:09 am
nairdeepa (9/9/2011)
September 9, 2011 at 9:20 am
kramaswamy (9/9/2011)
September 9, 2011 at 8:27 am
If you mean: "can I consume the contents of an object variable as a data flow datasource?" I believe that the answer is no.
There will be an alternative -...
September 9, 2011 at 7:47 am
Also ensure that the variable is of type 'Object' if you are capturing more than one row of data.
September 9, 2011 at 5:59 am
sqldba_newbie (9/8/2011)
CozyRoc (9/7/2011)
The comment by kramaswamy is incorrect. The package will execute on Server 2. It doesn't matter where it is stored.
I thought of the same that package would be...
September 8, 2011 at 9:37 am
This looks very much like the same question as was asked back in January on MSDN. See here for the full thread.
September 8, 2011 at 3:53 am
select ...
from vwSearchResult
where (len(COMPANY) - len(replace(COMPANY, 'ltd', '')) + len(CategoryName) - len(replace(CategoryName, 'ltd', '')) + len(comp_kws) - len(replace(comp_kws, 'ltd', '')) + len(locStr) - len(replace(locStr, 'ltd', ''))) > 0
GROUP BY ...
September 7, 2011 at 3:59 am
engrshafiq4 (9/7/2011)
this is working fine for me.
select TOP 20 COMPANY,
len(COMPANY) - len(replace(COMPANY, 'piz', ''))
as numberofoccurences
from vwSearchResult order by numberofoccurences DESC
Can i do it for more...
September 7, 2011 at 3:49 am
peterzeke (9/6/2011)
Phil -- thanks for the quick reply!Looks like I need to learn about setting breakpoints and viewing the values of variables....
--Pete
That will take approximately 1 minute 30 seconds!
September 6, 2011 at 3:57 pm
Given that [User::_LoadAssignments] is boolean, I'm wondering if the question mark is merely evaluating if the variable is true/false--> if true, then include the additional criteria of Prov.Scope and Prov.Facility;...
September 6, 2011 at 3:19 pm
Just wondering where the Mozilla reference is coming from - could Firefox be involved?
September 6, 2011 at 9:02 am
engrshafiq4 (9/6/2011)
ok my questions are
1) how i will load table data to tempData(in your example)?
2) what are star ,Stir,My Fab Company etc in your example....eg (select 'star' Company union...
September 6, 2011 at 3:33 am
engrshafiq4 (9/6/2011)
But i am facing project Deadline and do not have much time to implement these coding...
Can you please give me a stored procedure which do the...
September 6, 2011 at 3:08 am
Viewing 15 posts - 11,146 through 11,160 (of 13,872 total)