Search results for query: *

Ran that script, the problem with that is it returns all Rows in the Table, the table has duplicated itself once, so before I had 273 rows and now I have 546 rows, and every vendor is listed twice. So, I have to find all the Duplicates and delete them. I ran your script and it returns 546 rows...

I can do it on only VendorNumber sELECT * FROM dbo.AP1_001VendorMaster WHERE EXISTS (SELECT NULL FROM B.VendorNumber = dbo.AP1_001VendorMaster.VendorNumber GROUP BY B.VendorNumber HAVING dbo.AP1_001VendorMaster.VendorNumber < Max(B.VendorNumber) ) it still doesnt work, What am I doing wrong??

Here is what I am trying to accomplish... But I get an error SELECT * FROM dbo.AP1_001VendorMaster WHERE EXISTS (SELECT NULL FROM B.[VendorNumber] = dbo.AP1_001VendorMaster.VendorNumber AND B.[VendorName] = dbo.AP1_001VendorMaster.VendorName GROUP BY B.VendorNumber, B.VendorName HAVING...

I have a table, that has duplicates in them, so Basically I would like to first find the duplicates with a script, and then delete all the duplicates

I am new to Java, so I was wondering, If I have a form that someone inputs the Zipcode in one field that it can autofill the other with the county, this is for a small number of counties and like 20 ZipCodes. So is it like an if then statement. I would appreciate any help with this. thanks

First make sure that your WAN address is the address of your netgear and exchaneg server mx records and A records. The Netgear does not allow you to use multiple addresses it can only forward on its address to a local address. Then go into the router and under security go into rules, click on...

OK, here is the Situatuation, I have a Small Business Server, and I am in Florida, When a Hurricane is approaching we take the server offsite and relocate either in a secure bunker or Hotel. Neither the Hotels or Secure bunker will assign me a static IP. Is there a way to use a Dynamic IP such...

I need to create my own company invoice from within CRM 3.0 can anyone point me in the right direction on this? I want to use my format and company logo. Please Help

So our server crashed, I recreated the server and Domain, Different name, rejoined the master Domain, and now all my SMTP email have a 2@ourdomain.com. Its probably an easy fix, but I am not sure whee to fix it.. Please help.

I have 2 seperate Servers, and would like to know the steps to connect both of them and run a insert statement from one server.table.row to server1.table.row Do you use a Join first? I need a little feed back thanks

I dont understand this part case when TST.dbo.ACMARVIEW1.flatrate <> 0 then '1' when TST.dbo.ACMARVIEW1.rate <> 0 then '2' when TST.dbo.ACMARVIEW1.maximusrate <> 0 then '3' when TST.dbo.ACMARVIEW1.delinquencycharge <> 0 then '4' else null end, why am I changing the...

I tried this case statement and got this error: Server: Msg 8133, Level 16, State 1, Line 1 None of the result expressions in a CASE specification can be NULL. Basically what I want it to do is if the if TST.dbo.ACMARVIEW1.flatrate <> 0 then goto the next insert and then the next if statement...

I have this insert, first of all it doesnt work, maybe I need a Join statement, But is there an easier way to write this, cause it will not work, any help would be appreciated. Thanks in advance Insert into [dbo].[tblArTransHeader] ( TransId, TransType, BatchId, CustId, ShipToName...

No, that didnt work, It still truncated it to a 7 instead of a 07, Maybe I could do a case, but not sure how to write it in this.. SELECT dbo.arcv.*, dbo.tblArCust.CustName AS Name, dbo.tblArCust.Addr1 AS addr1, dbo.tblArCust.Addr2 AS addr2, dbo.tblArCust.City AS city...

here is the select statement the problem is I need a 2 digit code for Month, so if the number is 5 I need it to be 05 and if the number is 9 I need it to be 09 and so on, I cant seem to figure this out. its the 15th line of code and part of the 17th and 18th Can someone give me a hand? select...

How do you change the size parameter, cause I have a 18 character field and it truncates it to 9. any help?

Does anyone have an Idea of how to change the picklist in the Duration field in Microsft CRM Activities?? I cant seem to find it in Deployment Manager

I double Click Exchange Admin 5.5 and it doesnt launch, I look in tasks and it is there, but it doesnt ever come up, any suggestions?? However it does work when I reboot the server once.

here is the situation, I have a front end that calls this SP, any data that I change it brings over ok, But if I dont change it, it deletes the info from the row. So for instance, if I change the CustomerName, it changes the name and updates the table, But then it deletes all the other rows...

Can you add 2 seperate Databases from SQL to one ADP? Can it be done, and can someone send me a HowTo