Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,931 through 21,945 (of 59,072 total)

RE: update/insert

marybeth1975 (1/11/2015)
I have the following:
iddue_dateupdate_datemonth
2004/14/20192/4/20142
2006/16/20204/6/20144
2008/18/20216/8/20146
3006/13/20143/3/20143
3009/19/20146/9/20146
30012/22/20149/12/20149
How do yo update the due date for each month?
iddue_dateupdate_datemonth
2004/14/20192/4/20142
2004/14/2019 3
2006/16/20204/6/20144
2006/16/2020 5
2008/18/20216/8/20146
2008/18/2021...
--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)

January 11, 2015 at 4:13 pm

#1769351
RE: How can I write a query make the selection

anu.anu4u (1/11/2015)
Thanks for the code but I didnt understand the code ... and also there is also a condition - select only salespersonId =1 (salespersonId is another field which 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)

January 11, 2015 at 12:24 pm

#1769324
RE: Is there a way to throttle or limit the amount of sql requests either by IP address or username?

ghurty (1/11/2015)
Is there a way to throttle or limit the amount of sql requests either by IP address or username?
Thank you
I have found that such throttling is to control 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)

January 11, 2015 at 12:14 pm

#1769323
RE: DTS export Excel 2003 to Excel 2007

Something else is going on there. I'm using EXCEL 2010 and the "$" still works just fine.
--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)

January 11, 2015 at 12:08 pm

#1769321
RE: How can I write a query make the selection

Then Eirikur's code will do it for you. Do you understand how it works?
--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)

January 11, 2015 at 12:02 pm

#1769320
RE: search date field by partial date?

Glad it worked out, Mick. Just to be sure, do you understand how/why it works?
--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)

January 11, 2015 at 10:07 am

#1769311
RE: "poor man's replication" ETL process design

It may be that having the clustered index on the hash would work faster on the lookups, especially if it were a unique index that was guaranteed to be unique...
--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)

January 11, 2015 at 9:41 am

#1769306
RE: How can I write a query make the selection

anu.anu4u (1/11/2015)
I have a table named activity with fields activityId,activitydate. How can I write a query to select activityId from the table between two dates in such a way that...
--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)

January 11, 2015 at 9:18 am

#1769303
RE: Scalar Function to determine last date for 4 different rule conditions - Final step - 4 Date Variables - what is latest

If you insert the results into a table variable rather than individual variables, your final act could be to select the MAX date from that table variable.
Step 2 would be...
--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)

January 11, 2015 at 9:03 am

#1769300
RE: Help me to tune this query in a better way

prabhu.st (1/11/2015)
as of now the query is taking 19 seconds to bring the result set with pagination for 300454 records.
Are you saying that (and it looks like it 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)

January 11, 2015 at 8:36 am

#1769299
RE: "poor man's replication" ETL process design

The clustered index is always added to the non-clustered index.
I have to say, you've done a remarkable job. You tried the "obvious" method and that took 50 minutes. ...
--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)

January 10, 2015 at 9:49 pm

#1769276
RE: New to SQL. Need help

The question now is, do you understand? After checking out Google on some of the things I suggested and if you're still having problems, c'mon back and post 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)

January 10, 2015 at 9:23 pm

#1769273
RE: search date field by partial date?

Assuming that a parameter called @pSomeDate is a VARCHAR parameter to take the '03/2011', the following should do it.
WITH
cteStartOfMonth AS
(
SELECT StartOfMonth = DATEADD(mm,CAST(LEFT(@pSomeDate,2) AS INT)-1,RIGHT(@pSomeDate,4))
)
SELECT yada, yada, yada
...
--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)

January 10, 2015 at 9:18 pm

#1769272
RE: Tempdb Shrink takes long time.

Siva Ramasamy (1/10/2015)
Dear SQL Experts,
Thanks for looking into my question.
I am trying to shrink a 170 GB tempdb file to 160 GB. There is more than 30 GB available 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)

January 10, 2015 at 8:58 pm

#1769271
RE: Split or not split luns in modern storage solution

Grant Fritchey (1/10/2015)
No, they can adjust the disks, but most of the time the disks are adjusted for the most money saving setting, saving disk space, not speed. However, before...
--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)

January 10, 2015 at 8:43 pm

#1769270

Viewing 15 posts - 21,931 through 21,945 (of 59,072 total)