Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,086 through 23,100 (of 59,099 total)

RE: How to find number of columns returned from query in powershell

@Chand00,
Two way street here... why do you want to do this in PowerShell? What is the purpose, please?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 7:24 pm

#1732567
RE: Are the posted questions getting worse?

Heh... isn't "reconciliation" how they found out that some BitCoin bank had been seriously whacked because the current balance wasn't immediately calculated to the penny? 😉
I'm with those that insist...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 6:20 pm

#1732562
RE: Do you usually go to agencies?

I've carefully hand-picked a couple of agencies and have found them to be incredibly useful especially since they're usually the first to know about new and appropriate jobs. The...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 1:55 pm

#1732525
RE: Need Help parsing through the XML

Evil Kraig F (7/25/2014)
Glad I asked for clarification. 🙂
Me to. And fully agreed on the cross server use of table variables. It could really cut down on the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 12:53 pm

#1732504
RE: Are the posted questions getting worse?

Sean Lange (7/25/2014)
WOW!!! If you have ever wondered about the quality of responses at SO just checkout this response to a question about when it is appropriate to use NOLOCK.
Most...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 12:45 pm

#1732501
RE: I am Confused about SQL Server performance

Of course, there's always the old but effective thought of not putting anything in your mouth until you look at it and smell it first. 😉
Rollbacks are incredibly expensive especially...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 12:42 pm

#1732499
RE: Policy Based Management - Enabling Transaction Logs

swoozie (7/25/2014)
I am trying to find or write a script that is run to enable the transaction log.
Please explain what you mean above. Transaction logs are not "enabled".
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 12:27 pm

#1732495
RE: How to find number of columns returned from query in powershell

Eirikur Eiriksson (7/25/2014)
Jeff Moden (7/25/2014)
Chand00 (7/25/2014)
Hi,
Thank you. Below one worked for me.
$QueryResults[0].Table.Columns.Count
Apologies. I tried to post but I was unable to post somehow. Once again Thankyou
Still, why does this need...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 12:24 pm

#1732494
RE: When you convert int to varchar it returns *. Why?

John Mihalko (7/25/2014)
Why does SELECT CONVERT(varchar(4),263000) or SELECT CAST( 263000 AS varchar(4)) return * ?
You would think '3000' to be return. :unsure:
Because SQL Server does not automatically do truncation on...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 12:21 pm

#1732492
RE: Automatically syncing database to different server

Possibly transactional replication.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 12:15 pm

#1732487
RE: SQL Pivot?

ken.stoner (7/25/2014)
The cross tab works exactly the way I want it too!
Thank you for all your help!
Until you get a 5th row. 😉 Then, you'd need to convert to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 12:05 pm

#1732481
RE: How to find number of columns returned from query in powershell

Chand00 (7/25/2014)
Hi,
Thank you. Below one worked for me.
$QueryResults[0].Table.Columns.Count
Apologies. I tried to post but I was unable to post somehow. Once again Thankyou
Still, why does this need to be done from...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 11:45 am

#1732475
RE: How to find number of columns returned from query in powershell

Chand00 (7/25/2014)
I want to find out number of columns returned from a query in a powershell script.
As we will be passing a dynamic query which can retrieve only 2 columns...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 11:16 am

#1732470
RE: Cross Join Help

dwilliscp (7/25/2014)
I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within "Company, Plant, Resource"...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 11:12 am

#1732469
RE: Get next 2 weeks

sharonsql2013 (7/25/2014)
True, I cannot change the table .
Name is the name of the person , Project is the projectname and all the weeks represent the hours worked on the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 25, 2014 at 11:01 am

#1732465

Viewing 15 posts - 23,086 through 23,100 (of 59,099 total)