Viewing 15 posts - 11,146 through 11,160 (of 13,877 total)
One way of doing this is to add new columns to your underlying selection query, corresponding to your conditions.
The value of the column will be zero unless the condition is...
September 14, 2011 at 4:26 am
Not so strange, really.
Your original code was doing SET NOCOUNT ON if the condition was true and then reverting to normal execution.
Unless your if-statement code is of the form
if [condition]
begin
multiple...
September 13, 2011 at 5:34 am
starspejd (9/13/2011)
I think I got it now. Granted, what I've made is only a small test on my own laptop, I still need to make the package on the...
September 13, 2011 at 5:11 am
No problem. Let us know how you get on and post back with any additional questions.
September 13, 2011 at 3:31 am
Those files with no extensions are a pain.
I'd be tempted to do this processing with a Windows batch file - here is one way:
1) Rename files with no extension (this...
September 13, 2011 at 3:00 am
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
Viewing 15 posts - 11,146 through 11,160 (of 13,877 total)