Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,521 through 35,535 (of 59,099 total)

RE: selecting data and putting it in email @body

igngua (1/1/2011)
I appreciate all your advices and your answer.
I´ve changed the data type of the columns:
CREATE TABLE [dbo].[correosaclientes](
[cliente] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[ningreso] [int] NOT NULL,
[proyecto] [char](100) COLLATE Modern_Spanish_CI_AS...
--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 2, 2011 at 4:51 pm

#1268339
RE: How to select count(*) where count < 4

GilaMonster (12/31/2010)
Please note: 3 year old thread.
Heh... and a seriously wrong answer to boot!
--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)

December 31, 2010 at 11:54 pm

#1268213
RE: Dyanmi SQL

{edit} Didn't read down far enough and withdrew this post.
--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)

December 31, 2010 at 11:44 pm

#1268212
RE: selecting data and putting it in email @body

igngua (12/31/2010)
Hi guys!
I´ve a table with several records;
CREATE TABLE [dbo].[correosaclientes](
[cliente] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,
[ningreso] [varchar](max) COLLATE Modern_Spanish_CI_AS NOT NULL,
[proyecto] [varchar](max) COLLATE Modern_Spanish_CI_AS NULL,
[fingreso] [varchar](max) COLLATE Modern_Spanish_CI_AS NOT NULL,
[correocliente] [varchar](max) COLLATE...
--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)

December 31, 2010 at 11:39 pm

#1268211
RE: Basic: What is powershell?

Steve,
I see that you've locked a couple of the posts that you already have articles for. Any chance you could you lock the others you have articles for just...
--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)

December 31, 2010 at 5:45 pm

#1268206
RE: Returning the Top X row for each group

Dave Ballantyne (12/12/2010)
Jeff Moden (12/12/2010)
Setup SQL Profiler and you'll have it.;-)
Dave Ballantyne (12/10/2010)
See the attached image for a screen shot from profiler
😉
Yep... I definitely missed the attachment.
--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)

December 31, 2010 at 5:42 pm

#1268205
RE: Under Appreciated Features

Nakul Vachhrajani (12/31/2010)
Hello, Andy!
In the new year, I have spun off a new blog series based on the discussion that members of the community have been having in response 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)

December 31, 2010 at 5:30 pm

#1268203
RE: Remove non printable characters

telastruct (12/30/2010)
Thanks, guys. I apologize if my "actually" seemed snitty- I see how it could be taken that way after re-reading it. I guess I should have followed it up...
--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)

December 31, 2010 at 1:39 pm

#1268185
RE: Jump to 2008 or stick with 2005 (partially done)?

I've interviewed more than my fair share of both DBA's and SQL Developers with and without certs. My question would be, has MS finally made it so that 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)

December 31, 2010 at 1:20 pm

#1268182
RE: Need a suggestion for using Nolock and Readpast

Nadrek (12/29/2010)
tfifield (12/29/2010)
Nadrek,
That said, I must maintain that in certain actual business cases, absolute accuracy is not required by the business use; simplified dashboards for management is an example 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)

December 31, 2010 at 1:06 pm

#1268178
RE: Paranthesis alignment and Negative Number

Jeff Moden (12/28/2010)
ry.sqldev (12/27/2010)
I am representing negative number within parenthesis , but as I am working on reporting service, it is possible to make the exact alignment of 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)

December 31, 2010 at 1:04 pm

#1268176
RE: First time semi-complex query - its slow!!!

CELKO (12/30/2010)
EXACTLY! But would it work the same way? 🙂
Heh... neither one works correctly so I'd have to say, who cares? 😉 The other answer 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)

December 31, 2010 at 12:47 pm

#1268175
RE: Are the posted questions getting worse?

ALZDBA (12/31/2010)
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Congratulations for the 10K barrier.
Thank you for your support,...
--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)

December 31, 2010 at 12:38 pm

#1268173
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Langston Montgomery (12/29/2010)
You've outdone yourself with this one Jeff. This article is fantastic. I guess the thing for me to remember, and the reason why some call it an unreliable...
--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)

December 31, 2010 at 7:10 am

#1268099
RE: Are the posted questions getting worse?

LutzM (12/31/2010)
Jeff Moden (12/31/2010)
...
Still, I missed the article when it came out. What's the link, please?
The easiest way: HOME->Previous headlines->Top 1.
Or even easier: http://www.sqlservercentral.com/articles/T-SQL/71950/
I wish you and your family...
--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)

December 31, 2010 at 5:50 am

#1268082

Viewing 15 posts - 35,521 through 35,535 (of 59,099 total)