Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,646 through 24,660 (of 59,099 total)

RE: Volunteering to gain SQL experience

If you're trying to get an actual job, then there are a couple of excellent routes to take.
Believe it or not, SQL Saturdays are one of the best places 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)

January 25, 2014 at 4:16 pm

#1683351
RE: Populating Multiple Tables with Same ID#

No problem. I just wanted to make sure that something wasn't going to break on you. Thanks for the feedback.
--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 25, 2014 at 3:57 pm

#1683349
RE: Optimize PIVOT table to include unlimited column and QTY of SKU - Help

pietlinden (1/24/2014)
You might want to read Dwain Camps' article on Creating Dynamic Crosstabs... that might give you some ideas.
My recommendation is that if you're going to make a recommendation 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)

January 25, 2014 at 3:24 pm

#1683348
RE: Optimize PIVOT table to include unlimited column and QTY of SKU - Help

wit_jp2001 (1/24/2014)
[font="Courier New"]--Need some help reformatting data in a PIVOT Table or find a better way to display.
--ORDERDETAIL TABLE
SKUO   QTYO    ORDERIDO
KUM    1   12345
KUS    2   12345
SUK    1   12345
KHN    4   12345
DRE    1   12345
HGF    2   12345
FDE    1   12345
CDS    1   12345
GYT    1   12345
POI    3  ...
--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 25, 2014 at 3:13 pm

#1683347
RE: How to study for MCSA SQL Server 2012

rho_pooka (1/24/2014)
Just stumbled upon this post, and in close to the same boat as the OP. I'm interested in advice about volunteering... Also, being new to this is there any...
--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 25, 2014 at 1:38 pm

#1683342
RE: Volunteering to gain SQL experience

Thanks for the feedback, Ben. To be sure, I'm not actually sour on volunteering. It's a great way to help the community even if you're green but will...
--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 25, 2014 at 8:48 am

#1683329
RE: recursive query

jadelola (1/25/2014)
Hi,
I would appreciate your help.
I have a table with payments. I need to check for each idno if he has payments for a certain year that exceeds the total...
--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 25, 2014 at 8:35 am

#1683328
RE: Volunteering to gain SQL experience

rho_pooka (1/24/2014)
Greetings all, I posted a comment in another thread but thought that starting a new topic may be appropriate.
Just a question for the veterans out there coming from someone...
--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 25, 2014 at 8:18 am

#1683325
RE: Populating Multiple Tables with Same ID#

homebrew01 (1/8/2014)
That makes sense. Looks like it's going to work, Thanks !
I might be missing something but, even if you did get it working, I'm not seeing anything 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)

January 24, 2014 at 6:51 pm

#1683299
RE: Convert SQL Server Date to DD/MM/YY

Lynn Pettis (1/9/2014)
Luis Cazares (1/9/2014)
Oh my, so much code! My laziness wants to write less.
declare @SSDate datetime = '20140109'
declare @CharSSDate char(10)
SELECT CONVERT( char(10), @SSDate, 103), --4-digit year
STUFF( CONVERT( char(10),...
--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 24, 2014 at 6:27 pm

#1683298
RE: Complex Query. Please help

sqlnaive (1/10/2014)
Everything was working fine but got the requirement change.Idea is:
a. base table can have multiple values of ID based on different books but can have only two values 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)

January 24, 2014 at 6:25 pm

#1683297
RE: T-SQL Export to CSV help

Instead of using SQLCMD for this, I'd recommend the use of BCP instead (with the understanding that it won't give you column headers).
--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 24, 2014 at 6:03 pm

#1683295
RE: Options for storing .jpg files on SQL Server 2008 R2

I used to think that storing files on a file system and providing the path in the database was the best thing. After the mess I found on our...
--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 24, 2014 at 5:55 pm

#1683294
RE: Migration of SSIS from SQL 2005 to SQL 2012

I was definitely thinking that. 🙂
--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 24, 2014 at 3:19 pm

#1683286
RE: Reason behind, if same query run several times the results are comming in less time

phil.doensen (1/23/2014)
It's query and data caching that will speed this up the second and third time round.
I find
DBCC DROPCLEANBUFFERS
will probably get you back to the 70sec mark,
but 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)

January 24, 2014 at 3:09 pm

#1683284

Viewing 15 posts - 24,646 through 24,660 (of 59,099 total)