Viewing 15 posts - 391 through 405 (of 621 total)
smunson (10/23/2008)
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
I...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 23, 2008 at 2:45 pm
I found this in BOL under DATEPART
DECLARE @date DATETIME
SET @date = '12/15/1997 11:59:00 PM'
SELECT DATENAME(dw,@date),DATEPART(hh,@date)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 23, 2008 at 12:36 pm
sognibene (10/23/2008)
Note for rbarryyoung: the code you sent seems to choke for SQL 2000 when building #MyTestCurrencies - it thinks Name isn't in the group by.
This will fix it.
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 23, 2008 at 7:50 am
sognibene, no clue about 2005.
Barry, just so you know...I'm sucking my thumb right now. Thanks so much for lending us your time an superior expertise, I have so much...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 23, 2008 at 7:44 am
Barry
One more thing you might want to consider, is the scenario that broke my loop situation. Is there ever going to be an instance where for a given date,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 22, 2008 at 1:43 pm
sognibene
I know there is a better, set based solution, but my yellow belt SQL skills preclude me from grasping it. With that being said, I have a loop solution...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 22, 2008 at 12:17 pm
sognibene,
I have been working on this to no avail. There were times when the correct result was right on the tip of my tongue, but I could not catch...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 21, 2008 at 10:12 pm
DOH!...I didn't even think that was what the OP actually wanted.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 21, 2008 at 1:00 pm
milzs, have you tried?
SELECT
*
FROM sysobjects
WHERE id = 1655012977
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 20, 2008 at 12:50 pm
Here is one method that I use, mentioned by Garadin. It seems to be working for my situation, but you should try to "break" it. Maybe I have...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 20, 2008 at 12:32 pm
FreeHansje (10/16/2008)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 17, 2008 at 12:25 pm
Can you import the file into a table, then update it there?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 15, 2008 at 2:24 pm
Karthik, check this out, I think it will work for you if you modify it a bit.
http://www.sqlservercentral.com/articles/Advanced+Querying/pivottableformicrosoftsqlserver/2434/
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 8, 2008 at 1:40 pm
Sorry Karthik, variable column names would be way over my head.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 8, 2008 at 11:27 am
Karthik
This is just my opinion, but it seems like the measurements are more stable than the managers. Wouldn't it be better to have the measurements as columns and managers...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 8, 2008 at 8:36 am
Viewing 15 posts - 391 through 405 (of 621 total)