Viewing 15 posts - 766 through 780 (of 3,666 total)
Greg Edwards-268690 (6/2/2015)
Eirikur Eiriksson (6/1/2015)
Jeff Moden (6/1/2015)
Maybe it's just me. I might be getting too old for this business. I don't understand why people make such ridiculous posts.
That...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 2, 2015 at 7:25 am
oops, quoted wrong post. Let me try again.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 2, 2015 at 7:23 am
You could start here: http://lmgtfy.com/?q=microsoft+sql2016
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 2, 2015 at 7:17 am
Eirikur Eiriksson (5/29/2015)
Sometimes I do wonder where things went wrong with MS and SQL documentation/references/best...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 29, 2015 at 3:31 pm
How about:
DECLARE @SomeString VARCHAR(50)
SET @SomeString = '132.135.3.100, fe90::bu54:e9z5:61a9:5003'
SELECT LEFT(@SomeString, CHARINDEX(',', @SomeString)-1) AS 127.0.0.1
, SUBSTRING(@SomeString, CHARINDEX(',', @SomeString) + 2, 25) AS [MAC]
SET @SomeString = '132.235.219.113, fe80::28d9:l69a:5bbd:gr2f'
SELECT LEFT(@SomeString, CHARINDEX(',',...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 29, 2015 at 12:13 pm
Lynn Pettis (5/29/2015)
TJT (5/29/2015)
Correct, the IP Address is always first and ends with a comma
select left(@TestStr,patindex('%,%',@TestStr) - 1);
I can't post the declare of the @TestStr with the ip and mac...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 29, 2015 at 12:01 pm
Alan.B (5/29/2015)
Luis Cazares (5/29/2015)
I'm not sure if you've seen this, but it made me laugh and wanted to share it with you.http://geekandpoke.typepad.com/geekandpoke/2011/01/nosql.html
Haha. Would be even funnier if it weren't so...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 29, 2015 at 10:41 am
Ed Wagner (5/27/2015)
GilaMonster (5/27/2015)
SQLRNNR (5/27/2015)
GilaMonster (5/27/2015)
Looks like I hit a few nerves with Sunday's editorial....Two words...
Ugh
Troll
I'd reply and point out the flaw in his logic (he's got scientific method and...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 28, 2015 at 12:09 pm
Also look at the data connections in your package. They should be using Windows authentication, not SQL.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 28, 2015 at 12:04 pm
Dimbulbz (5/27/2015)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 27, 2015 at 8:36 am
I would seriously consider warning those contractors that you're getting ready to execute sp_drop_contractor. :w00t:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 27, 2015 at 7:44 am
Alvin Ramard (5/26/2015)
Did you try your original query with '5/15/2015 23:59:59' Instead of '5/15/2015 11:59:59'?
FYI, I only asked this question to show the OP why the missing record was excluded,...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 26, 2015 at 1:13 pm
JoshDBGuy (5/26/2015)
Alvin Ramard (5/26/2015)
Next time, before processing, check the status of the cubes and when they were last processed. That may shed some light on your problem.
Did that, there...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 26, 2015 at 12:05 pm
Next time, before processing, check the status of the cubes and when they were last processed. That may shed some light on your problem.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 26, 2015 at 11:33 am
Jeff Moden (5/26/2015)
itortu (5/26/2015)
I changed my original query to use 23:59:59, and that also gave me the missing record back.
You're just asking for a world of hurt in the...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 26, 2015 at 11:24 am
Viewing 15 posts - 766 through 780 (of 3,666 total)