Member Avatar for Mike Bishop

I have a view with two tables and three fields

tables are called SC011000 and SC33013
the fields are called SC01049 and SC33013 both are datetime fields.

I want to make the third field show the biggest date.
but i am doing something wrong

I am typing in
case when dbo.SC331000.SC33013 > dbo.SC011000.SC01049 then dbo.SC331000.SC33013 else dbo.SC011000.SC01049

I get unable to parse experession. please can someone help?

Picture1.jpg 12.14 KB
  • 3 Contributors
  • 2 Replies
  • 104 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by BitBlt
Member Avatar for urtrivedi

post following
1) full structure of your views with sample data.
2) full query you are trying to get result
3) sample result expected from sample data above

Edited by urtrivedi because: n/a
Member Avatar for BitBlt

You need to put "end" at the end. A "case" statement requires that.

case when dbo.SC331000.SC33013 > dbo.SC011000.SC01049 
then dbo.SC331000.SC33013 
else dbo.SC011000.SC01049 
END
Edited by BitBlt because: Formatting
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.