Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,331 through 21,345 (of 59,098 total)

RE: Calulate WeekBegin Date and End Date based on Current Friday Date Dynamically

suresh0534 (3/9/2015)
Hi,
I need to run this Job On every week on Friday.
If i run the Job On Middle of Feb on Friday, it needs to calculate From Jan-Feb of 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)

March 9, 2015 at 4:52 pm

#1782732
RE: Calulate WeekBegin Date and End Date based on Current Friday Date Dynamically

I got that the first time around. You're not reading my questions that I previously posted. You want the output to identify which week of each month 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)

March 9, 2015 at 4:18 pm

#1782727
RE: can anyone provide me real time scenarios where you build stored procedures, triggers, cursors?

steve000 (3/9/2015)
Do you have a sample you would be willing to share? (Stored proc working with csv?) I do SSIS CSV imports all the time!! I didn't know i could...
--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)

March 9, 2015 at 4:14 pm

#1782726
RE: Calulate WeekBegin Date and End Date based on Current Friday Date Dynamically

suresh0534 (3/9/2015)
Hi,
Thanks for your reply.
We need to run Friday at the End of the Day.
Thanks,
That's good. Would you please answer the other questions I had? Thanks.
--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)

March 9, 2015 at 12:20 pm

#1782672
RE: managing lookup / reference data

It would be better to put all virtually static lookup tables in their own file/filegroup and only backup that filegroup or do index maintenance when something changed.
As far as putting...
--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)

March 9, 2015 at 12:14 pm

#1782667
RE: How to write Conditional Where Clause

For all those that have posted solutions, you seriously need to read Gail's "Catch All Query" article. Please refer to her first post on this thread.
--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)

March 9, 2015 at 12:07 pm

#1782664
RE: Calulate WeekBegin Date and End Date based on Current Friday Date Dynamically

Weeks only start the same time a month starts one out of 7 times over a long period.
With that in mind, the first thing we need to know is 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)

March 9, 2015 at 12:00 pm

#1782661
RE: Avoiding loop so want to use CTE

Guras (3/9/2015)
I have the following table where I store the QuerystringTBL
QueryString, MatchId
-----------------------------
CodeValue between 1 and 100
DateValue >= '01/01/2015' ...
--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)

March 9, 2015 at 11:51 am

#1782657
RE: Managing Log Files Sizes the Easy Way

While I have an appreciation for a limited budget, it is much more expensive to have to come up with these types of workarounds than it is to buy more...
--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)

March 9, 2015 at 11:42 am

#1782651
RE: EXCEL HELL!!!

TomThomson (3/8/2015)
Jeff Moden (3/2/2015)
sqldriver (3/2/2015)
This is a great day! I get to tell people I'm as good at something in SQL as Jeff Moden, even if it is SSIS. 😀
😀
I'll...
--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)

March 9, 2015 at 8:03 am

#1782529
RE: Mortgage amortization table

Sergiy (3/7/2015)
Jeff Moden (7/5/2011)
If you notice, the final entry didn't really get as close to zero as bankers and little ol' ladies with umbrellas would like. 😛
Man, expand 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)

March 8, 2015 at 2:29 pm

#1782396
RE: EXCEL HELL!!!

xsevensinzx (3/7/2015)
Good stuff here on the suggestions. Here is an odd one from me that I didn't try, but I think it would work similar to Eirikurs.
Create a data flow...
--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)

March 8, 2015 at 2:16 pm

#1782395
RE: Memory error

SQLEnthusiastic (3/7/2015)
Did you try reducing the max server memory on the SQL Server intance, leaving more memory to the OS?
This solved in one of my instances.
Good tip. I hope...
--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)

March 7, 2015 at 8:38 pm

#1782376
RE: How to Fill-In A Single Cell in an Excel Spreadsheet Via SSIS?

brad.mccollum (3/7/2015)
Update here:
This might be a good article... just found it, but I'm still appreciative of anything else someone might be able to push along info-wise if you've accomplished 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)

March 7, 2015 at 8:32 pm

#1782375
RE: Fifty Words for Databases

What??? You don't know how to get to the moon, Phil???? It's simple! All you have to do is build a rocket ship! 😛
Absolutely great editorial, ol' friend....
--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)

March 7, 2015 at 8:03 pm

#1782374

Viewing 15 posts - 21,331 through 21,345 (of 59,098 total)