Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,146 through 38,160 (of 59,102 total)

RE: Collapsing a Table

lmu92 (5/31/2010)
I'm not sure if this is the fastest way, but at least it's an option... 😉
That seems to loose the bubble when the ranges on the same row are...
--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 31, 2010 at 2:03 pm

#1174585
RE: SQL Server Training

saiphanindrait (5/31/2010)
Hello Ali,
This is Sai Phanindra and working as Production DBA in one of the top MNCs in India. I have been providing trainings during my free times. The course...
--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 31, 2010 at 11:27 am

#1174565
RE: Set based approach to get previous rows value for same column which is a calculation

all4miller (5/31/2010)
NB# I'm not sure if the top and order by are enough to guarantee the correct order if someone can comment on that will be great
Heh... I'm thinking that...
--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 31, 2010 at 11:17 am

#1174562
RE: ADD column storeID while bulk inserting

I guess I wouldn't do it that way then. Have you tried the code I posted?
--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 31, 2010 at 10:50 am

#1174554
RE: Are the posted questions getting worse?

Jack Corbett (5/30/2010)
To be honest it wouldn't be a simple task for me now, I'd have to look it up...
I guess that's part of my point, as well. Considering...
--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 31, 2010 at 10:25 am

#1174547
RE: Are the posted questions getting worse?

Lynn Pettis (5/30/2010)
Jeff Moden (5/29/2010)
I wonder what the interview process was and how full of hooie the resume was that allowed someone to have a job that required someone to...
--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 31, 2010 at 10:16 am

#1174544
RE: Select Average By DATEPART Weekday

spike62 (5/31/2010)
Also...
Since I was up at an ungodly hour anyway, I went ahead and added a calendar table to my DB(from a script on this site), used it to set...
--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 31, 2010 at 9:43 am

#1174536
RE: ADD column storeID while bulk inserting

Matt Miller (#4) (5/31/2010)[hrTrue on just about all points (some are opinions so I certainly am not going to fight them). SSIS is definitely an "acquired taste", but 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)

May 31, 2010 at 9:35 am

#1174534
RE: ADD column storeID while bulk inserting

daniarchitect (5/31/2010)
someone suggested to use batch programming on the files to insert storeid.
Jeff thank you
Did that someone give you the batch code to do it? And did they show...
--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 31, 2010 at 9:28 am

#1174530
RE: Concatenate string using a Function and a View

infodemers (5/31/2010)
Hi ColdCoffee,
I tried your suggestion but it ran for over 5 minutes. So I stopped it.
My solution isn't better as well.
Thanks fro trying to help me!
I have...
--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 31, 2010 at 9:07 am

#1174525
RE: Concatenate string using a Function and a View

Gopi Muluka (5/31/2010)
slightly better version of your function
CREATE FUNCTION [dbo].[fn_GopiRecNumberSubject] ( @RecNo CHAR(7) )
RETURNS VARCHAR(1024)
AS BEGIN
DECLARE @ReturnValue VARCHAR(1024),@RecNo CHAR(7)
SELECT @ReturnValue = COALESCE(@ReturnValue, '') + [Subject] + ','
FROM View_RecNumberSubject WHERE...
--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 31, 2010 at 9:03 am

#1174523
RE: Concatenate string using a Function and a View

infodemers (5/31/2010)
Hi Jeff Moden ,
I need to do this because my customers want it that way in their Excel report.
Regards!
Heh... yeah, I kind of figured it was 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)

May 31, 2010 at 8:55 am

#1174522
RE: Concatenate string using a Function and a View

infodemers (5/30/2010)
And I wish to concatenate the subject for each of them to make a result like this:
|RecNumber|Subject|
|333-123 |Canada,Mexico,India|
|444-456 |France,Germany|
|555-882 |USA|
Now that you have a decent answer,...
--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 30, 2010 at 10:28 pm

#1174384
RE: ADD column storeID while bulk inserting

Matt Miller (#4) (5/30/2010)
I no longer have a functional version of DTS (my 2K server is history). That said (from memory, so bear with me):
- First would...
--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 30, 2010 at 10:25 pm

#1174383
RE: Select Average By DATEPART Weekday

I believe your only problem is that you were taking the average of the wrong thing...
SELECT ii.Description, AVG(sq.Qty*ii.Amount) AS MondayAvg,
(Select u.UOM_Name
From UOM u
Where u.UOM_ID = ii.InvUnit) AS UOM
FROM SalesQty sq
LEFT...
--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 30, 2010 at 9:23 pm

#1174379

Viewing 15 posts - 38,146 through 38,160 (of 59,102 total)