Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,906 through 25,920 (of 59,099 total)

RE: how to write a stored procedure for this

iiit.raju (9/19/2013)
i have a table emp with columns empname and highprority jobs.
for example i have 3 emp and 10 high priority jobs(assume that high priority jobs are from h1- h10).I...
--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 19, 2013 at 10:16 pm

#1651756
RE: how to insert powershell values into sql server table

I saw a script on the "Scripting Guy" series of posts but I didn't save the URL because it seemed a little complicated to me to do such a simple...
--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 19, 2013 at 10:10 pm

#1651755
RE: Invalid object name 'sys.spt_values'

Indianrock (9/19/2013)
Sql 2012 Enterprise installation. user databases are all fine. Managing objects in management studio doesn't work. We know an application wrote its tables into the master...
--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 19, 2013 at 8:59 pm

#1651749
RE: Problem with update syntax

Erland Sommarskog (9/19/2013)
The syntax UPDATE FROM is scorned by some people, because it has a possible ambiguity. I don't share that opinion, because I think that rightly used UPDATE FROM...
--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 19, 2013 at 8:50 pm

#1651748
RE: Temp tables vs "permanent" temp table vs User Table Type

PiMané (9/4/2013)
What's the best way to store the XML?
The best way, IMHO, is to shred it on receipt and store it as properly normalized data. XML is formatted...
--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 19, 2013 at 8:44 pm

#1651747
RE: Shift Column values to the left

LinksUp (9/18/2013)
I did not see a way to do this without multiple update statements. But since this is a clean up job, running 2 updates should not be a big...
--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 19, 2013 at 8:11 pm

#1651741
RE: Printed Books Vs E-Books

Those are some severely limited choices. I use the first two plus multiple other formats and not limited to just laptops. I maintain ebooks on my desktop box...
--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 19, 2013 at 10:58 am

#1651595
RE: Pivot EDI EAV type table

al_nick (9/18/2013)
Hi all-
Any suggestions would be greatly appreciated.
See the attached table in Excel.
Please see the first "Helpful Link" in my signature line below. You stand a much better chance...
--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 18, 2013 at 5:34 pm

#1651331
RE: Shift Column values to the left

Sean Lange (9/18/2013)
Since nobody else suggested it I guess I feel that I should. A more long term fix for this would be to normalize your data instead of fighting...
--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 18, 2013 at 5:25 pm

#1651329
RE: What does certification achieve?

L' Eomot Inversé (9/18/2013)
bcb (9/17/2013)
Some years ago I took a sample of the standard MCDBA (or whatever it was called) test. I quit in disgust when it asked "How many...
--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 18, 2013 at 5:22 pm

#1651327
RE: csv to rows

Dan.Humphries (9/18/2013)
two links for you to look at
http://codebetter.com/raymondlewallen/2005/10/26/quick-t-sql-to-parse-a-delimited-string/
Just to reinforce what Sean stated, if you have a splitter function with a WHILE loop or the word BEGIN in it,...
--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 18, 2013 at 3:26 pm

#1651310
RE: Accidental DBA - Where to Start? (General Question)

And just in case, backups. 🙂
--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 18, 2013 at 3:14 pm

#1651306
RE: Temporary table created in parent SP persists in child SP

C Hrushi (9/17/2013)
Many of you may know this but I found below observation today and though of posting it:
Thank you for your thoughtfulness. This is actually a good subject...
--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, 2013 at 4:55 pm

#1650975
RE: DBA Roles and Responsibilties

Gosh... I feel for ya. I guess I'd go to my boss (hopefully not the Sr DBA) and start a conversation about the problem. I'd also start looking...
--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, 2013 at 4:44 pm

#1650974
RE: cursor question

FDS_ (9/17/2013)
Thanks all! i did it that way and its working ok.
Now i will take your advise and i will try to do a masive inserts. Like:
INSERT dbo.Clients
SELECT...
--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, 2013 at 4:34 pm

#1650972

Viewing 15 posts - 25,906 through 25,920 (of 59,099 total)