Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,256 through 27,270 (of 59,101 total)

RE: inserting data from one table to another and want to create primary key at same time

alan_lynch (3/11/2013)
I am creating a table by using an insert into from another table
then I am deleting any duplicate rows from that table
then I try to create a primary key...
--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)

March 12, 2013 at 8:40 am

#1596053
RE: inserting data from one table to another and want to create primary key at same time

demonfox (3/12/2013)
When you use
Select Into
the columns created would take the data type ,nullability etc. properties from the columns available in FROM clause.
so make sure you have SOFTWARE_NAME_ORIGINAL as NOT...
--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)

March 12, 2013 at 7:44 am

#1596012
RE: inserting data from one table to another and want to create primary key at same time

Reminder: There's no such thing as "minimal logging" if the database is using the "Full" recovery model.
Reminder: Temporarily shifting to "Simple" recovery destroys the log chain and either a...
--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)

March 12, 2013 at 7:42 am

#1596010
RE: Are the posted questions getting worse?

Lynn Pettis (3/11/2013)
Lynn Pettis (3/10/2013)
Okay, first, I am not apologizing for what or how I said it. I am curious, however, if anyone thinks I went to far here.
Use...
--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)

March 11, 2013 at 6:27 am

#1595511
RE: Script to calculate when a job ended.

David Burrows (3/11/2013)
SELECT DISTINCT j.name as job_name,
msdb.dbo.agent_datetime(run_date, run_time) AS [run_datetime],
DATEADD(second,DATEDIFF(second,0,msdb.dbo.agent_datetime(19000101, run_duration)),msdb.dbo.agent_datetime(run_date, run_time)) AS [run_endtime]
FROM msdb..sysjobhistory h
INNER JOIN msdb..sysjobs j ON h.job_id = j.job_id
WHERE j.name NOT LIKE 'Backup%'
AND j.name NOT...
--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)

March 11, 2013 at 6:23 am

#1595508
RE: Are the posted questions getting worse?

SQLRNNR (3/10/2013)
Lynn Pettis (3/10/2013)
GilaMonster (3/10/2013)
Since it's the msdb job tables, it's a bit of a stretch to say we don't have data. That said, that had a feel of 'do...
--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)

March 11, 2013 at 6:06 am

#1595499
RE: Best way to store images

OTF (3/11/2013)
This is more of a question that it is a solution but, Jeff, with the advent of filestream technology in more recent versions of sql server have you used...
--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)

March 11, 2013 at 5:55 am

#1595491
RE: Dynamically Download FTP Files Using SSDT

I think the article is fine. It looks like it's nicely laid out in a step by step fashion that most whom work with SSIS will easily understand. ...
--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)

March 11, 2013 at 5:15 am

#1595463
RE: Are the posted questions getting worse?

dwain.c (3/10/2013)
Jeff Moden (3/8/2013)
...Since I'm mostly a data troll...
Does that mean you live under a bridge on Al Gore's information superhighway?
Nah... I've gone wireless. 😛
--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)

March 10, 2013 at 10:45 pm

#1595374
RE: Are the posted questions getting worse?

Stefan Krzywicki (3/9/2013)
Jeff Moden (3/8/2013)
Matt Miller (#4) (3/8/2013)
Jeff Moden (3/7/2013)
Revenant (3/4/2013)
Evil Kraig F (3/4/2013)
Revenant (3/4/2013)
I always find it frustrating when someone asks me or someone else to do things 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)

March 10, 2013 at 10:40 pm

#1595372
RE: Are the posted questions getting worse?

Matt Miller (#4) (3/9/2013)
Jeff Moden (3/8/2013)
Matt Miller (#4) (3/8/2013)
Jeff Moden (3/7/2013)
Revenant (3/4/2013)
Evil Kraig F (3/4/2013)
Revenant (3/4/2013)
I always find it frustrating when someone asks me or someone else to do things...
--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)

March 10, 2013 at 10:34 pm

#1595370
RE: sequencial insert

Rauf Miah (3/10/2013)
"List of Heads" of A, B, C, D data type is nvarchar(250)
Thanks. I just got off from work and, if someone doesn't beat me to it (lots...
--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)

March 10, 2013 at 10:14 pm

#1595369
RE: Eliminate duplicate in the same column

Then the following should do it for you. Please understand that I've not actually tested the code. Please see the first link in my signature line below 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)

March 10, 2013 at 10:20 am

#1595309
RE: sequencial insert

Rauf Miah (3/10/2013)
I like to insert SIRCODE in Sequence like x= x+1000
Then it look like
Comcod Sircode ...
--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)

March 10, 2013 at 9:57 am

#1595307
RE: Looping without cursor not updating properly

Getting back to the problem at hand, I did a read of the code and I don't readily see the problem. I'll take another look after I get some...
--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)

March 9, 2013 at 10:58 pm

#1595279

Viewing 15 posts - 27,256 through 27,270 (of 59,101 total)