Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,751 through 18,765 (of 59,072 total)

RE: Is BCP queryout limited?

dwilliscp (12/30/2015)
Jeff Moden (12/29/2015)
dwilliscp (12/29/2015)
I would love to post the code.. but it is my vendor's code... sorry.
Actually, that explains a lot.
So who's code is it that's in your first...
--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)

December 30, 2015 at 8:10 am

#1848763
RE: Create temporary table from output of dynamic SQL

sandesh_krishnan (12/30/2015)
Hi,
Is there an option to create a temporary table based on the output of dynamic SQL?
Example : 'Select * Into #TEMP_TABLE FROM '+ DYNAMIC_SQL
I have tried option of...
--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)

December 30, 2015 at 7:57 am

#1848754
RE: Covert columns to rows

kaza.rohan (12/30/2015)
Can we write dynamically for sys.databases , is there any possibility ?
But for other tables it is possible by using sys.columns and then we can unpivot it.
but sys.databases is...
--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)

December 30, 2015 at 7:52 am

#1848751
RE: how does datatypes get set when using select into in sql server?

dndaughtery (12/30/2015)
There aren't any mathematical calculations but there are several Case statements. I'd post the query but its a monster
CASE [font="Arial Black"]IS [/font]a type of calculation. You may have...
--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)

December 30, 2015 at 7:47 am

#1848750
RE: Help with a query, plz

SQLisAwE5OmE (12/29/2015)
Jeff, See the attachment for the create view script. Thanks.
Thanks for that. That view is a bit of a "Rosetta Stone" for what the table relationships are.
I...
--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)

December 29, 2015 at 9:46 pm

#1848677
RE: CLR Yes or no?

Eric M Russell (12/26/2015)
Well, im still not sure about RegEx in a data warehouse. Parsing text columns suggests things like product descriptions were not identified by category in a way...
--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)

December 29, 2015 at 8:50 pm

#1848674
RE: query for datetime

drew.allen (12/29/2015)
Jeff Moden (12/29/2015)
drew.allen (12/29/2015)
None of the newer date/time data types support decimal math.
I consider that to be a major failure on the part of Microsoft. I'll never understand...
--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)

December 29, 2015 at 8:40 pm

#1848673
RE: Is BCP queryout limited?

dwilliscp (12/29/2015)
I would love to post the code.. but it is my vendor's code... sorry.
Actually, that explains a lot.
So who's code is it that's in your first post on this...
--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)

December 29, 2015 at 7:02 pm

#1848667
RE: Help with a query, plz

SQLisAwE5OmE (12/29/2015)
Thnx again Jeff for trying. I am learning.
No problem. Looking back at this, I see that it's not actually a table. It's a view. What...
--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)

December 29, 2015 at 6:54 pm

#1848666
RE: Help with a query, plz

Jeff Moden (12/29/2015)
~~I'm thinking that all you need to do is change the AND to an OR in Alan's WHERE clause~~.
Never mind and apologies. I was in a hurry...
--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)

December 29, 2015 at 6:41 pm

#1848664
RE: Help with a query, plz

I'm thinking that all you need to do is change the AND to an OR in Alan's WHERE clause.
--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)

December 29, 2015 at 2:48 pm

#1848639
RE: Nvarchar Max no of character size

Jacob Wilkins (12/29/2015)
Seems to be a bug/issue in SSMS. It was reported (https://connect.microsoft.com/SQLServer/feedback/details/499608/ssms-can-not-paste-more-than-43679-characters-from-a-column-in-grid-mode), and closed as not reproducible.
Precisely why I don't even bother with CONNECT except to see what they...
--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)

December 29, 2015 at 2:29 pm

#1848636
RE: SQL express vs developer for MCSE:BI

Jeff Moden (12/28/2015)
Don't limit your educational endeavors. Get the Developers Edition. It's usually less than $65USD somewhere. You'd pay almost that much for a good book.
I've found...
--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)

December 29, 2015 at 2:11 pm

#1848630
RE: query for datetime

drew.allen (12/29/2015)
None of the newer date/time data types support decimal math.
I consider that to be a major failure on the part of Microsoft. I'll never understand why "improvements" are...
--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)

December 29, 2015 at 12:53 pm

#1848607
RE: Are the posted questions getting worse?

I agree except that Detroit city is slowly but surely making a comeback. Some of the surrounding burbs are really tough but that's true of any city.
Personally, I don't...
--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)

December 29, 2015 at 12:31 pm

#1848603

Viewing 15 posts - 18,751 through 18,765 (of 59,072 total)