Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,511 through 30,525 (of 59,101 total)

RE: Data in tthe same order in which it is inserted

As a side bar, it's always amazed me that people find importance in the order of the data in a file without actually having something in the file to preserve...
--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 30, 2012 at 3:33 pm

#1467222
RE: FK referencing PK in *same* table

Heh... a Rose, by any other name, is still a Rose.
Unless I'm mistaken, all of the examples above all boil down to some form of parent/child relationship.
--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 30, 2012 at 3:23 pm

#1467221
RE: Subtotals in t-sql

gmcnitt (3/30/2012)
I think rollup is required, just can't seem to get it right. thanks!
Correct. Post the code where you tried WITH ROLLUP and let's see what we can figure...
--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 30, 2012 at 12:37 pm

#1467140
RE: Subtotals in t-sql

MyDoggieJessie (3/30/2012)
You could try this, works pretty wellSELECT Pin, CDate, btn, callduration, charge FROM #gmreport ORDER BY pin
COMPUTE SUM(callduration), SUM(charge) BY pin
Careful now... that's actually been deprecated not to mention that it will return multiple result...
--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 30, 2012 at 12:35 pm

#1467137
RE: FK referencing PK in *same* table

Most likely its a parent/child relationship. I can't think of any other reason to do such a thing.
--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 30, 2012 at 12:32 pm

#1467136
RE: Delete Incremental Load of Data without Identify Column or DateTime Stamp

If there's something that uniquely identifies the rows (such as a PK or other candidate column), load the incremental data into a staging table, delete all the rows in 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 30, 2012 at 12:30 pm

#1467134
RE: Wrong Answer on MS Practice Test?

From Books Online...
Tail log backups capture the tail of the log [font="Arial Black"]even if the database is offline[/font], damaged, or missing data files. This might cause incomplete metadata 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 30, 2012 at 12:25 pm

#1467129
RE: How to use pivot for varchar column

kuppurajm (3/30/2012)
Hi,
I have a table like
rowid CustLevel ...
--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 30, 2012 at 7:52 am

#1466945
RE: Joining datetime dates to calendar table

Phil Parkin (3/30/2012)
Jeff Moden (3/30/2012)
If you can make a small mod to your Calendar table... I usually create a Calendar table with 2 date columns to easily solve such an...
--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 30, 2012 at 7:47 am

#1466941
RE: Technical Interview - I feel dumb now.... :)

amy26 (3/29/2012)
but I would really like to be in a cutting edge shop with lots of other developers that I can learn some of these things we're talking about. ...
--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 30, 2012 at 7:09 am

#1466918
RE: Joining datetime dates to calendar table

If you can make a small mod to your Calendar table... I usually create a Calendar table with 2 date columns to easily solve such an eventuality. The first...
--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 30, 2012 at 6:49 am

#1466899
RE: Do not want to use a cursor but how.....

Ok... thanks. How would you like to have it parsed?
--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 30, 2012 at 6:43 am

#1466897
RE: How to create a database backup using visual studio

vinaypugalia (3/30/2012)
Adding any User objects to the Master DB is a very BAD idea.
Heh... At the risk of starting World War III, you are denying yourself one amazing tool 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 30, 2012 at 6:39 am

#1466895
RE: Do not want to use a cursor but how.....

Jeff Moden (3/29/2012)
jeffrey.farr (3/29/2012)
Like I mentioned, it just parses the column/variable @TA and stores the data in another table.
Please post an example of what @TA would contain. If it's...
--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 30, 2012 at 6:25 am

#1466888
RE: Do not want to use a cursor but how.....

I have a problem with using XML for such a thing simply because there's a comparatively large BYTE overhead thanks to all of the embedded tags. Of course, 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 30, 2012 at 6:24 am

#1466886

Viewing 15 posts - 30,511 through 30,525 (of 59,101 total)

Jeff Moden

Forum Replies Created

RE: Data in tthe same order in which it is inserted

RE: FK referencing PK in same table

RE: Subtotals in t-sql

RE: Subtotals in t-sql

RE: FK referencing PK in same table

RE: Delete Incremental Load of Data without Identify Column or DateTime Stamp

RE: Wrong Answer on MS Practice Test?

RE: How to use pivot for varchar column

RE: Joining datetime dates to calendar table

RE: Technical Interview - I feel dumb now.... :)

RE: Joining datetime dates to calendar table

RE: Do not want to use a cursor but how.....

RE: How to create a database backup using visual studio

RE: Do not want to use a cursor but how.....

RE: Do not want to use a cursor but how.....