Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,991 through 52,005 (of 59,067 total)

RE: SELECT Statement Question

robertafricker (3/7/2008)
Hi Jeff,
Thanks for weighing in re: Lynn's rewrite. Now, it makes more
sense to me, that hanging "IN" was throwing me off!
I'll be sending through some far meatier examples...
--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 7, 2008 at 3:50 pm

#786963
RE: Where are stored the stored procedures?

...or... if you just want the names of the objects so you can go look at them...
--===== Find name of proc, view, function, etc containing text in DDL
SELECT DISTINCT...
--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 7, 2008 at 3:26 pm

#786958
RE: How to get Client Records from a database

If it's a one time thing only... why not change the text window to use tabbed delimiters and tell it to save to a file?
--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 7, 2008 at 3:17 pm

#786951
RE: Creating assembly

Heh... it's the SQL gods telling you that you should solve the problems in T-SQL instead of writing a CLR 😀
--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 7, 2008 at 3:14 pm

#786949
RE: I got burned today at a SQL Server Interview!

ScottPletcher (3/7/2008)
Well, I guess it's nice to see that there are still places where low standards prevail and former govt employees can find actual work.
Low standards? Former Govt employees?...
--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 7, 2008 at 3:10 pm

#786946
RE: How do I replace data in column A with the data from column B?

Sure, you can use LEFT 10 to do that... but stop just for a minute... you've not told us why you want to overwrite the ID with the Description. ...
--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 7, 2008 at 3:00 pm

#786940
RE: Adding the time to a Date(DateTime)

It sounds to me like the DateDebut column is a VARCHAR column and could be in the dd/mm/yyyy format instead of the format you're expecting of mm/dd/yyyy.
--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 7, 2008 at 2:48 pm

#786932
RE: How do I replace data in column A with the data from column B?

Hold the phone... how do you know that the only things that start with VA are VA- as in Virginia... never do an update of this nature without first doing...
--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 7, 2008 at 2:43 pm

#786928
RE: I got burned today at a SQL Server Interview!

Wow this thread reminds me of my last interview. I was asked what is the fastest way to clear a table.
BWA-HA-HA-HA!!! Oh, the poor fools that last asked me...
--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 7, 2008 at 2:22 pm

#786917
RE: Openrowset Bulk Insert

The reason why you have to do it with Dynamic SQL is because it will not allow you to do formulas in the query. The Query must be "hard...
--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 7, 2008 at 1:15 pm

#786882
RE: Can I Do a Select *FROM StoredProcedure ??

Sorry... I can't read Spanish...
--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 7, 2008 at 1:13 pm

#786880
RE: SELECT Statement Question

I'll throw in that just from a code consistency standpoint, WHERE IN should be rewritten to a normal INNER JOIN like Lynn wrote 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)

March 7, 2008 at 1:07 pm

#786877
RE: TempDB Taskpad View

You may have to do a DBCC UPDATEUSAGE on TempDB just before the sp_SpaceUsed to get that to change...
--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 7, 2008 at 11:42 am

#786845
RE: Counting Rows without Identity

Correct... not worth it. And 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)

March 7, 2008 at 11:39 am

#786842
RE: Can I Do a Select *FROM StoredProcedure ??

What? One row? You'll need to show me that URL... take a look at Books Online, instead... example they give uses SELECT TOP 1000 *...
--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 7, 2008 at 11:32 am

#786837

Viewing 15 posts - 51,991 through 52,005 (of 59,067 total)