Viewing 15 posts - 1,591 through 1,605 (of 2,452 total)
Beniamin Joke (7/13/2013)
Hello I've updated in my previous comment
we need a CREATE TABLE statement for GLCTA.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2013 at 12:37 am
any reason why you cant post the DDL on this site as per normal posts?
if you need help please ask
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 13, 2013 at 2:10 pm
please provide what your current backup strategy is?
.....am sure other experienced forum members will be along soon
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 2, 2013 at 3:33 pm
Hello Deary
you believe you have a problem with your index....but don't provide any details of this index?
sadly, we cannot see what you can see...table definitions, sample data, query plans etc.
without...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 29, 2013 at 10:10 am
Alan.B (6/25/2013)
Michael Valentine Jones (6/25/2013)
select top 1
a.[Date]
from
(
select top 1 b.[Date] from table1 b order by b.[Date] desc
union
select top 1 c.[Date] from table2 c order by c.[Date] desc
) a
order by
a.[Date] desc
I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2013 at 2:12 pm
as you say...."I will be updating this thread with the Tables soon. Thank you!"
hopefully with the requested data scripts...until then...........
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2013 at 1:05 pm
what version of Progress?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2013 at 9:40 am
as we have nothing to base code on...then here is a very simple view to get you started
SELECT TOP 1000
CustomerID = CAST(Abs(Checksum(Newid()) % 9000 + 1) AS...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2013 at 8:47 am
search this site for "calendar table"
lots of articles that may help
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2013 at 7:17 am
Shadab Shah (6/25/2013)
I search for Date functions for finding the max of the 2 dates. But such function does not exits.Is there any easy way to do it.
Thanks in advance.
are...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2013 at 2:48 am
if you run
select *
INT0 #tmp
from USG_Data
how many records are inserted?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 25, 2013 at 2:29 am
jbalbo (6/24/2013)
clientnameSTARTTIMEBOXExpr2
Frr, Chelsea2013-06-05 17:09:00.0006 5
Frr, Chelsea2013-06-06 10:17:00.0006 6
Frr, Chelsea2013-06-18 12:27:00.0001A18
Frr, Chelsea2013-06-19 11:48:00.0006 19
Frr, Chelsea2013-06-19 11:48:00.0001A19
sorry..
So in this example I only want the record for Expr2...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2013 at 1:31 pm
care to share some sample data and expected results for that data?
may clarify your issue.
best wishes
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2013 at 12:39 pm
maybe some ideas here
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2013 at 8:20 am
.Netter (6/24/2013)
Reponsibility, Department and location as soon...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 24, 2013 at 6:57 am
Viewing 15 posts - 1,591 through 1,605 (of 2,452 total)