Viewing 15 posts - 26,701 through 26,715 (of 59,102 total)
Luis Cazares (6/6/2013)
Sean Lange (6/6/2013)
Here is another:
select stuff(isnull(col1 + '/', '') + isnull(col2 + '/', ''), LEN(isnull(col1 + '/', '') + isnull(col2 + '/', '')), 1, '')
from Table_1
Sean, you gave...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2013 at 9:53 pm
Deque (6/6/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2013 at 9:46 pm
I don't work for a huge company and we don't have Tera-byte sized databases but we have multiple mission critical 120GB databases and an awesome NetOps group. Instead of...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2013 at 9:33 pm
sporoy (1/9/2012)
Perry Whittle (1/6/2012)
granting permissions on the xp worked for me, i suspect the account trying to grant has insufficient permissions
In my case when I make the executing user sysadmin,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2013 at 8:40 pm
rlouch (6/6/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2013 at 8:34 pm
Michael Meierruth (6/6/2013)
PSJeff, how long did it take you to unformat that sample code? Is there a tool to do that? 😀
If you're talking about the single line code example...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2013 at 5:57 pm
Dird (6/6/2013)
Jeff Moden (6/6/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2013 at 4:52 pm
Heh... FizzBuzz... my old friend during interviews. I don't ask about FizzBuzz on phone interviews. I do use it as one of the questions on the pre-interview written...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 6, 2013 at 8:49 am
Dird (6/5/2013)
Luis Cazares (6/5/2013)
The "Numbers" or "Tally" Table: What it is and how it replaces a loop.
The problem with that is you'd have to create the table separately, when you...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2013 at 4:53 pm
rphilips (6/5/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2013 at 4:10 pm
pchirags (6/5/2013)
Great article, Jeff..Awesomely presented and well explained article about presenting and putting your question in correct way.
Thanks Jeff.
Thank you very much for the feedback. I appreciate it.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2013 at 4:08 pm
Sigerson (6/5/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2013 at 3:41 pm
MWise (6/5/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2013 at 2:15 pm
David.Lester (6/5/2013)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2013 at 1:19 pm
aochss (6/5/2013)
Good points everyone on the perils and pitfalls of getting a well formed question.
I would like to also add that when answering the questions that the...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2013 at 1:16 pm
Viewing 15 posts - 26,701 through 26,715 (of 59,102 total)