Viewing 15 posts - 331 through 345 (of 3,666 total)
BWFC (9/8/2015)
SELECT
ltrim(right(postalcode,charindex(' ',reverse(postalcode),PATINDEX('% %',reverse(postalcode))+1)))
FROM yourdata
I've tested this over 14500 county+[space]+postcode combinations and the only ones it didn't work on were cases where there was no space in...
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]
September 8, 2015 at 8:16 am
Koen Verbeeck (9/8/2015)
jasona.work (9/8/2015)
Although, I'd probably get blacklisted for having a rather large profile, Explorer reports it as around 25GB or so (I tend to not purge docs very often...)
It's...
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]
September 8, 2015 at 8:03 am
Pack_Star (9/8/2015)
I believe that this could be possibly be resolved with a Case Statement?
The select needs to do the following. If there are three separate strings 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]
September 8, 2015 at 7:59 am
SQLRNNR (9/4/2015)
Alvin Ramard (9/4/2015)
SQLRNNR (9/4/2015)
Alvin Ramard (9/4/2015)
Sean Lange (9/4/2015)
Alvin Ramard (9/4/2015)
Brandie Tarvin (9/4/2015)
One business unit wants to know...
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]
September 4, 2015 at 9:05 am
SQLRNNR (9/4/2015)
Alvin Ramard (9/4/2015)
Sean Lange (9/4/2015)
Alvin Ramard (9/4/2015)
Brandie Tarvin (9/4/2015)
One business unit wants to know why production report...
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]
September 4, 2015 at 8:18 am
Sean Lange (9/4/2015)
Alvin Ramard (9/4/2015)
Brandie Tarvin (9/4/2015)
One business unit wants to know why production report X was timing...
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]
September 4, 2015 at 8:09 am
Jeff Moden (9/3/2015)
sriponraj (9/3/2015)
Check the connection for temp db by using sp_who2 active. Kill all the connection related to temp db and try to shrink..
So, if the run you kill...
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]
September 4, 2015 at 8:03 am
Brandie Tarvin (9/4/2015)
One business unit wants to know why production report X was timing out, so I went...
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]
September 4, 2015 at 7:59 am
Ed Wagner (9/3/2015)
Grant Fritchey (9/3/2015)
Alvin Ramard (9/3/2015)
Jeff Moden (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/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]
September 3, 2015 at 12:35 pm
Jeff Moden (9/3/2015)
Alvin Ramard (9/3/2015)
Grant Fritchey (9/3/2015)
Nope. Just faked out the entire...
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]
September 3, 2015 at 11:37 am
Grant Fritchey (9/3/2015)
Nope. Just faked out the entire MSDN web site to...
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]
September 3, 2015 at 11:30 am
If I weren't planning on 2 weeks vacation real soon, I'd be off tomorrow.
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]
September 3, 2015 at 10:18 am
Eric M Russell (9/3/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]
September 3, 2015 at 8:40 am
jasona.work (9/3/2015)
Just make sure you read "The Thread" from beginning to end...There will be a quiz.
:hehe:
Memorizing all the parameters of DBCC TimeWarp is something I would recommend not be skipped....
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]
September 3, 2015 at 8:32 am
ChrisM@Work (9/3/2015)
John Mitchell-245523 (9/3/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]
September 3, 2015 at 8:25 am
Viewing 15 posts - 331 through 345 (of 3,666 total)