Viewing 15 posts - 1 through 15 (of 17 total)
This appears to be a method by which we will be able to move the data but what about some way to keep it up to date?
May 3, 2010 at 1:36 pm
This is what I ended up coming up with and it returns the correct data but I have been told that using "LIKE" is a "no-no".
SELECT iAvailable = CASE...
March 4, 2010 at 12:39 pm
Thanks, you helped me come up with this:
CREATE VIEW dbo.fullSchedule
AS
SELECT i.name, i.Slot, s.customerID, i.aDate
FROM (SELECT ...
February 22, 2010 at 8:06 am
This is really close but it does not generate the dates for future jobs. I generated a dateTally table similar to what you did for the next 30 years. Would...
February 19, 2010 at 3:34 pm
Ok maybe I should go about this a different way, because I guess I am not clearly explaining what I need to get done.
An alternative to what I explained before...
December 29, 2009 at 2:25 pm
I do apologize for my hasty post.
I am trying to find the #file_info.[fi_username] that caused the #file_modify.[ChangeType] from the data contained in the #file_info
It may be very general and...
December 29, 2009 at 12:45 pm
Yeh, that only returns a single row
October 27, 2009 at 6:46 pm
I came up with this but I am unsure if it is actually returning what I expect.
SELECT TOP 100 PERCENT towergrid_reference_natowers_1.origin_latitude, towergrid_reference_natowers_1.origin_longitude,
...
October 27, 2009 at 4:33 pm
Thanks Lowell, you helped by helping me learn how to describe the problem as a "conditional count" thanks very much for that extra bit.
October 20, 2009 at 12:12 pm
I didn't realize that it would act almost like a cursor processing through the records like that, I must rethink my whole sql knowledge now.
October 20, 2009 at 12:02 pm
Very very nice, That's awesome. Not sure how I would ever come up with such a solution.
October 20, 2009 at 11:56 am
No it gives a total of the whole table with the < 1, I am looking for the result for each individual lat, lon combination.
October 20, 2009 at 11:38 am
Now, I am not necessarily looking for the solution but maybe to a site that might have the answer even with some reading. (Trying to learn this, not get someone...
October 20, 2009 at 11:30 am
Thanks alot for pointing me in the right direction.
October 20, 2009 at 7:34 am
Viewing 15 posts - 1 through 15 (of 17 total)