Billing Statement

Hi,

I want to use the SELECT statement to get all my records from my table which is 20 days from the current date. I have been trying all ways but can’t get it.. help will be appreciated!

SELECT WEIGHT, TIME, USER_ID
FROM dbo.WeightTable
WHERE (USR_ID = ‘abc’) AND ….(what to put here)

i am using ms sql server management studio express.. 2005 version. thanks!

SELECT WEIGHT, TIME, USER_ID
FROM dbo.WeightTable
WHERE (USR_ID = ‘abc’)
AND time > dateadd(day, -20, getDate())

I want to be able to use that variable on the same package in an expression to validate and move to the next step.
So 2 questions:
how to i set a variable from a sql statement?
how to i use a variable as an expression in a constraint?
Thanks you for your help

I haven’t worked with SSIS myself, but take a look at this and see if it answers your questions: http://msdn.microsoft.com/en-us/library/ms140216.aspx

I have a form with multiple select statements ( 10 select statements)

how can i post the selection of each statement ?

EX:
select city :
select school :
select color :
.
.
.
etc
No i mean <select >
i think it’s called drop down menu

select? you mean like select in mysql?..

SQL Oracle

About as simple as it gets:

SELECT * FROM someTable;

Note that doing SELECT * is generally considered bad programming practice…most of the time, you really don’t need every single column of the table, so you’re just needlessly using system resources to retrieve stuff you don’t want anyway.

e.g. insert into lmms.household (id,family_name,location_id,last_update_time,last_update_user_id,creation_time,creation_user_id) values
((select households_id from world.households),(select family_name from world.households),"93469603",(select last_updated from world.households),"1",(select created_date from world.households),"1");
returns an error- "subquery returns more than one row"?
How can this statement be re-written?

select households_id from world.households
select family_name from world.households
select last_updated from world.households

those statements need to be 1 row.
just put a conditional like where whatever = whatever

How is it the same and different as an if/else if statement?

If statements are designed to select one of two branches. While that can be chained to select from more than two branches, it gets complex and hard to read. The select statement chooses from numerous branches.

If calculates the value of a logical expression. This logical expression may be very complex, but will evaluate to true or false.

Select calculates the value of an expression and then compares the result with a set of constants. The matching constant selects the branch to use.

If you have to select one of many branches it’s more efficient to use the select statement. It’s also much easier to read. If you have multiple options it’s better to express that directly rather than chaining if statements.

Writing code that is easy to understand is very important. Everything you can do to make the intention clearer is worthwhile.

The system can often use smarter comparisons rather than something like "is it 1? no. Is it 2? no. Is it 3? no …"

a. they are usually the result of the red blood cells wearing out
b. increased incidence of leukemia is not usually associated with aging
c. they include anemias and thromboembolytic disorders
d. they are caused by abnormal forms of hemoglobin f.

c. The others are incorrect.

The hypothesis of a statement is the if part.

A. Always
B. Sometimes
C. Never

B

I am working with a database that has an auto number field. I am making an applicaton to update the table so I have to have a way to get the last primary key number in the table and add 1 to it so that I can imput the correct number into the primay key field. I need to know if there is an SQL statement that will just pull the last row from a table. Right now I have a count that runs threw the entire database till it get to the bottom and stores the last autonumber in count then I add one to that and store my new data. The problem is it is slow and right now I dont want to get ride of the auto number filed but eventually I will. So anyone know a SQL statement that will go to the last recored right away?

I don’t think this can be done in a single statement. It can be done in two statements though:

SELECT MAX(your auto number field)

And then use that value in your second SELECT.

List all details for all Items where the difference between the Item Cost and the List Price exceeds $1?

ex. Select * from Items where ItemCost - ListPrice > ‘1′

The example is not incorrect I think…..

Select * from Items where (ItemCost - ListPrice) > 1

You use quotes only for strings.