Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,971 through 50,985 (of 59,098 total)

RE: Can't see owned tables

Sounds like someone changed a role or reassigned a role. Maybe even changed to Windows Authentication without doing the necessary work to keep privs.
--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)

April 25, 2008 at 8:25 pm

#807471
RE: DTS - loading mixed data types from text file.

I import all columns as VARCHAR and evaluate from there. You should only import to a staging table... there you can make such decisions before transferring to the final...
--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)

April 25, 2008 at 8:22 pm

#807470
RE: Extracting Rows from Delimited Strings

Matt Miller (4/25/2008)
Jeff - that last code nulls out the 0's in the 3rd column - is it supposed to?
Nah... I screwed up.
The real key to this whole thing is...
--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)

April 25, 2008 at 8:17 pm

#807468
RE: CTE's are useless

Seggerman (4/25/2008)
There are times (not too often) where speed at any cost is unwise
I may be a newbie at SQL Server but in computer programming for over 3 decades
my current...
--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)

April 25, 2008 at 8:00 pm

#807466
RE: User Defined Function - Passing and Processing a Table

rbarryyoung (4/16/2008)
I am confused. Why isn't robert's answer sufficient?
I agree... why is everyone still looking for an aggegate function and passing columns of data when Robert's very simple formula...
--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)

April 25, 2008 at 7:42 pm

#807464
RE: BCP Trigger Hangs up Insert Statement

Another problem other than the ones already stated is that even if all of this worked correctly, BCP destroys existing files and overwrites them.
I may have a work-around for 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)

April 25, 2008 at 7:28 pm

#807463
RE: DELETE DUPLICATE RECORDS

Ariel Dimapilis (4/23/2008)
Hi All
Anyone can help me how to delete a duplication records retain one value in one table
Can anyone give a script for deleting duplicates records.
Please help me, I'm...
--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)

April 25, 2008 at 5:29 pm

#807446
RE: Working with strings

What is the primary key of the matrix? Also, not that we'll necessarily need it, but can Dynamic SQL be 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)

April 25, 2008 at 3:31 pm

#807427
RE: querying a string

GSquared (4/25/2008)
That's going to work better than spaces around the "like" statement. Of course, if you want it to include "pros" (plural), or "professional"/"professionals", you can add to 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)

April 25, 2008 at 7:58 am

#807185
RE: querying a string

MarkusB (4/25/2008)
In order to work correctly, you must surround the source and target with the delimiters in the column... in this case, spaces.
[font="Courier New"]SELECT myvarcharCol from mytable
WHERE ' '+myvarcharCol+' '...
--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)

April 25, 2008 at 7:56 am

#807184
RE: Get rid of Dynamic SQL

I use this one often...
[font="Courier New"]...
...
WHERE (@A = AColumn OR @A IS NULL)
AND (@B = BColumn OR @b-2 IS NULL)
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)

April 25, 2008 at 7:47 am

#807180
RE: Extracting Rows from Delimited Strings

Try this... it's Adrian's original code with some conditions added...
SELECT LEFT(raw_payload, CHARINDEX('+', raw_payload, 1)-1),
...
--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)

April 25, 2008 at 7:41 am

#807176
RE: Extracting Rows from Delimited Strings

Gus,
This is an SQL Server 2000 forum... 😉
--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)

April 25, 2008 at 7:29 am

#807163
RE: Extracting Rows from Delimited Strings

Adrian... take a look at the original post... the first entry in the data looks like 'S2009+' which means that you'll get invalid substring messages for the 2 and 3rd...
--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)

April 25, 2008 at 7:03 am

#807137
RE: Merging Rows with comma

karthikeyan (4/25/2008)
I am also thought to use WHILE LOOP.
Adrian, do you think is there any performance wise difference between using CURSOR and WHILE loop ?
Please share your thoughts.
Cursor (with...
--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)

April 25, 2008 at 7:00 am

#807134

Viewing 15 posts - 50,971 through 50,985 (of 59,098 total)