May 12, 2014 at 11:36 am
Paul White (5/12/2014)
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.
Thanks. This was simple version of it. Little more googling with author name and words from topic lead to this URL http://www.red-gate.com/community/books/entrypage/defensive-database-programming?utm_source=ssc&utm_medium=publink&utm_content=DefensiveDatabase. Chapter seven has rock solid inventory system done with constrains.
May 12, 2014 at 12:30 pm
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
Only if you are lucky. The character map on my (windows 8.1) laptop says the shortcut for 8 is "221E, Alt+X", which works in word but not in notepad, not in firefox, not in ie, indeed not in pretty much anything pretty much anything other than word.
Tom
May 12, 2014 at 12:39 pm
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.
Times New Roman and Arial both include the infinity symbol, so you have something pretty strange happening.
Tom
May 12, 2014 at 12:52 pm
Ed Wagner (5/12/2014)
Sean Lange (5/12/2014)
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
Ed Wagner (5/12/2014)
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. 😉
The strange thing is that the horrible cliche is true - you are only as old as you feel. I found it easy to relate to colleagues in their 20s any time from when I was in my 20s until I was well into my 60s, and I didn't begin to feel anything other than young until I was much older than 46 (a couple of heart attacks about ten years ago made me recognise that I was now middle-aged, because I had to stop doing some things, but even then I was a few years more than a decade less young than Ed is now). So I reckon you Ed and Sean are still fresh and young, and even Lynn hasnt yet hit middle-age. I guess I'll be old one of these days, but have no intention of being old before I'm really ancient. You should all have the same intention, I think. 😛
Tom
May 12, 2014 at 1:37 pm
TomThomson (5/12/2014)
Ed Wagner (5/12/2014)
Sean Lange (5/12/2014)
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
Ed Wagner (5/12/2014)
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. 😉
The strange thing is that the horrible cliche is true - you are only as old as you feel. I found it easy to relate to colleagues in their 20s any time from when I was in my 20s until I was well into my 60s, and I didn't begin to feel anything other than young until I was much older than 46 (a couple of heart attacks about ten years ago made me recognise that I was now middle-aged, because I had to stop doing some things, but even then I was a few years more than a decade less young than Ed is now). So I reckon you Ed and Sean are still fresh and young, and even Lynn hasnt yet hit middle-age. I guess I'll be old one of these days, but have no intention of being old before I'm really ancient. You should all have the same intention, I think. 😛
This is a great construction
a few years more than a decade less young
Only someone who works with maths would think of this construction.
I will spare you my usual diatribe of how middle age starts at 30 or 40 depending on if you want a 3 tier or 4 tier system
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 12, 2014 at 1:41 pm
Stefan Krzywicki (5/12/2014)
TomThomson (5/12/2014)
Ed Wagner (5/12/2014)
Sean Lange (5/12/2014)
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
Ed Wagner (5/12/2014)
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. 😉
The strange thing is that the horrible cliche is true - you are only as old as you feel. I found it easy to relate to colleagues in their 20s any time from when I was in my 20s until I was well into my 60s, and I didn't begin to feel anything other than young until I was much older than 46 (a couple of heart attacks about ten years ago made me recognise that I was now middle-aged, because I had to stop doing some things, but even then I was a few years more than a decade less young than Ed is now). So I reckon you Ed and Sean are still fresh and young, and even Lynn hasnt yet hit middle-age. I guess I'll be old one of these days, but have no intention of being old before I'm really ancient. You should all have the same intention, I think. 😛
This is a great construction
a few years more than a decade less young
Only someone who works with maths would think of this construction.
I will spare you my usual diatribe of how middle age starts at 30 or 40 depending on if you want a 3 tier or 4 tier system
The only time I really feel old is when I've exerted myself like I used to when I was in my 20s. I don't plan on actually being old until I'm really up there, no matter how my hair looks. 😉
May 12, 2014 at 1:44 pm
Ed Wagner (5/12/2014)
Stefan Krzywicki (5/12/2014)
TomThomson (5/12/2014)
Ed Wagner (5/12/2014)
Sean Lange (5/12/2014)
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
Ed Wagner (5/12/2014)
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. 😉
The strange thing is that the horrible cliche is true - you are only as old as you feel. I found it easy to relate to colleagues in their 20s any time from when I was in my 20s until I was well into my 60s, and I didn't begin to feel anything other than young until I was much older than 46 (a couple of heart attacks about ten years ago made me recognise that I was now middle-aged, because I had to stop doing some things, but even then I was a few years more than a decade less young than Ed is now). So I reckon you Ed and Sean are still fresh and young, and even Lynn hasnt yet hit middle-age. I guess I'll be old one of these days, but have no intention of being old before I'm really ancient. You should all have the same intention, I think. 😛
This is a great construction
a few years more than a decade less young
Only someone who works with maths would think of this construction.
I will spare you my usual diatribe of how middle age starts at 30 or 40 depending on if you want a 3 tier or 4 tier system
The only time I really feel old is when I've exerted myself like I used to when I was in my 20s. I don't plan on actually being old until I'm really up there, no matter how my hair looks. 😉
Feeling old is a very different thing. May you never feel old unless you want to.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 12, 2014 at 2:13 pm
Ed Wagner (5/12/2014)
Stefan Krzywicki (5/12/2014)
TomThomson (5/12/2014)
Ed Wagner (5/12/2014)
Sean Lange (5/12/2014)
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
Ed Wagner (5/12/2014)
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. 😉
The strange thing is that the horrible cliche is true - you are only as old as you feel. I found it easy to relate to colleagues in their 20s any time from when I was in my 20s until I was well into my 60s, and I didn't begin to feel anything other than young until I was much older than 46 (a couple of heart attacks about ten years ago made me recognise that I was now middle-aged, because I had to stop doing some things, but even then I was a few years more than a decade less young than Ed is now). So I reckon you Ed and Sean are still fresh and young, and even Lynn hasnt yet hit middle-age. I guess I'll be old one of these days, but have no intention of being old before I'm really ancient. You should all have the same intention, I think. 😛
This is a great construction
a few years more than a decade less young
Only someone who works with maths would think of this construction.
I will spare you my usual diatribe of how middle age starts at 30 or 40 depending on if you want a 3 tier or 4 tier system
The only time I really feel old is when I've exerted myself like I used to when I was in my 20s. I don't plan on actually being old until I'm really up there, no matter how my hair looks. 😉
I still exert myself quite a bit. I play soccer on various leagues 3-4 days a week year round. The biggest change I have seen is that I can't stop as quickly as I used to, I suppose it has to do with the extra carb storage around my 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 3:04 pm
Stefan Krzywicki (5/12/2014)
Ed Wagner (5/12/2014)
Stefan Krzywicki (5/12/2014)
TomThomson (5/12/2014)
Ed Wagner (5/12/2014)
Sean Lange (5/12/2014)
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
Ed Wagner (5/12/2014)
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. 😉
The strange thing is that the horrible cliche is true - you are only as old as you feel. I found it easy to relate to colleagues in their 20s any time from when I was in my 20s until I was well into my 60s, and I didn't begin to feel anything other than young until I was much older than 46 (a couple of heart attacks about ten years ago made me recognise that I was now middle-aged, because I had to stop doing some things, but even then I was a few years more than a decade less young than Ed is now). So I reckon you Ed and Sean are still fresh and young, and even Lynn hasnt yet hit middle-age. I guess I'll be old one of these days, but have no intention of being old before I'm really ancient. You should all have the same intention, I think. 😛
This is a great construction
a few years more than a decade less young
Only someone who works with maths would think of this construction.
I will spare you my usual diatribe of how middle age starts at 30 or 40 depending on if you want a 3 tier or 4 tier system
The only time I really feel old is when I've exerted myself like I used to when I was in my 20s. I don't plan on actually being old until I'm really up there, no matter how my hair looks. 😉
Feeling old is a very different thing. May you never feel old unless you want to.
Or, you just finished crossfit.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 13, 2014 at 5:51 am
Sean Lange (5/12/2014)
Ed Wagner (5/12/2014)
Stefan Krzywicki (5/12/2014)
TomThomson (5/12/2014)
Ed Wagner (5/12/2014)
Sean Lange (5/12/2014)
Lynn Pettis (5/12/2014)
Sean Lange (5/12/2014)
Ed Wagner (5/12/2014)
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. 😉
The strange thing is that the horrible cliche is true - you are only as old as you feel. I found it easy to relate to colleagues in their 20s any time from when I was in my 20s until I was well into my 60s, and I didn't begin to feel anything other than young until I was much older than 46 (a couple of heart attacks about ten years ago made me recognise that I was now middle-aged, because I had to stop doing some things, but even then I was a few years more than a decade less young than Ed is now). So I reckon you Ed and Sean are still fresh and young, and even Lynn hasnt yet hit middle-age. I guess I'll be old one of these days, but have no intention of being old before I'm really ancient. You should all have the same intention, I think. 😛
This is a great construction
a few years more than a decade less young
Only someone who works with maths would think of this construction.
I will spare you my usual diatribe of how middle age starts at 30 or 40 depending on if you want a 3 tier or 4 tier system
The only time I really feel old is when I've exerted myself like I used to when I was in my 20s. I don't plan on actually being old until I'm really up there, no matter how my hair looks. 😉
I still exert myself quite a bit. I play soccer on various leagues 3-4 days a week year round. The biggest change I have seen is that I can't stop as quickly as I used to, I suppose it has to do with the extra carb storage around my middle. 😉
I do too, but not as much as I used to. Besides, we never know when we'll need to tap into that reserve energy we have stored. That's why we keep it there, right? 😛
May 13, 2014 at 2:07 pm
I thought it was so you could cross the Sahara
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 14, 2014 at 4:32 am
This was a funny topic 😀 (especially the last replies)
http://www.sqlservercentral.com/Forums/Topic1570700-2799-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 14, 2014 at 4:40 am
Koen Verbeeck (5/14/2014)
This was a funny topic 😀 (especially the last replies)
Sorry, am a little short on patience today.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 14, 2014 at 4:43 am
GilaMonster (5/14/2014)
Koen Verbeeck (5/14/2014)
This was a funny topic 😀 (especially the last replies)Sorry, am a little short on patience today.
I pretty much laughed with the "I have a working and a non-working solution, what do I have to do?" reply of the OP 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 14, 2014 at 4:43 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. 😀
I wonder what that makes me 🙂 :hehe:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 43,906 through 43,920 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply