Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,281 through 50,295 (of 59,091 total)

RE: Forum Etiquette: How to post data/code on a forum to get the best help

By the way... the code in the "too small" code window looks like this...
[font="Courier New"]select v.* from #mytable v, ( select min(id) as firstidofstagnation from #mytable v, ( select min(id)...
--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)

May 26, 2008 at 7:22 pm

#820313
RE: Replace values in a column with values from another column

This will do it... As always, details are in the comments...
--===== Supress the auto-display of rowcounts for appearance
SET NOCOUNT ON
--===== Create two test tables (table variables, in this...
--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)

May 26, 2008 at 7:08 pm

#820312
RE: Need to format HH:MM:SS

p.s. That will work only up to 23:59:59... if you need to exceed 24 hours, post back... there's a way...
--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)

May 26, 2008 at 6:11 pm

#820305
RE: Need to format HH:MM:SS

latingntlman (5/26/2008)
I apologize. I believe it represents time in Seconds.
I don't know too much about SSRS, yet... but here's how to do it in T-SQL...
SELECT CONVERT(CHAR(8),DATEADD(ss,4818,0),108)
Replace the 4818...
--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)

May 26, 2008 at 6:07 pm

#820304
RE: load a csv file

balamurugan.ganesan (5/26/2008)
Hi,
I need to load a csv file in to SQL 2005 which has comma within the data. How to load this I am fed up trying this:angry:
Some help 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)

May 26, 2008 at 5:49 pm

#820301
RE: Check for Existing records

Mike Levan (5/26/2008)
Sorry I confused you with table names.
Actually I am trying to insert,update into Emp table from the Old Emp.
I want this done with single tsql query.
It cannot be...
--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)

May 26, 2008 at 5:44 pm

#820300
RE: Determine fragmentation of HEAP table

It's much simpler to add a clustered index... doesn't have to be unique, you know? 😉
--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)

May 26, 2008 at 5:37 pm

#820299
RE: Looping thru data to make it one ROW in Data flow Task

"Must look eye!"
No cursors, no loops, no RBAR, please... simple Group By will do...
SELECT ID,
PPN,
...
--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)

May 26, 2008 at 5:36 pm

#820298
RE: Memorial Day

To all my fellow Americans, especially those who served with honor... Happy Memorial Day!
To all those currently in Service... THANK YOU! It's sometimes hard to remember why you're there......
--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)

May 26, 2008 at 5:26 pm

#820293
RE: Finding Available Keys When Merging Two Tables

Good approach, I think... my question would be, how do you find and change all the references to such a table? Now THAT would make for an interesting article....
--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)

May 26, 2008 at 4:48 pm

#820287
RE: sa removal

So, delete the SA account just like any other account... just make sure that SOME account has SA privs.
Still, I'd rather get the users used to the idea of the...
--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)

May 26, 2008 at 4:40 pm

#820286
RE: Automatically start MS SQL Server

One thing that you should be made aware of... Unless you're installing the Developer's Edition of SQL Server, it must run on a Windows Server.
--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)

May 26, 2008 at 4:35 pm

#820284
RE: recovery model

Maybe yes, maybe no... the Bulk Insert has to meet certain requirements to NOT be logged. Check for "Recovery Model" in Books Online for more information on the recovery...
--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)

May 26, 2008 at 10:03 am

#820223
RE: Can this validation rule be done with a Constraint?

I don't believe it's possible with a Check Constraint. Pretty sure a trigger is the only way to do this one.
--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)

May 26, 2008 at 9:58 am

#820222
RE: Automatically start MS SQL Server

What do you mean? SQL Server will load on boot unless someone has tampered with the initial settings. Do you mean power was removed from the server and...
--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)

May 26, 2008 at 9:56 am

#820220

Viewing 15 posts - 50,281 through 50,295 (of 59,091 total)