Jeff Moden

Forum Replies Created

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

RE: how to write a stored procedure for this

enriquezreyjoseph (9/20/2013)
Can you show us the code??..
cheers!!
"Be Brave even though you are not no one can tell the difference" - sir bernard tan
To whom are you speaking?
--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 20, 2013 at 6:55 am

#1651895
RE: Adding time intervals in minutes and display as csv

Koen Verbeeck (9/19/2013)
kalikoi (9/19/2013)
gentleman thx for the code but here is my approach
composed a udf that returns the csv
DECLARE @StartTime TIME(0) = '00:10'
DECLARE @EndTime TIME(0) = '01:40'
DECLARE @MinutesToAdd INT =...
--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:49 pm

#1651763
RE: Want to add Text data

niladri.primalink (9/19/2013)
Thanks guys for your input
It is working awesome!!
"It"? What is "It"? What did you end up using? Please post the code that you ended up using.
--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:18 pm

#1651757
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

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