Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,666 through 34,680 (of 59,099 total)

RE: Are the posted questions getting worse?

ltwitchell (3/11/2011)
I usually tell people I'm a database weenie, for the same reason.
I usually have called myself the data janitor. Makes people laugh and disarms them a bit from 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)

March 11, 2011 at 4:44 pm

#1297932
RE: Infinte Loop Excution

Jason-299789 (3/11/2011)
Jeff
A unique contraint would elimate the chance that there are 2 or more records with the same EmpId.
Exactly!. And THAT is precisely what is required for 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 11, 2011 at 11:51 am

#1297832
RE: Unique monthly headers for calendar events list

You don't need that function. SQL Server already has such a function. Try the following code and see.
SELECT DATENAME(mm,GETDATE())
--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, 2011 at 9:52 am

#1297753
RE: Displaying Sorted Hierarchies (SQL Spackle)

JunkIt (3/11/2011)
In its implementation of recursive CTEs, DB2 has a "Search Depth First" option that can be specified to return rows in this "drill down" fashion. I've been looking...
--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, 2011 at 9:29 am

#1297728
RE: what exact does this mean "bump our data agisnt their data and see what falls out"?

In the meantime, yes... import their data into a table and do a FULL OUTER join between your table and theirs. Things with NULL on one side or 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)

March 11, 2011 at 7:28 am

#1297611
RE: To set time to uplaod csv file to database

You probably don't need SSIS for this. Look into BULK INSERT which will do the job on a thousand rows in less than a second.
--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, 2011 at 7:25 am

#1297610
RE: Alphanumeric Value Sorting

Take a look at the first link in my signature line below. It may be why it's taking so long for someone to help you.
--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, 2011 at 7:22 am

#1297609
RE: Infinte Loop Excution

ranganathanmca (3/10/2011)
Hi Guys.,
Table structure :
create table tbemployee(
empid varchar(1200,
Name varchar(220),
supervisor_id varchar(120)
)
we need get the employee levels
Example:
--1
---2
----3
-----4
Like 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)

March 11, 2011 at 6:58 am

#1297596
RE: Update Trigger on multiple columns

M Joomun (3/11/2011)
Firstly, thanks to both of you for the replies.
Jeff Moden (3/10/2011)
Before you even think of capturing only the changes and the columns names, very carefully consider how you...
--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, 2011 at 6:54 am

#1297592
RE: Grouping and crosstab like behaviour.... hairy query

Ok... thanks, ZA.
--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, 2011 at 6:41 am

#1297585
RE: Hidden Formatting Troubles with STR() (SQL Spackle)

Jay Hopping (3/8/2011)
Oh crap... I 'discovered' STR about a 18 months back and have been using it as LTRIM(STR(n)) for creating strings.
.... well, at least...
--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, 2011 at 6:10 am

#1297569
RE: Union Query Total

The alternative is good but it's still ok to use the CTE... I just dump it's results into a TempTable if I need to call it more than once so...
--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, 2011 at 6:05 am

#1297567
RE: Tempdb Size increases and acquires the complete disk space

tosscrosby (3/9/2011)
Our end users (supposedly a high end user who had experience) who ran an adhoc query in PeopleSoft. Totally filled tempdb and brought SQL to it's knees,...
--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, 2011 at 6:01 am

#1297566
RE: Tempdb Size increases and acquires the complete disk space

mazzz (3/9/2011)
Jeff Moden (3/9/2011)
Heh... it must have been really bad code... normally such a problem with eat the face off of TempDB in just a couple of hours instead of...
--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, 2011 at 5:56 am

#1297561
RE: Grouping and crosstab like behaviour.... hairy query

ZA_Crafty (3/9/2011)
Ok Sorted now
I excluded the rows that caused the error, and found the results still a bit big, so I aimed at compressing the data even more. I then...
--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, 2011 at 5:54 am

#1297560

Viewing 15 posts - 34,666 through 34,680 (of 59,099 total)