Search results for query: *

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

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

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

Below is a stored Procedure I have wrote, However it fails with the following error ************************************************** Server: Msg 213, Level 16, State 4, Procedure p_insertCustomer, Line 23 Insert Error: Column name or number of supplied values does not match table definition...

I have a situation, I want to create an Insert trigger, I have 2 tables they are Identical one is in db1.ar1_cust and the other is in db2.ar1_cust I want a trigger that when something changes in one, it will change in the other. I was wondering if there was like a Wildcard that you could put in...

Can someone tell me why this doesn't work? I am trying to create a trigger that deletes from one table when another table gets deleted where the accountnumber in the deleted table is = to the cutomernumber in the other. here is what I tried create trigger MASdel on [dbo].[AccountBase] FOR...

Here is my trigger and it works great, However, I want to join a table called dbo.CustomerAddressBase and grab the accountbase.accountnumber and insert it into the table customeraddress.CFSMASCustNum, can I do this with one trigger? Can you Join 2 tables in a trigger? Below is my trigger, and...

This is probably a stupid question, But does a View automatically populate if you dont open it, In otherworkds, if there is a vue in the view list, and you enter data into the table that is directly related to a view will that view get the info?

This Trigger Works, But I need to make the case an interger on Division, so when it comes in as 00 it actually puts 2 zeros in instead of one. Is there a way to do it with the Case statement I am using? I really need help with this. Can anyone help? CREATE TRIGGER [mas_trigger] ON...

I need some help with this trigger, I am not sure how to Join the Db MAS_001 and Maybe I can have an Expert, Take a look and tell me Why this doesn't work, and maybe someone can help me. Thanks in advance. CREATE TRIGGER [mas_trigger] ON [dbo].[AccountBase] FOR INSERT AS insert...