Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,776 through 32,790 (of 59,099 total)

RE: Formula in Excel?

The best way, IMHO, is to write a view and create and "External Data Source" on the spreadsheet.
--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)

August 23, 2011 at 12:04 pm

#1372196
RE: Better Query instead of loop

No... you can't use it in a view as it currently is. A view must be a single query. You'll need to "fold" the dates table in as...
--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)

August 23, 2011 at 10:24 am

#1372140
RE: Are the posted questions getting worse?

ChrisM@Work (8/22/2011)
Hi folks, I've not visited here for ages, I hope you are all well.
Anybody recruiting presently? We've been recruiting a DBA and a TSQL developer (with some role...
--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)

August 22, 2011 at 11:26 am

#1371600
RE: Pull out month and year

lance.kentwell (8/21/2011)
Jeff Moden (8/21/2011)
lance.kentwell (8/21/2011)
As it happens I am populating a table with prebuilt info for reporting purposes. It's much faster than forcing users to wait an hour each...
--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)

August 22, 2011 at 10:02 am

#1371512
RE: Are the posted questions getting worse?

GilaMonster (8/21/2011)
Jeff Moden (8/20/2011)
Hmmm... like any table, I thought that all of the rows of a TVP had to have the same number and type of columns in the same...
--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)

August 21, 2011 at 9:47 am

#1371177
RE: Are the posted questions getting worse?

SQLkiwi (8/20/2011)
Jeff Moden (8/20/2011)
Hmmm... like any table, I thought that all of the rows of a TVP had to have the same number and type of columns in the same...
--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)

August 21, 2011 at 9:46 am

#1371176
RE: Consider these this two DBA position

Consider the following:
[font="Arial Black"]The answer is always "NO" unless you ask.[/font]
Go for 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)

August 21, 2011 at 9:44 am

#1371175
RE: "Select Where In" using a parameter?

arshad7887 (8/20/2011)
To Run this kind of query first you need to create UDF(user defined function)
SPLIT Varchar in sql server
User Defined Method
CREATE FUNCTION SplitString
(
--...
--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)

August 21, 2011 at 9:13 am

#1371174
RE: Pull out month and year

lance.kentwell (8/21/2011)
As it happens I am populating a table with prebuilt info for reporting purposes. It's much faster than forcing users to wait an hour each time they want...
--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)

August 21, 2011 at 9:09 am

#1371173
RE: how to return the result in a stored procedure

Prasanthi Reddy (8/20/2011)
Thanks for the reply..
I tried as create procedure GET_HEIRARCHY_CODE(@str varchar(50),@code varchar(30) OUTPUT)
AS
BEGIN
-----statements
RETURN @CODE;
END
but while executing it is asking to pass value for @code also..
can u pls explain how...
--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)

August 20, 2011 at 9:58 pm

#1371116
RE: Pull out month and year

lance.kentwell (8/20/2011)
These two results would be the inserted into a table with columns called "Month" and "Year"
Any suggestions?
Yes, but not the one you want (which the others have already covered...
--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)

August 20, 2011 at 9:50 pm

#1371114
RE: COALESCE() - Does it calculate every value or does it stop when it gets a not NULL

aaron.reese (8/19/2011)
title says it all really.
I have a Coalesce() statement that has three fairly complex queries in it's array. One of these is extremely resource hungry and takes some...
--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)

August 20, 2011 at 9:46 pm

#1371113
RE: It's RBAR - but which method will be best

IIRC, a STATIC cursor builds its own Temp Table behind the scenes, anyway.
--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)

August 20, 2011 at 9:30 pm

#1371112
RE: Removing redundant information

doug 40899 (8/19/2011)
Jeff,
I've tried that and didn't get back all of the correct results. I did a line by line comparison for running my query with everything after the union...
--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)

August 20, 2011 at 7:43 pm

#1371111
RE: Are the posted questions getting worse?

GilaMonster (8/19/2011)
Jeff Moden (8/19/2011)
I'd love to know more about the application concerning parent and multiple child records. If you have the chance to "haul out the front-end code", 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)

August 20, 2011 at 7:29 pm

#1371110

Viewing 15 posts - 32,776 through 32,790 (of 59,099 total)