Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,371 through 23,385 (of 59,099 total)

RE: Optimize SQL

J Livingston SQL (6/21/2014)
Jeff Moden (6/21/2014)
a.guillaume (6/19/2014)
ARNAUD is working the 06/19/2014
He can't work on
00-8:00
12:00 p.m. to 1:00 p.m.
...
--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)

June 21, 2014 at 3:54 pm

#1723812
RE: no. of columns in excel may vary

ykonline (6/20/2014)
Hi,
I want to insert data periodically from an excel file into a table using a SSIS. But each time the no. of columns in excel may vary.
Suppose, 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)

June 21, 2014 at 3:50 pm

#1723811
RE: Help need for Select Query Remove Empty Cells

Explain why the two with blanks in the expected output are allowed but the first 3 of 5 with the blanks in the original results are not.
Also (and there's no...
--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)

June 21, 2014 at 3:42 pm

#1723810
RE: Optimize SQL

a.guillaume (6/19/2014)
ARNAUD is working the 06/19/2014
He can't work on
00-8:00
12:00 p.m. to 1:00 p.m.
10:00 p.m. to 0:00
...
--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)

June 21, 2014 at 2:35 pm

#1723808
RE: How best update lots of actively used R/O data?

Lynn Pettis (6/21/2014)
I've used synonyms before as well, should have thought of it myself. But, it was a good exercise in learning to swap partitions since I hadn't done...
--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)

June 21, 2014 at 2:02 pm

#1723806
RE: How best update lots of actively used R/O data?

dave 67553 (6/21/2014)
I had not heard about DB synonyms before which seem a great feature for this problem. I guess you keep the state as to which table is current...
--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)

June 21, 2014 at 1:56 pm

#1723805
RE: What color is SQL Server?

"It Depends". I think of it (and virtually any programmable product) as more like a mirror and it's color is dependent on the imagination of the person standing 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)

June 21, 2014 at 12:24 pm

#1723799
RE: Counting the characters in a string before a space

Appreciate that but don't do it on my account. I'm thinking that the OP should have such a thing. If not, then we know the real problem.
--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)

June 21, 2014 at 12:12 pm

#1723798
RE: How best update lots of actively used R/O data?

We do such a thing on a regular basis except we keep it even simpler.
Two tables almost identically named. For example, SomeTable1 and SomeTable2.
We also have a synonym called...
--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)

June 20, 2014 at 11:02 pm

#1723744
RE: OpenRowSet query Error

You need to remove the parenthesis from (server\instance) in the following example...
select * from openrowset('SQLNCLI','Server=(server\Instance);Trusted_Connection=yes;','exec dbo.sp_who') AS a
Of course, you also need to sub the correct names for server\instance.
--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)

June 20, 2014 at 10:25 pm

#1723743
RE: Help for Preparing date schedule.

I believe this will do it but you should test a broader range of dates to make sure it works. Look for "Rev 01" to see the changes 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)

June 20, 2014 at 9:49 pm

#1723741
RE: Help for Preparing date schedule.

Ah... looking back at the requirements, I get it now. The last two examples are based on the end of the month and that's what you're trying to return...
--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)

June 20, 2014 at 8:24 pm

#1723736
RE: Help for Preparing date schedule.

kbhanu15 (6/20/2014)
please provide same Temp table and sample data.
clear give the exactly your expected values.
Your heart is definitely in the right place but look back at the problem... The OP...
--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)

June 20, 2014 at 8:13 pm

#1723734
RE: Help for Preparing date schedule.

panneermca35 (6/20/2014)
Hi,
I need the script for the following schedule.
if the repayment start date = 05-01-2016 and installment=5 then result will be
05-01-2016
05-02-2016
05-03-2016
05-04-2016
05-05-2016
if the repayment start...
--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)

June 20, 2014 at 8:07 pm

#1723733
RE: Rebuild Indexes not working

zedtec (6/20/2014)
It used to until recently but not any more.
Ok. So when did you take that out and have you checked other jobs to make sure that none 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)

June 20, 2014 at 9:58 am

#1723649

Viewing 15 posts - 23,371 through 23,385 (of 59,099 total)