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

Why not just do a GROUP BY on all of the columns?

nairdeepa (9/9/2011)

---

I somehow managed to get to the stage that it creates tables taking dynamic variable name. But i am getting the below error. I have made the tables already...

kramaswamy (9/9/2011)

---

You might be able to pull it off if you used a Script Task as your Data Source, fed the object variable into the Script Task, and then parsed...

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

Also ensure that the variable is of type 'Object' if you are capturing more than one row of data.

sqldba_newbie (9/8/2011)

---

I thought of the same that package would be...

This looks very much like the same question as was asked back in January on MSDN. See here for the full thread.

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

engrshafiq4 (9/7/2011)

---

Hi,

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

That will take approximately 1 minute 30 seconds!

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

Just wondering where the Mozilla reference is coming from - could Firefox be involved?

engrshafiq4 (9/6/2011)

---

@SSCrazy

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

engrshafiq4 (9/6/2011)

---

Thanks for your reply

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