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.
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
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
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...
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...
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...........
June 25, 2013 at 1:05 pm
what version of Progress?
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...
June 25, 2013 at 8:47 am
search this site for "calendar table"
lots of articles that may help
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...
June 25, 2013 at 2:48 am
if you run
select *
INT0 #tmp
from USG_Data
how many records are inserted?
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...
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
June 24, 2013 at 12:39 pm
.Netter (6/24/2013)
Reponsibility, Department and location as soon...
June 24, 2013 at 6:57 am
Viewing 15 posts - 1,591 through 1,605 (of 2,452 total)