Viewing 15 posts - 19,801 through 19,815 (of 59,072 total)
I guess my question would be... why on Earth are you doing this in PowerShell?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 5:31 pm
mufadalhaiderster (8/20/2015)
It would be a good practice for some of you experts.
Heh... actually, it would be good practice for YOU! 😉 Download Grant Frichey's free book on execution plans...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 5:26 pm
Iwas Bornready (8/20/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 1:02 pm
dandenise316 (8/20/2015)
I'm interested in finding out what the average responses / applications, etc are based upon the mailer volume and mailer type fields....
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 10:52 am
Ben Whyall (8/20/2015)
I'm not sure this is the best forum but i'm hoping its the best fit.
I am a developer mostly working on .net applications with a SQL...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 10:40 am
crickwilli (8/20/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 8:37 am
Jeff ingham (3/12/2014)
...hopefully this might save someone from premature hair loss!
Apparently, it DID! Well done!
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 8:27 am
ByronOne (8/20/2015)
Cheers ChrisI'll give this a whirl.
Thanks for the really speedy response!
BO
The question now is, do you understand how and why it works?
I ask because Chris' fine...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 8:07 am
Eirikur's CROSSTAB solution is an effective solution for when the maximum number of items is 3 and can be easily converted for larger known maximums. It's also easily converted...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 8:04 am
Jayanth_Kurup (8/20/2015)
@jeff Looks like a perfect example on using dynamixc SQL 🙂
Nah. Not for this. It's a simple CROSSTAB or PIVOT problem, especially since it's known that there...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 8:01 am
vikramchander90 (8/20/2015)
I have a table which has few columns as Numeric value. I need to export the ouptut into a csv file as a report with column headers. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 7:41 am
Really, really looks like and sounds like homework. Even if it's not, you should at least try. And rules 4, 5, and 6 create an oxymoron because to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 20, 2015 at 12:14 am
One of my previous bosses said that "If you don't make mistakes, I'm not pushing you hard enough".
While I agree with that, the place to experiment and make mistakes is...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2015 at 11:59 pm
Kevlarmpowered (8/19/2015)
My DBAs frown on dynamic SQL...
They REALLY need to get over that. Properly written dynamic SQL is SQL Injection proof, safe, fast, and will cache an execution...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2015 at 11:52 pm
hurricaneDBA (8/19/2015)
I am setting up a database for one contractor who needs to access one of our databases but i need to remove the permission for them to view...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 19, 2015 at 11:51 pm
Viewing 15 posts - 19,801 through 19,815 (of 59,072 total)