Search results for query: *

The data type is 'char'.

I have some phone numbers in a SQL DB that has the incorrect area code, the number format is 3339998888 where '333' is the area code. I need to change the first 3 digits of the number to '228', how can I do this using a SQL query? Thanks

This is what I was given that worked, if any ever needs something like this again. CREATE TABLE #InventoryUOM (Company char(1), StoreID numeric(5), itemnum numeric(9), UnitofMeasure char(20), Item_Price numeric(9,2)) INSERT INTO #InventoryUOM SELECT InventoryUOM.Company...

I have tried this: update inventoryUOM set item_price = inventoryUOM_Test.Item_price from inventoryUOM join inventoryUOM_Test on itemnum = inventoryUOM_Test.itemnum where UnitOfMeasure = 'box' and inventoryUOM_Test.UnitOfMeasure = 'each' and Item_price<>Item_price But I am getting these...

I have a SQL DB that has a table named: InventoryUOM With the following data. Num UOM Conv1 Conv2 Price Cost 1 Box 1 1 0.08 2.19 1 Each 100 1 4.87 2.19 What I need to do is have the box price swap with the each price. I am trying to get a query to run this. Any...

I am looking for an install package creator that will package up my software will a few extra exe's that need to be installed as well. Also need to to create a System DSN connection to a SQL server with the correct DB user name and database name. Does anyone know of anything like this? I am...

I need to create a shared calander that a dept has access to , can this be done?

I am using Exchange 2003 and outlook 2003, I need to create a distro list with 500 people, when I try it tells me that the dist list has reached the max size for your network server, how do I increase this size. Thank you

I haved Googled it with no success.

I have an external modem. FCC is H8NTAI-20977-MM-E, I cannot find any info except that it is made by Askey Computer. Does anyone know anything about this modem, speed, etc.

I am seeing the fan on and turning and other devices come on ie..CD-ROM, HD etc, when they are connected.

It will not POST Will not POTS prior to mounting to MB Fan is mounted correct All plugs have been checked CMOS have been cleared and recleared All devices have been removed, MB has on-board video, also tried other video cards. Would it be a bad PSU even if it works with prior MB and CPU...

Done this aready, same prob.

I am upgrading a clients computer with a PC Chips MB-825G motherboard and an AMD Sempron 2400+ CPU,512 PC 2700 power supply is 250 Watt. I can't get the board to boot. I have replaced the MB, CPU, and memory, still no boot. I get power but no signal to video. I am at a lost, could the power...