Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,021 through 19,035 (of 59,098 total)

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
RE: how to speed up sp_testlinkedserver

It's not sp_testlinkedserver that's slow. It's the connection that is slow. That could be anything between the server where the linked server has been created to the target...
--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:26 am

#1845021
RE: How to catch actual parameter value passed into a stored procedure?

SQL Guy 1 (12/8/2015)
I am running server-side trace to catch a certain stored procedure and its parameter values. I am tracing event SP:Completed with a filter for ObjectName column.
In...
--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:19 am

#1845019
RE: Rethinking Hiring

Rod at work (12/9/2015)
I can't remember what the function was I was asked to write and then test, but it was something like writing a function that would approximate 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)

December 9, 2015 at 10:31 am

#1844996
RE: Rethinking Hiring

Steve Jones - SSC Editor (12/2/2015)
Rod at work (12/2/2015)
Oh Steve, man have you said a lot here that I'd like to respond to. But I think prudence forebears me 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)

December 9, 2015 at 9:31 am

#1844969

Viewing 15 posts - 19,021 through 19,035 (of 59,098 total)