Viewing 15 posts - 11,191 through 11,205 (of 13,877 total)
I should have paid more attention - I didn't notice that you had only two columns. You've found a good solution - fingers crossed you don't ever get any more...
August 17, 2011 at 10:09 am
Brian Carlson (8/17/2011)
August 17, 2011 at 9:09 am
dji (8/17/2011)
August 17, 2011 at 4:28 am
Anyone has faced this issue and solved it?
Save yourself from Excel hell and output to CSV instead. Then (apart from max row issues) it doesn't matter which version of Excel...
August 16, 2011 at 10:00 am
Maybe change your query to return 'true' (has data) or 'false' (no data) instead and build your precedence constraint accordingly.
August 16, 2011 at 9:03 am
spin (8/16/2011)
i mean something like..
select * from openquery('select * from thisTable where date >=...
August 16, 2011 at 8:51 am
Is it Informix? You might do better in a Unix db forum ...
August 16, 2011 at 7:30 am
Randy Doub (8/15/2011)
August 15, 2011 at 3:04 pm
Just adding an alias isn't enough.
Ah indeed. No doubt that fact would have become obvious very rapidly during development. I knew it was too early for me to have been...
August 15, 2011 at 7:59 am
BUT, wait untill JC will see your post... [w00t] You will then know that your table is not a table [BigGrin]
Wow, Jesus monitors this forum too?
:hehe:
August 15, 2011 at 5:21 am
greg.bull (8/15/2011)
Thanks Phil,Supplementary Question:
If all of these rows were in 1 table - could you think of a solution ? Maybe something like selecting from itself ?
Regards, Greg.
Sure - I...
August 15, 2011 at 3:02 am
Dates don't quite work that way. Try this:
select * from Sales.SalesOrderHeader
where OrderDate between '2004-01-01' and '2004-12-31'
In fact, because dates in SQL Server generally have a time component, this may be...
August 14, 2011 at 10:23 am
Something like this might do it:
select t1.MonthYear, t1.Location, Coalesce(t1.Metric1, t2.Metric1) Metric1, Coalesce(t1.Metric2, t2.Metric2) Metric2
from t1 join t2 on t1.MonthYear = t2.MonthYear and t1.Location = t2.Location
August 13, 2011 at 5:52 am
sudhakar.siram (8/11/2011)
hi guys give solution to my...
August 11, 2011 at 2:22 am
Viewing 15 posts - 11,191 through 11,205 (of 13,877 total)