Viewing 15 posts - 1,036 through 1,050 (of 3,544 total)
Now all that needs to be done is just include the condition that the above scenario will apply only if the ship reaches the port(PORT_CD) 'BEZEE' first.
How do you determine...
Far away is close at hand in the images of elsewhere.
Anon.
August 4, 2011 at 10:12 am
steveb. (7/26/2011)
preynolds 73137 (7/26/2011)
SQL noob here, but would ABS work?ABS would work for the opposite, (negative to positive)
Except if you combine both
-ABS(value)
would always give you a negative result...
Far away is close at hand in the images of elsewhere.
Anon.
July 26, 2011 at 8:26 am
The problem you will have with FTS is that it will ignore the braces and end up with a word list of
Bill
Esquire
Smith
Smitty
Will
William
Willy
so you could end up with incorrect output...
Far away is close at hand in the images of elsewhere.
Anon.
July 26, 2011 at 8:14 am
Grant Fritchey (7/26/2011)
Yeah, luckily I'm behind on preparing my morning coffee...
After meeting you, don't know why but it conjures up an image of you in a pinny...
whoa! too much information...
Far away is close at hand in the images of elsewhere.
Anon.
July 26, 2011 at 6:55 am
Tom.Thomson (7/25/2011)
...Why do the correct ones get corrected?
Meh! Moderator's perogative 😉
Far away is close at hand in the images of elsewhere.
Anon.
July 26, 2011 at 6:50 am
On 2008R2 Dev Edition it produces NULL even when following the actionss in the question and yes I had to restart SQL server when changing security.
Whilst this does not detract...
Far away is close at hand in the images of elsewhere.
Anon.
July 22, 2011 at 6:48 am
Jeff Moden (7/21/2011)[hrGood idea but the dual 11,000 row Tally Table has 30 years of "capability"... doing it directly as you have limits the functionality to 299.16666666667 days. 🙂 ...
Far away is close at hand in the images of elsewhere.
Anon.
July 21, 2011 at 4:12 pm
How about a simpler approach
SELECT DATEADD(minute, (t.N - 1) * 30, @DateStart)
FROM dbo.Tally t
WHERE t.N BETWEEN 1 AND (DATEDIFF(day, @DateStart, @DateEnd) + 1) * 48
ORDER BY t.N...
Far away is close at hand in the images of elsewhere.
Anon.
July 21, 2011 at 2:09 am
Jeff Moden (7/20/2011)
IIRC, he's a moderator over on the "SQL Server Performance" site, isn't he?
Yes he is.
Far away is close at hand in the images of elsewhere.
Anon.
July 20, 2011 at 8:50 am
Lynn Pettis (7/19/2011)
Far away is close at hand in the images of elsewhere.
Anon.
July 20, 2011 at 2:13 am
Jeff Moden (7/19/2011)
Far away is close at hand in the images of elsewhere.
Anon.
July 20, 2011 at 2:13 am
Jeff Moden (7/19/2011)
Far away is close at hand in the images of elsewhere.
Anon.
July 19, 2011 at 11:07 am
Also check that you are using my latest query (repeated below)
Also check the WHERE clause as this could drop lines giving a false impression that the query is not working
SELECT...
Far away is close at hand in the images of elsewhere.
Anon.
July 12, 2011 at 2:54 am
ringovski (7/12/2011)
I have uploaded a spreadsheet that shows the difference. Invoice ID 135393 only has one...
Far away is close at hand in the images of elsewhere.
Anon.
July 12, 2011 at 2:50 am
ringovski (7/10/2011)
Msg 4145, Level 15, State 1, Line 22
An expression of non-boolean type specified in a context where a condition is...
Far away is close at hand in the images of elsewhere.
Anon.
July 11, 2011 at 2:18 am
Viewing 15 posts - 1,036 through 1,050 (of 3,544 total)