Search results for query: *

I decided to backup the database and then restore it...I am thinking that is my best bet. We are using the same server so installing the new version and then transfering is not going to work. Thanks...

Can you script a DTS package to reinstall on a new version of SQL

Thanks boss I am all over it...

Nope that is not it...I am trying to calculate the months between both start and end date and then multiply by 12 to get an age...

I used the help funtion but this returns me a date not a number. DATEDIF(start_date,end_date,unit) I want to get a number not a date

Thanks Bill that was right on time...

I have a birth date and another date that I want to use to calculate the age of a person during a period other than what is represented if I used getdate(). Problem is using datediff gives me the years but skips the calculation of the actual date of birth during the other period. Example: I have...

Ratio: IIf([dmat_w_3set]+[dmat_l_3set]=0,0,([dmat_w_3set])/([dmat_w_3set]+[dmat_l_3set])) I used this in access and now I want to traslate it to SQL but the If statement is not the same contruct and I can not find it anywhere. Any help would be appreciated.

Now that my IIF statement works properly, I need to rank the data according to the best percentages. How do I create a field that numbers the records according to the best percentages? example: Player Wins losses PCT Rank Player 1 2 0 1.00 ? Player 2 6 1 0.86

Thanks that was it!!!

I have written the following IIF statement: IIf([Wins]/([Wins]+[Losses])=0,0,([Wins]/([Wins]+[Losses]))) The reason I wrote it this way because I have fields that would give me a 0/0 scenario. I'd like to account for this and return a 0 in that instance. Is there a way to do this or am I...

Hey guys I know I am close and there must be a small problem. I am still getting this Overflow error when I try to connect and build a database in Access using the MSDE. Any help would be greatly appreciated...

I just installed the MSDE on my computer. I am trying to build a new database but the connection wizard keeps kicking me out with and "Overflow" error. Anybody have a clue how to get around this one?

Thanks guys how stupid of me...

I am trying to calculate age. My formula reads age: Datediff("y", [birthdate],now()) I get some long number that is not even close...Am I missing something here?