May 12, 2014 at 5:51 am
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.
May 12, 2014 at 8:18 am
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 12, 2014 at 8:34 am
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!
May 12, 2014 at 8:43 am
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. 😀
8
_______________________________________________________________
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 12, 2014 at 8:44 am
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 12, 2014 at 8:47 am
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. 😀
8
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. 😀
May 12, 2014 at 8:52 am
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. 😀
8
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 12, 2014 at 9:14 am
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? :-P) then you might have issues!
May 12, 2014 at 9:31 am
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? :-P) 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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 12, 2014 at 9:34 am
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?
May 12, 2014 at 9:44 am
paul.knibbs (5/12/2014)
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?
I'll try a few more fonts. Tried a handful like arial and times to no avail.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 12, 2014 at 9:47 am
Sean Lange (5/12/2014)
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. 😀
8
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. 😀
I know there are those out there older than me, but you two are still youngsters.
May 12, 2014 at 9:51 am
SQLRNNR (5/12/2014)
paul.knibbs (5/12/2014)
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?
I'll try a few more fonts. Tried a handful like arial and times to no avail.
Odd - finally found one in Segoe Print - very odd it isn't in the others.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 12, 2014 at 9:53 am
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
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. 😀
8
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. 😀
I know there are those out there older than me, but you two are still youngsters.
Yeap!!! In the real world I am one of the older ones, around here I am probably closer to the middle. 😀
_______________________________________________________________
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 12, 2014 at 10:03 am
Sean Lange (5/12/2014)
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
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. 😀
8
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. 😀
I know there are those out there older than me, but you two are still youngsters.
Yeap!!! In the real world I am one of the older ones, around here I am probably closer to the middle. 😀
Yeah, I may be in the middle, but I sure don't feel like it all the time. Nonetheless, it sure is nice to be called a "youngster" once in a while. Thanks, Lynn. 😉
Viewing 15 posts - 43,891 through 43,905 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply