Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,356 through 23,370 (of 59,099 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Paul White (5/15/2014)
Jeff Moden (5/15/2014)
I'd not seen that happen in my testing but know that such a thing could happen. Thanks for the heads up and the patch. ...
--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 25, 2014 at 10:50 pm

#1724905
RE: How to Make Scalar UDFs Run Faster (SQL Spackle)

dwain.c (6/25/2014)
Even though I haven't had much time of late to devote to SQL stuff, I did find time to go back and re-read this article.
Excellent new information...
--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 25, 2014 at 9:30 pm

#1724901
RE: Running total error

pwalter83 (6/25/2014)
Lynn Pettis (6/25/2014)
EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.
I found the problem, try the following:
IF...
--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 25, 2014 at 12:04 pm

#1724745
RE: Running total error

pwalter83 (6/24/2014)
ChrisM@Work (6/24/2014)
Here's a quick rejig of that sample data, and a reformat of the code. Is it only the running total column which is incorrect?
IF OBJECT_ID ('tempdb..#GLT') IS NOT...
--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 24, 2014 at 8:32 am

#1724357
RE: How to Make Scalar UDFs Run Faster (SQL Spackle)

Great question! I've never tried it, Stefan. I'm not even going to hazard a guess on that but I'll give it a try tonight after work.
--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 24, 2014 at 8:07 am

#1724342
RE: Apology for today's article

This is another reason why I call SQLServerCentral.com "home". There's a lot of honor in the good folks that run this site.
There are some sites (some that are even...
--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 23, 2014 at 9:24 am

#1724121
RE: Running total in sql and additional issue

pwalter83 (6/23/2014)
No further posts to this thread, please see the new link:
http://www.sqlservercentral.com/Forums/Topic1584256-391-4.aspx
Actually, it's the original thread for this problem and, I agree... let's get back to the original 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)

June 23, 2014 at 8:20 am

#1724095
RE: Running total error

pwalter83 (6/23/2014)
ChrisM@Work (6/23/2014)
pwalter83 (6/23/2014)
ChrisM@Work (6/23/2014)
Paul, you have two threads open which cover the same problem. Can I suggest you choose one of them and close the other? You can do...
--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 23, 2014 at 8:18 am

#1724093
RE: Just curious, what are your SQL pet peeves ?

Koen Verbeeck (6/23/2014)
When importing data from an untyped source - a flat file for example - I usually import everything as strings into the staging table. Because you don't know...
--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 23, 2014 at 2:32 am

#1723925
RE: How to imbed an image into an email sent by dbmail

Thanks, Magoo... That's pretty close to what I would have ended up doing had someone not posted the solution but, my word, I don't believe there are a whole lot...
--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 23, 2014 at 2:26 am

#1723922
RE: Optimizing ORDER BY query

arijit rath (6/23/2014)
Actually it is not a sp but a inline query with order by in the OLEDB source. The query is using 3 views in the join condition which...
--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 23, 2014 at 1:59 am

#1723911
RE: Running total in sql and additional issue

This is going to be terribly slow and resource intensive because it contains a "Triangular Join". Please see the following article on the subject. Even a cursor and...
--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 23, 2014 at 1:53 am

#1723910
RE: How to imbed an image into an email sent by dbmail

Excellent, Sachin! Thanks for the great info!
How in the world a newbie would make the connection in his/her mind that you need to find and embed a MIME attribute...
--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 22, 2014 at 2:48 pm

#1723868
RE: How to imbed an image into an email sent by dbmail

Sachin Nandanwar (6/22/2014)
Having good background with C# maybe I will try to clear that.
Cid is called ContentIdentifier.So when an image needs to be referenced in a mail basically it can...
--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 22, 2014 at 11:08 am

#1723857
RE: How to imbed an image into an email sent by dbmail

Lowell (6/23/2010)
the secret is to use cid:attachedimage.gif for the source file.
here's a setup and working example:
I'm attaching the results of a query, and i copied the SQl server logo 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)

June 22, 2014 at 9:24 am

#1723848

Viewing 15 posts - 23,356 through 23,370 (of 59,099 total)