Thanks Thomas, that worked and now thats cool how that works.

Stubob: Thanks for your idea, its a bit long winded and no I cant just use a group by...

Yes, I have I am only working with 1 year for now. Once I get the query working to actually show me the number I am looking for, I...

Hmm no, I need it per year by terminal summed up.Pretty much I just want a sum of the number as its part of a bigger query.

so if...

I was able to take Jonathan's idea to what exactly I need it.

SELECT CONVERT(tinyint,datepart(month,Date_Requested),120) as the_month,CONVERT(smallint,datepart(year,Date_Requested),120) as the_year, COUNT(date_requested) as accidents FROM Accident_Reg

GROUP BY CONVERT(tinyint,datepart(month,Date_Requested),120),CONVERT(smallint,datepart(year,Date_Requested),120)

I needed the...

By if i do a full backup to Disk would that get everything? I am assuming it will since when I backup to tape it does since I had to...

Hmm I see, so I will need to backup stored procedures as text files to back them up along with the data.

Matt

Thanks that worked but I do need to do more testing.

As for your question ganesh you need to break your inserts and updates. You can not have it...

I am going to switch it to one table its not really necessary since people are going to select more than insert/update just hope they don't keep adding fields to...

That was my problem, not getting the parent/child in the right order. hmm I am not really certian that this is the best way to design it either I...

Hmm that sounds good david but how do you parse out the comma delimited variable as there is no type of split function that I found?

Matt

no I do not need to view, that is pretty straightfoward I need to be able to write to the table. Since there is no array's it gets a...

nope its not PL-SQL. It's UniSQL. It's the sql you use to access Unidata databases. I was just seeing if there was a problem with my where...

I fixed it for the time being. The SQL Server Agent WON'T start under local so I used admin and gave it sa priviledges.

Matt

And how do I check that? All of SQL Services can start just fine, I just can not start my backups. I do not have an NT AUTHORITY\SYSTEM login....

hmm very interesting error message:

Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO (ODBC SQLState: 28000)] Error 18456: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'.

Any ideas?...