SQL Date, Update Table

[Guest donald5756]

Hello, I have a couple of issues here I am new to SQL and I was wondering if I could help. 1. I am tring to pull out the month and year from my SQL database. I am using the datepart syntax and I am not sure to use this script at can someone help me. I tried to use it in the formula field in the design view of SQL, also I tried to using the SQL Query Analyzer and neither seems to work for me. 2. I am tring to do a update on a table and everytime I try to update the table I update the table with all the data from the the other table too. All I want to update is the new data. PS. I am sorry if I sent this out to many times, I am not sure if this went out or not.

[aspnetguy]

Sounds like you need a WHERE statement in your queryexampleSELECT * FROM table - this selects every row in the table.SELECT * FROM table WHERE someColumn = someCondition-this only selects the rows that meet the condition.if you post your query we can adjust it for you or tell you were you went wrong.