Search results for query: *

This is what I ended up doing and it works also: SELECT CASE WHEN right(sug_retail,2) >50 and right(sug_retail,2)<95 then replace(sug_retail,right(sug_retail,2),95) else replace(sug_retail,right(sug_retail,2),50) end as NewPrice or for the full version: case when...

Does anyone know of a way to round currency to the nearest .50 or .95? I need to calculate the retail cost of an item by taking the price + $3.00 * 1.43 and round it to the nearest .50 or .95. We always want to round up for example 47.44 would be $7.50 and $7.51 would be $7.95.

Thanks Denis!

How would apply that is this scenario: I want to insert approx. 3900 records into table A but I have to look at table B in order to make sure I am pulling the correct records. For example: insert into cpnpmi_t (pmo_cde,itm_num,bil_cur,pmo_chc,pmo_cde1,seq_nbr8,itm_num1, sub_chc) SELECT...

I am trying to find a way to increment a field by 10 for each new record that is inserted into my table. The current value of the field is 00000000. I would like each record after the original to increment by 10 when added such as 00000010,00000020,00000030.... Can anyone show me how to do...

Thanks Steve.

This will be a bit lengthy but here is some of the source BuildFileForm.cs using System; using System.Drawing; using System.Windows.Forms; using System.IO; using System.ComponentModel; namespace FFB { /// <summary> /// Description of BuildFileForm. /// </summary> public class...

All of the fields that have <tag/>, meaning the field is empty, pop up with an error that say field name can't be found. If I change the XML to <tag></tag> the file runs through just fine.

I am using a SharpDevelop program that takes an XML file and converts it to the format I need for data upload. The client is send the XML file with <test/> as the closing tag when a data field is empty instead of <test></test>. Does anyone know of a way I can change those tags to a well fromed...

I am using a SharpDevelop program that takes an XML file and converts it to the format I need for data upload. The client is send the XML file with <test/> as the closing tag when a data field is empty instead of <test></test>. Does anyone know of a way I can change those tags to a well fromed...

Here's some sample data. The first column is order number and last column is donor number. For the first record I would like the itm_nbr to be 0001. The itm_nbr for the second record should be 0001 and 0002 for the third record since record 2 and 3 have the same donor number and order number...

The donors each have a unique id assigned to them, such as 010000068070. If the same donor number appears twice you know that the donor has multiple gifts(donee's). The layout of my table is as follows: I need to populate the itm_nbr field with the record count as descibed. select ord_nbr...

this is what I have so far DECLARE @count int DECLARE @pos int DECLARE @total_subs int DECLARE @N INT SET @pos = 1 SET @total_subs = 228 SET @n = 1 SET @count = 0 -- Declare temp variables to store row data DECLARE @v1 char(12) -- Declare cursor selecting correspoding data with temp...

I need to update a table with item numbers for each record. For example if the donor only exists on the file one time, his item number would be 0001. however if the donor exists on file multiple times I need to set the first item number to 0001, the second to 0002, and so on. Any help would be...

Thanks!

Yes the should have access to the table. The table has permissions set to all users. I have other reports that are pointing to the same server just a different table and they are working fine. Trisha

I created a query within SQL that I am trying to use as an external datasource within excel. I made my connection to the SQL server and told it which table I wanted to use. Everything seems to work just fine under my login but when someone else tries to open the file that is not a domain...

I did not add anything new or change anything in the operating system or BIOS settings. Yes it was shudown properly and I did not notice it being overly hot before this problem occured.

I do not receive any error messages but when I turn the computer on it loads all of the system information and then just goes to a black screen with a cursor flashing in the upper left corner before it even gets to the Windows splash screen. I just had the computer on a couple of days ago and...

I am trying to find a way to create a general ledger within an Access table so that I can report off of it. For example, I have withdrawals, deposits, and balance forward. I can't seem to find a way for the balance forward to automatically update instead of figuring the amount manually and...