Viewing 15 posts - 10,111 through 10,125 (of 10,143 total)
<<exactly the same way as noon belongs to pm.>>
Absolute rubbish as usual.
http://www.worldtimezone.com/wtz-names/wtz-am-pm.html
Do try to get something right.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 27, 2007 at 6:15 am
Hello
If you know the maximum depth, or there's likely to be a sensible maximum depth, then you don't necessarily need to use recursion. If this is indeed the case then...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 27, 2007 at 5:45 am
Rarely. Really.
Here's another expression representing a number: "pair". It means 2. Like "one third" (or 1/3) it's a text expression, not a number, although it requires no evaluation.
Here's a handy example of usage:...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 26, 2007 at 7:29 am
You've finally got something right.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 26, 2007 at 6:29 am
Nope, like 0.(3) it's NOT a number, it's a representation of a number. An expression.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 26, 2007 at 6:13 am
1/3 isn't a number, it's two numbers and an operator - an expression. Any child could tell you that. So why ask how to store 1/3 as a single number when...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 26, 2007 at 5:48 am
SELECT ...
FROM table
WHERE NULLIF(field,'') IS NOT NULL
or
SELECT ...
FROM table
WHERE ISNULL(field,'') <> ''
I'm gonna have a beer now...on second thoughts, think I'll have a beer instead, just for a change.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 25, 2007 at 10:29 am
Julia, try a slightly different syntax:
UPDATE C
SET ITEMS = ITEMS + 1 ---
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 25, 2007 at 9:06 am
Just a thought, and I don't have SS2K5 to test it on...try using SQL Server Import with one of your excel files, and save as package (save as DTS in...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 25, 2007 at 8:46 am
The Excel column format is ignored, changing it makes no difference. Exporting to CSV may not be appropriate either.
If you want a quick and dirty fix for this, try putting...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 25, 2007 at 7:49 am
The Excel column format is ignored, changing it makes no difference. Exporting to CSV may not be appropriate either.
If you want a quick and dirty fix for this, try putting...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 25, 2007 at 6:00 am
Dunno about Superman but this stuff sure as hell looks like Kryptonite to me...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 22, 2007 at 2:19 am
<<InvernessShire>> an area of outstanding natural beauty and flourishing wildlife. I grew up 30 miles to the East, Findhorn, and we spent summers almost self-sufficient near Ullapool.
I've seen your...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 21, 2007 at 6:45 am
Perhaps that's where the Scottish author Iain Banks drew his inspiration for "The Wasp Factory"!
Earlier this year the BBC ran a short series on the red deer rut on the...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 21, 2007 at 3:26 am
<<I was relating to Tony the fact that these sheep, marooned for a thousand years on a tiny island in the Atlantic, five miles off the coast of Scotland, have...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 21, 2007 at 2:48 am
Viewing 15 posts - 10,111 through 10,125 (of 10,143 total)