Viewing 15 posts - 4,516 through 4,530 (of 4,814 total)
If only I had some evidence for that... Unfortunately, the truth is that it was NEVER going to be easy, so the concern about "making it easy" wasn't...
October 27, 2008 at 11:51 am
I agree, although their position isn't surprising when you consider that such advocacy being listened to would result in more jobs for the O-S community.
Steve
(aka smunson)
:):):)
jgrubb (10/27/2008)
October 27, 2008 at 9:00 am
As rbarryyoung posted, we need more detail on how your data is structured. I look at your "datagrid", and can't determine if the column headings are part of...
October 27, 2008 at 7:56 am
I continue to think that a complete statement of the problem coming from the OP has yet to occur. There is no written description of the EXACT process...
October 27, 2008 at 7:21 am
Jeff,
Thanks for acknowledging. The only reason I chose to use a loop is because I just didn't have time to go look up the technique that selects from...
October 27, 2008 at 7:04 am
Holy OLE_DB, Batman! Looks like I'm way off here. I'd been led to believe by other sources in the past that this wasn't realistic... Mucho...
October 24, 2008 at 8:22 am
I'm not sure this is realistic. The nature of a chart is such that it has to expect the specific fields it was designed to look at. ...
October 24, 2008 at 7:56 am
It's good to have a working solution, but the performance of a WHILE loop construct for splitting strings could have problems with performance when dealing with a large number of...
October 24, 2008 at 7:39 am
I'm pretty sure there's a typo in the previously supplied solution...
Considering your scenario, I AM ASSUMING THAT YOU ARE SURE THAT YOUR QUERY WILL RETURN ONLY ONE VALUE, you can...
October 24, 2008 at 6:51 am
I would have thought that installing SQL 32-bit on a 64-bit OS wouldn't have worked at all, but regardless of that, you can't expect a 32-bit ODBC driver to work...
October 24, 2008 at 6:36 am
I just realized my code will do an infinite loop if you add a new currency pair and don't have a rate for the first date in the range. ...
October 23, 2008 at 2:21 pm
Here's a solution that should work on SQL 2000, but if table vars are 2005 only, just convert them to temp tables:
--===== Create the test rates table
DECLARE @MyTestRates TABLE (
FromCurr...
October 23, 2008 at 2:05 pm
I'm not sure I see why you need to bother calling a function to execute a stored procedure. It's just another level of abstraction. Why not...
October 23, 2008 at 12:43 pm
You don't need a WHILE loop or anything of that nature. Here's a set-based solution you can use with any given input table:
DECLARE @LoginTable TABLE (
UserID int,
StartTime DateTime,
StopTime...
October 23, 2008 at 12:26 pm
Glad you have a working solution, but I feel the need to point out that with this new "split" table, the meaning of the value in the UNITS field has...
October 23, 2008 at 11:41 am
Viewing 15 posts - 4,516 through 4,530 (of 4,814 total)