Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,3884,3894,3904,3914,392»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, May 12, 2014 5:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:03 AM
Points: 11,194, Visits: 11,167
Ville-Pekka Vahteala (5/12/2014)
I remember reading blog post or article about calculating running total so that you needed to fetch only the last row. It involved some extra column for referential integrity. I have same need, but I just cannot remember where I read it.
Any ideas where this could have been.

This? http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/01/23/denormalizing-to-enforce-business-rules-running-totals.aspx




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #1569790
Posted Monday, May 12, 2014 8:18 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:40 PM
Points: 21,755, Visits: 15,457
paul.knibbs (5/12/2014)
Problem is, there's no standard method for that which works world-wide. If you're using codepage 437 (which I believe US versions of Windows do) then holding Alt while typing 236 on the numeric keypad will give infinity, but that doesn't work for codepage 850 (UK). There's a way of using the same method to enter hexadecimal Unicode codes (in which case, +221E would work), but you have to hack the registry and reboot your machine to use it!


Unfortunately there are a bunch of machines out there that no longer have the infinity symbol loaded as a part of the default code page (you can look up and down through the character map to confirm).

My machine in the states is not on codepage 437 (old cold page for windows) and appears to be code page 858. To produce the infinity symbol, I need either find it somewhere else or use a third party tool to produce all of the unicode characters. (https://answers.yahoo.com/question/index?qid=20100707232758AAY1Urh also explains it a little bit.)




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1569868
Posted Monday, May 12, 2014 8:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 1,639, Visits: 5,626
You can always use good ol' Character Map that ships with Windows to grab the symbol--bit of a pain, but it works well enough. Main issue is that you can't really do that using the keyboard alone!
Post #1569879
Posted Monday, May 12, 2014 8:43 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:54 PM
Points: 13,471, Visits: 12,329
paul.knibbs (5/12/2014)
You can always use good ol' Character Map that ships with Windows to grab the symbol--bit of a pain, but it works well enough. Main issue is that you can't really do that using the keyboard alone!


Sure you can!!! The character map even tells you how to do it using the keyboard. In the case of infinity it is alt+236. Just hold down alt and hit 236 on the numpad.



_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1569886
Posted Monday, May 12, 2014 8:44 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:40 PM
Points: 21,755, Visits: 15,457
paul.knibbs (5/12/2014)
You can always use good ol' Character Map that ships with Windows to grab the symbol--bit of a pain, but it works well enough. Main issue is that you can't really do that using the keyboard alone!


Yup - tried the charmap that ships with windows but the infinity symbol was removed for the code pages I mentioned (mine is one of those).




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1569888
Posted Monday, May 12, 2014 8:47 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:51 PM
Points: 4,339, Visits: 3,387
Sean Lange (5/12/2014)
paul.knibbs (5/12/2014)
You can always use good ol' Character Map that ships with Windows to grab the symbol--bit of a pain, but it works well enough. Main issue is that you can't really do that using the keyboard alone!


Sure you can!!! The character map even tells you how to do it using the keyboard. In the case of infinity it is alt+236. Just hold down alt and hit 236 on the numpad.


It sure is nice to hear that others remember the old "alt codes". I remember being able to change filenames in DOS (before Windows) to contain a space or other non-printing character and it would throw people off like you wouldn't believe. Since that was "forever plus one day ago" in computer time, it makes me feel like 46 isn't that old after all.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1569891
Posted Monday, May 12, 2014 8:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:54 PM
Points: 13,471, Visits: 12,329
Ed Wagner (5/12/2014)
Sean Lange (5/12/2014)
paul.knibbs (5/12/2014)
You can always use good ol' Character Map that ships with Windows to grab the symbol--bit of a pain, but it works well enough. Main issue is that you can't really do that using the keyboard alone!


Sure you can!!! The character map even tells you how to do it using the keyboard. In the case of infinity it is alt+236. Just hold down alt and hit 236 on the numpad.


It sure is nice to hear that others remember the old "alt codes". I remember being able to change filenames in DOS (before Windows) to contain a space or other non-printing character and it would throw people off like you wouldn't believe. Since that was "forever plus one day ago" in computer time, it makes me feel like 46 isn't that old after all.


hehe. Nope 46 isn't that old at all...in fact it is only a little more than two months away for me.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1569898
Posted Monday, May 12, 2014 9:14 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 1,639, Visits: 5,626
SQLRNNR (5/12/2014)
Yup - tried the charmap that ships with windows but the infinity symbol was removed for the code pages I mentioned (mine is one of those).


If you tell Charmap to use Unicode then it doesn't matter which codepage you have, it'll be able to show the infinity symbol. Of course, if you're using an application with it that isn't Unicode capable (are there still any of those? ) then you might have issues!
Post #1569908
Posted Monday, May 12, 2014 9:31 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:40 PM
Points: 21,755, Visits: 15,457
paul.knibbs (5/12/2014)
SQLRNNR (5/12/2014)
Yup - tried the charmap that ships with windows but the infinity symbol was removed for the code pages I mentioned (mine is one of those).


If you tell Charmap to use Unicode then it doesn't matter which codepage you have, it'll be able to show the infinity symbol. Of course, if you're using an application with it that isn't Unicode capable (are there still any of those? ) then you might have issues!


That would be nice, but using the unicode value or even searching in advanced mode (for both the unicode value and the symbol itself) in charmap shows an empty symbol for infinity.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1569920
Posted Monday, May 12, 2014 9:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 1,639, Visits: 5,626
SQLRNNR (5/12/2014)
That would be nice, but using the unicode value or even searching in advanced mode (for both the unicode value and the symbol itself) in charmap shows an empty symbol for infinity.


Odd--just worked fine for me, and I know for a fact I'm using a codepage (850) which does not include the infinity symbol. Is it possible you're using a *font* that doesn't include the infinity symbol?
Post #1569923
« Prev Topic | Next Topic »

Add to briefcase «««4,3884,3894,3904,3914,392»»»

Permissions Expand / Collapse