Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,581 through 26,595 (of 59,099 total)

RE: Get file size

onlygoodones (6/23/2013)
Thanks a lot Jeff. Really helpful and you saved 2 days of my time ..
Thank you for the feedback. It's good to know that some of the older...
--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, 2013 at 3:24 pm

#1626624
RE: Where is Left table in Left Join ???

mario17 (6/23/2013)
ALZDBA
Hi, Alzdba
Bit hard to get your answer so it's left from the JOIN or left from "="
Mario
It would be to the "left" (before) of the word "JOIN". ...
--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, 2013 at 3:19 pm

#1626623
RE: Running Totals

I think it's crazy that someone split the date/time up like they did. If you want that same kind of output, then get rid of the first CTE 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)

June 22, 2013 at 1:51 am

#1626539
RE: Big Performance Problem with Merge Statement

David Moutray (6/21/2013)
Nothing? :w00t: I was sure that one of those brilliant SQL veterans like Gail Shaw, Jeff Moden, Grant Fritchey, Steve Jones or Adam Machanic would have...
--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, 2013 at 1:02 am

#1626537
RE: How is the job market in the NYC area?

SQLServer Guy (6/21/2013)
Hi everyone,
I am new here but not new to SQL Server, worked in a mix of DBA/Developer/Architect role until I recently got laid off.
I am planning to relocate...
--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, 2013 at 12:57 am

#1626536
RE: Retrives the subject wise highest marks list in a table

chkri.panati (6/21/2013)
SELECT StudentName,Class,MAX(Marks) AS MAX_Marks FROM Student123
GROUP BY StudentName,Class
ORDER BY Class
I'm pretty sure that's not going to work with...
--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 21, 2013 at 5:00 pm

#1626527
RE: Write PowerShell Output to SQL Server Table

MG-148046 (6/21/2013)
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is 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 21, 2013 at 3:58 pm

#1626513
RE: Write PowerShell Output to SQL Server Table

Phil Parkin (6/20/2013)
Hi Jeff
There's a free IDE for PowerShell here, in case you are coding using some bytepad editor 🙂
Thanks, Phil. Much appreciated. I'll give it a whirl.
--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 21, 2013 at 3:53 pm

#1626511
RE: Email Formatted HTML Table with T-SQL

steve.ledridge (6/21/2013)
Thank you, I have not posted too much but I have been doing this for years and have quite an arsenal of code snippets I would love to share....
--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 21, 2013 at 3:49 pm

#1626510
RE: Email Formatted HTML Table with T-SQL

steve.ledridge (6/20/2013)
I found the timing of this to be interesting as I just completed a first draft of a CLR Function the returns a SQL table as HTML Table code...
--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 21, 2013 at 9:37 am

#1626382
RE: Bulk Insert format file but input file not always fixed

jdixon-586320 (6/20/2013)
I am trying to do a bulk insert using a non-xml file format. When my input file exactly matches my format file the bulk insert works fine. I have...
--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 21, 2013 at 6:58 am

#1626304
RE: Usage of CTE - Trick with Dates

whenriksen (6/18/2013)
One other thing:
Please note that I have used TOP 100 PERCENT in the SELECT statement in this function because I want to retain the ORDER BY clause, which 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)

June 21, 2013 at 6:26 am

#1626297
RE: Email Formatted HTML Table with T-SQL

Dave Vroman (6/20/2013)
[p]Because of PCI compliance, both xp_cmdshell and db_sendmail are disabled on our database servers. I needed to get some of my tasks to send email to me so...
--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 20, 2013 at 10:11 am

#1626011
RE: Email Formatted HTML Table with T-SQL

Mike Dougherty-384281 (6/20/2013)
Are we solving the problem right?
Are we solving the right problem?
Jeff asked why use xp_cmdshell to get to a third-party tool & suggested db_sendmail: depending 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)

June 20, 2013 at 10:04 am

#1626005
RE: Email Formatted HTML Table with T-SQL

SQL-DBA (6/20/2013)
Jeff Moden (6/19/2013)
I don't believe you'll find anyone more pro-xp_CmdShell or pro_BCP than myself but I can't figure out why you bothered with either for this task since sp_SendDBMail...
--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 20, 2013 at 9:24 am

#1625974

Viewing 15 posts - 26,581 through 26,595 (of 59,099 total)