Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,726 through 22,740 (of 59,067 total)

RE: Week Start and End by Month

hmbtx (9/17/2014)
Jeff:
Thank you for your reply.
I just tried it again and I am not leaving out any characters.
I get the same error.
I am running it SQL Server 2008R2.
Thanks
Howard
Apologies on 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)

September 17, 2014 at 6:16 pm

#1746238
RE: sp_send_cdosysmail Vs sp_send_dbmail

OK... no answer to my question. I'll summarize just by saying that sp_Send_DBMail is support and CDOSYS is no longer supported. That, not withstanding, I almost always use...
--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)

September 17, 2014 at 3:21 pm

#1746229
RE: ERROR CREATING PROXY ACCOUNT....

Hi Jorge,
Did you ever get an answer from anywhere for this problem? If so, how did you solve it? 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)

September 17, 2014 at 3:09 pm

#1746225
RE: Are the posted questions getting worse?

Luis Cazares (9/17/2014)
Do I see some personal/professional growth in these words? I really hope so.
This Post is closed. I will research the issue.
Thanks.
Out of context, it looks more like 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)

September 17, 2014 at 12:49 pm

#1746195
RE: Week Start and End by Month

hmbtx (9/17/2014)
When I ran the following example for FUNCTION dbo.GetWeeksForMonth
--===== Return weeks in current month
SELECT WeekNo, WeekStart, WeekEnd, DaysInWeek
FROM dbo.GetWeeksForMonth(GETDATE())
I got the following error
Msg 102,...
--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)

September 17, 2014 at 12:46 pm

#1746194
RE: Daily CSV import to SQL - How ?

P Jones (9/17/2014)
...and wait until it is fully available ....
I'm curious. What are you using to determine that a file is done being written to and is ready for...
--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)

September 17, 2014 at 8:33 am

#1746087
RE: Query AD - Script Out of memory

Gary Varga (9/16/2014)
Jeff Moden (9/16/2014)
T2000 (9/11/2014)
... but the script stops after some time, "Exception of type 'System.OutOfMemoryException' was thrown".
I'm curious... what kind of system did you run this on...
--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)

September 16, 2014 at 10:59 am

#1745840
RE: Checking sequence of codes

richardmgreen1 (9/16/2014)
Thanks Matt
That looks to have done the trick.
I'll have to double-check but it looks good at first pass.
I'll second Matt's solution over splitting the data. Even if you...
--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)

September 16, 2014 at 10:55 am

#1745839
RE: Daily CSV import to SQL - How ?

G-Force (9/16/2014)
Hi Jeff
Still trying to find the dummies guide 🙂 . Is there anywhere you can point me to on how to do it in TSQL ?
Any help gratefully received.
Thanks
G
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)

September 16, 2014 at 10:53 am

#1745838
RE: compare the next row with the previous row of same table

abhas (9/16/2014)
Hi bros,
I need to compare the next row with the previous row of same table and produce nonidentical column.
for eg... say
mytable has
Row 1 => 1001 Abhas 120 150...
--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)

September 16, 2014 at 8:40 am

#1745805
RE: Reindex - does it make data contiguous, space permitting

Are you aware that SHRINKFILE is going to fragment all of your indexes by 99.5% or 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)

September 16, 2014 at 8:35 am

#1745803
RE: create column alias with concatenation.

abhas (9/16/2014)
Thanks Adi,
I am getting exactly same error.
Where i need to use (+) sign. Do you mean instead of concat function?
Thanks,
Abhas.
done by below idea:
create table #temp(name varchar(10), sale int)
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)

September 16, 2014 at 8:31 am

#1745801
RE: Checking sequence of codes

richardmgreen1 (9/15/2014)
I'm using the latest version of Jeff's splitter (as far as I know).
I wouldn't use the DelimitedSplit8K or any other splitter for this. You're just trying to find...
--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)

September 16, 2014 at 8:29 am

#1745800
RE: Query AD - Script Out of memory

T2000 (9/11/2014)
... but the script stops after some time, "Exception of type 'System.OutOfMemoryException' was thrown".
I'm curious... what kind of system did you run this on and what happened to...
--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)

September 16, 2014 at 8:22 am

#1745795
RE: Storing temporary data within a select statement

smw147 (9/15/2014)
Thanks all. The CTE and rbednarek's solution both worked.
The question now is, what did the changes do to performance and resource usage? The reason I ask 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)

September 16, 2014 at 8:10 am

#1745786

Viewing 15 posts - 22,726 through 22,740 (of 59,067 total)