Search results for query: *

Try this: You give it a year and a month and it tells you the number of days. The concept is add 1 month to the first day of the month then subtract a day. You then have the last day of the given month, just take the day field out of that day... DECLARE @Y varchar(4) DECLARE @M varchar(2) SET...

sunila7, That's correct, I neglected to count those 22 days, and the DuringDays for March should be 26+22=48. Thanks, Jamon

Please Copy/Paste this question into NOTEPAD or a word processor with fixed-width fonts if you have problems seeing the table lines, etc. table 'service': +----------------+-------------+--------+ | effdate | status | units | +----------------+-------------+--------+ | 2002-11-28...

I was leaning toward creating a view as my solution, but I wanted to get confirmation that this was the most correct way of doing it. Thanks.

I forgot to mention, It's crystal Reports 8.5, so I can't just put it in as a SQL command like you can in 9. Thanks, Jamon

I've created some decently complex SQL in another application (MS Query Analyzer) and I'd like to use it as a base for my Crystal Report. The only catch is, I can't use a .qry file created with Seagate SQL Designer because the report won't be able to find the external file when imported into an...