Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,991 through 19,005 (of 59,072 total)

RE: Convert Rows into Columns

vjonnal1 (7/17/2014)
I am bit confused here, what's preventing you to use PIVOT function here?
Performance.
--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 11, 2015 at 5:30 pm

#1845591
RE: converting xlsm to xls using a script task in SSIS

NewbieCoding (12/11/2015)
I was hoping of saving the xlsm file to xlsx file using SSIS and then importing the file into a table. so all we have to do 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 11, 2015 at 2:07 pm

#1845580
RE: Convert Rows into Columns

fregatepllada (7/17/2014)
Thanks Jeff - I did CROSSTAB implementation before SQL 2005.
For my current project I stick with PIVOT (I have less than 10K rows). 😉
Heh... I love it...
--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 11, 2015 at 1:51 pm

#1845575
RE: Convert Rows into Columns

johnbrown105 56149 (12/11/2015)
zerbit (7/18/2014)
I dislike the solution proposed, it's far too complicated to reach a so easy task.
You requirement was to print 3 lots at a time per line 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 11, 2015 at 1:48 pm

#1845573
RE: Convert Rows into Columns

elghazal.med (12/11/2015)
Hello,
I already worked on this. But i used another tool which is Stata to convert both column to rows and rows to column and i used TOS to insert...
--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 11, 2015 at 1:46 pm

#1845572
RE: converting xlsm to xls using a script task in SSIS

Ah. Understood.
The only thing that you'll be able to do in SQL Server is import the data from the spreadsheet whether it's .xlsx or .xls. The macros won'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 10, 2015 at 11:57 am

#1845314
RE: High Amount of Page Level Locking Disabled

mceventphoto (12/10/2015)
Do what Jeff?
Why did you need to disable Page Level locking on the old server to begin with?
--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 10, 2015 at 11:51 am

#1845313
RE: Most efficient way of finding and storing where there are duplicate entries

mastersql (12/10/2015)
Hi
After I've found the duplicates I'm going to contact the customer to confirm if he'd still like them removing. Removing them is the easy part as I've found a...
--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 10, 2015 at 5:54 am

#1845167
RE: High Amount of Page Level Locking Disabled

mceventphoto (12/9/2015)
Page level locks are disabled on the old database.
I'm just curious... why did you need to do that? To what benefit?
--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 9, 2015 at 11:37 pm

#1845101
RE: varchrar(max)/nvarchar(max) truncated to 255 characters when imported into Access memo field

It may also be just a display problem. For example, the default display column width in SQL Server is only 255 bytes and it's a bit of a bugger...
--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 9, 2015 at 11:33 pm

#1845100
RE: Are We Engineers?

From the Article:
Engineering is defined as: the work of designing and creating large structures (such as roads and bridges) or new products or systems by using scientific methods....
--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 9, 2015 at 11:27 pm

#1845099
RE: converting xlsm to xls using a script task in SSIS

NewbieCoding (12/9/2015)
i need to import a file that has macros without additional drivers installed. If I use the existing drivers for excel i get an error stating that i dont...
--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 9, 2015 at 7:21 pm

#1845088
RE: Select a column not in Group By clause

Sean Lange (12/9/2015)
taseedorf (12/9/2015)
Sorry to be a troll, but....
It is emergency because my friend asked me...
NO...come on.
Please note....this thread is 5 years old.
Heh... I've never seen a 5 year old...
--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 9, 2015 at 6:46 pm

#1845085
RE: Most efficient way of finding and storing where there are duplicate entries

mastersql (12/9/2015)
Hi
I'm just learning about CTE and the WITH statement. I find it trickier to write at the moment but which would you say is the best solution to finding...
--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 9, 2015 at 6:19 pm

#1845084
RE: Need help with a trigger pls

DataGuy (12/9/2015)
Hi All,
We have a very narrow data table where I need to capture the date a specific value is inserted into specific column. The table is a...
--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 9, 2015 at 6:15 pm

#1845083

Viewing 15 posts - 18,991 through 19,005 (of 59,072 total)