I have a report. I am showing charges for each record. Sometimes I want all the charges multiplied by 50%. Other times I want all the charges in the report multipied by something else. what is the best way to do this. A pop up box???
ex:
Report w/ 100% of charge
charges
30
20
90
...
Report...
is there anyway to change the collation on all of the fields in a table at once. without alterting all of the field column names seperatly. is there a better way?? this is what i'm doing
go
ALTER TABLE table1 ALTER COLUMN column1
char(2) COLLATE SQL_Latin1_General_CP1255_CI_AS NULL...
is it possible to create a query in ACCESS using a full outer join?
i know how to create an left outer join.
i get errors when i try to create a full outer join.
Is there a better way to Update fields?Below works, but is there a better way?
1.Delete all hyphens, apostrophes, blankd, periods, II,
Update tablename
set first_name= replace(first_name, 'II', "")
Update tablename
set first_name= replace(first_name, '-', "")
Update...
i have ten small tables for each state. i have ten reports. i would like to combine the ten tables by state into one report. what is the best way to do this?
NY NC
1 y 1 r
2 y 2 r
3 n 3 y
I have a table called table1. I would like to create a table called table2 that will contain all the duplicates in table1 based on fields:same-type, ssn or id, date and code.
my atempt below doesn't work. if you have any other ideas, please let me know.
select *
insert into table2
from...
I have installed SQL server 2000 on my computer. When I open a DTS package, I get the following error message:"DTS Designer Error". Any ideas on what to do next??
Thanks sooooooo much.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.