Removing duplicates

Hi Guys,

One of the column need to remove leading number, it might be anything from 1 to 9... I only need remaining characters as nvarchar

 

Input DateType : Double Precision 

   SCAN_NUMBER

 912345678901.000

Table Name: Sales_Fact_Table

 

Output required: 12345678901 

 

Any help much appreciated.

 

Thanks,

 

D

 

Hello,

 

i have two MSI installers, it doesnt matter which runs first. But the second to run always removes/replaces any config modifications it wrote previously instead of 'add'ing them.

Here is 3 lines for the modification object im passing through.

Does anyone have any idea why this is happening. Iv narrowed it down to the 'ApplyWebConfigModifications' line which seems to be to blame.

    webService.WebConfigModifications.Add(<newsModificationObject>); //add the modification object                        
    webApp.Update();                   
    webApp.Farm.Services.GetValue<SPWebService>().ApplyWebConfigModifications();

 

Thanks

 

Hai,

How to remove rows dynamically in gridview with textbox and dropdownlist?

Thnks in advance

Hi

I have a rather complex Data Flow Task, forming part of an ETL package for a data warehouse.

problem, after looking up, decoding, looking up and decoding several attributes for a larger 'wide' demographics dimension i end up with duplicate rows.

I used to use the Sort data flow component then ticked the checkbox at bottom to remove duplicate rows.

This worked fine, but for 3+ million records it can be a time consuming step when selecting to sort on ALL attributes, which is what i have to do to get rid of duplicates WITHOUT getting rid of valid rows.

advice?

---

I.W Coetzer

Hello all!

I usually find what I am looking for on the Internet, but today this one has me stumped.  I managed to resolve the issue, but I believe the underlying cause may actually be a bug.  So, I ask if anyone else has run into this?

I had our Librarian entering Keywords into a MOSS 2007 SP1 with Infrastructure Updates server.  She put in the Keyword like the other 500 she has created, entered the Best Bets and created the Keyword normally.  The problem was when she opened the Keyword management list she got the infamous "An item with the same key has already been added".  So I did some digging on the Internet and found the KB article (http://support.microsoft.com/kb/939077) on duplicate Best Bets and the associated hotfix.  So I picked up the hotfix, tried to install, but I believe it was already included in SP1, so it would not install as I suspected.  After that I decided to do some digging in the databases, which I know is not supported and not recommended.  I found in the SSP DB two entries under the MSSBestBets table URL field similar to this:

Best Bet Entry 1 - http://www.xyz.com/site/subsite/page.aspx
Best Bet Entry 2 - http://www.xyz.com/site/subsite/page.aspx#here

Both were just created and both related to the Keyword our Librarian just made and both had unique entries in the ID field.  So...doing the not recommended or supported action, I went ahead and changed the 2nd entry's URL field to http://www.xyz.com/site/subsite/page1.aspx#here, as I know that is the "key" used in determining duplicates, and poof, issue resolved!

So, I guess my question is how would MOSS 2007 SP1 with Infrastructure Updates report that the two Best Bet URL Entries above are duplicates when they clearly are not?  Am I missing something or is this more an issue with the programming of the Keyword management portion of MOSS?

EDIT: I keep running into this issue, but appears to be isolated.  Anyone else having this problem at all???

Thanks a ton!

Jeremy

hii,

 

can anybody guide me how to Hide/Remove "Add Documnt" option of List View webpart as am having my custom upload functionality as per req.

---

Thanks in Advance !!! Cheers !!! Praveen Mandalapu

I need to be able to remove the description text within search results which displays a portion of an indexed document, however I only want this to affect a single library's documents (or sub-site).  Is it possible to localize something like this in such a way?  Through XSLT, or the sp object model, or custom trimming or anything..  maybe somehow intercept the index query results, strip out the relevant text, then pass it along.

 

Hi,

I want to remove restult tag from soap response and want to make soap response looks like following

Soap Response Desired:

 

<?xml version="1.0" encoding="UTF-8" ?> 

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> 

<soap:Header/> 

<soap:Body> 

<MethodNameResponse> 

<![CDATA[some xml data]]> 

</MethodNameResponse> 

</soap:Body> 

</soap:Envelope>

 

I use following code to remove result tag.

 

[WebMethod] 
[SoapDocumentMethod(ParameterStyle=SoapParameterStyle.Bare)]
 [return: XmlElement("MethodNameResponse")]

 

But after using this code it also remove method name tag from soap request as following you can see below there is no method name tag exists.

Soap Request After removing Result Tag

<?xml version="1.0" encoding="UTF-8" ?> 

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> 

<soap:Header/> 

<soap:Body> 

<sXmlAuth> 

<![CDATA[

<Username>UserName</Username>

<Password>Password</Password> 

]]> 

</sXmlAuth> 

<sXmlIn> 

<![CDATA[Some XML Data]]> 

</sXmlIn> 

</soap:Body> 

</soap:Envelope>

 

But I want to keep method name tag in Soap Request and want to remove result tag from Soap Response I want to make look Soap Request after removing result tag from soap response as following

Soap Request Desired After removing Result Tag from Soap Response:

<?xml version="1.0" encoding="UTF-8" ?> 

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> 

<soap:Header/> 

<soap:Body> 

<MethodName> 

<sXmlAuth> 

<![CDATA[

<Username>UserName</Username>

<Password>Password</Password>

 ]]> 

</sXmlAuth> 

<sXmlIn> 

<![CDATA[Some XML Data]]> 

</sXmlIn> 

</MethodName> 

</soap:Body> 

</soap:Envelope>

 

So please suggest my issue is that after removing result tag from soap response it also remove MethodName tag from soap request.

 

Hi,

I have my production database replicated from SQL Server 2005 (Publisher) to 2 Subscribers (1 SQL Server 2005 & 1 SQL Server 2008). Now when I try to alter a column of one of the tables I get following error:

Msg 4928, Level 16, State 1, Line 1
Cannot alter column 'newPG' because it is 'REPLICATED'.

I removed this table from the replication and tried altering the column, still the same error.
The value in colstat in syscolumns against this column is 8192. I am not able to update syscolumns to change the value of colstat to '0' even after allowing adhoc updates through sp_configure.
Here’s the script that I executed but couldn’t find success.

sp_configure 'allow updates', 1

go

reconfigure with override

go

 

begin transaction

UPDATE syscolumns 

SET colstat = 0

where name = <column name>

 

go

Need to get this resolved urgently as one project deployment is pending due to this and I cannot drop the Replication to do this.
Is there any global setting at the database level that I have to check and change?

Also, I have 1 Transactional and 1 Snapshot Replication (Limited Tables) for the same database. Can this be a blocker too?

Thanks
Mayur Kashikar

Is there anyway in SharePoint to create Feature event handler that will be triggered when there is change to site permission, like add/remove user from SharePoint Group/Site?