Great start...but when I implement it with my software I get -271 error. Can't modify a computed column.

Many thanks for your help. I ran it in test and it went smooth. I then ran it all with the live data and of course all is...

select cast(dte as datetime)

from stutable1

(select '1/2/90' as dte UNION ALL

select '11/1/91' as dte UNION ALL

select '1/02/05' as dte UNION ALL

select '1/02/95' as dte UNION ALL

select '10/11/94' as dte UNION ALL

select...

No,

I didn't try it, because the dates given were not real. I have many rows of different data in various formats. I would like them all to...

How can an update work for changing just the two digit year to four without changing the month or day?

Thank you. That worked perfect!:D

I copied your code exactly leaving out the insert and select * statement. I uploaded a very simple screen on the client side. It's when I key in...

Thank you for the help. I can run the new table query in the database and it works, but when I use my client application, I get a Database...

This is great, how can I get the results to order by last_name then stud_id?

Thank you.  This was a great start.

Here's what I did.

select stud_id, count(stud_id)

from stutable1

group by stud_id

having count (stud_id) >1

results gave me stud_id and number of dups against that stud_id

I woul like...

First name Last name comes from another table called o_user2 column name lname, column name fname.

Got it, thank you for the help.

Enthusiast

Thank you.  That does work.  my results were has follows

MD 3205362126  GB 3205362

Would you say that's 32GB?

I'm running MSSQL 7.  Anyway I can go around this?

SELECT SUM( Cast(FileSize AS bigint) ) AS MB,

       SUM( Cast(FileSize AS bigint)/ Cast(1000 as bigint)) AS GB

 FROM o_file

WHERE volid = 16 AND groupid = 221

October 7, 2004 at 12:38 pm