Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,061 through 48,075 (of 59,095 total)

RE: Stored Procedure Not Returning Values

In other words, start by doing an OUTER JOIN on the homes table with all the other tables. Then, wittle from there.
--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)

September 28, 2008 at 7:16 pm

#878230
RE: CustomRollupColumn and aggregates

You'd get better help quicker if you'd follow the methods in the article in the link in my signature below... 😉
--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)

September 28, 2008 at 7:10 pm

#878229
RE: NEED HELP in CREATING NEW DATABASE

cuteprabakar (9/27/2008)
Dear All, I need help TO design DB that will contain the following tables. I am using ASP in the frontend
USERS
[userid] [int] NOT NULL,
[password] [int] NOT NULL,
[Fullname] [nvarchar] (50)...
--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)

September 28, 2008 at 7:08 pm

#878228
RE: 'Your Response' bar could use more detail

Not sure if it's possible, but it would also be really cool if we could have discussions on SQL Server about articles not on SQL Server. In other words,...
--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)

September 28, 2008 at 6:56 pm

#878227
RE: Outakes-please eliminate

Keller (9/28/2008)
Please don't ever eliminate the outtakes. "The human side of Steve Jones" is my favorite part of every editorial! 🙂 (Besides the valuable content, of course!)
I'll...
--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)

September 28, 2008 at 6:54 pm

#878226
RE: cursor

The OP must like porkchops...
--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)

September 28, 2008 at 6:51 pm

#878225
RE: array in sql server

Not sure what you mean, but if you want to pass an array to SQL, then the following article will help... covers passing of 1, 2, and 3 dimensional arrays...
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

September 28, 2008 at 6:45 pm

#878223
RE: Issue with stored procedure...

Matt Miller (9/27/2008)
Jeff Moden (9/27/2008)
Heh... thanks for posting your solution. Sometimes the problem just boils down to "must look eye." 🙂
Any more references like these and you're going...
--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)

September 28, 2008 at 6:40 pm

#878222
RE: Use a database if exist

Matt Miller (9/27/2008)
There's always TRY/CATCH, too.
Yeah, I know... but I just can't bring myself to programming by exception. I'd rather know the correct answer up front and take...
--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)

September 28, 2008 at 6:38 pm

#878221
RE: Update with multiple conditions - Help needed

You bet, Neela.
--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)

September 28, 2008 at 6:35 pm

#878220
RE: table names

I'm not sure who gave you the requirements on these file names, but the yyyymm format will serve you much better and for much longer.
--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)

September 27, 2008 at 9:20 pm

#878124
RE: Help on Dups

salvysmith08 (9/24/2008)
...if you can show me how to dynamically add column GRP on every dynamic table then that would great.
Old gaming trick... when you can't move, change color... Temp Table...
--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)

September 27, 2008 at 9:04 pm

#878123
RE: Use a database if exist

sivavardhan (9/26/2008)
Use the below script to find whether the database is there or not in a server
if exists
(select name from master..sysdatabases where name like '%abc%')
Begin
...
--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)

September 27, 2008 at 8:11 pm

#878121
RE: Use a database if exist

vyas (9/24/2008)
SET QUOTED_IDENTIFIER OFF
IF EXISTS(select * FROM master..sysdatabases where [name] ='pubs')
begin
use pubs
...
--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)

September 27, 2008 at 7:59 pm

#878120
RE: Formatting...date output

Stuff it...:P seriously... the STUFF solution that Chris Morris posted will do the trick just fine.
--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)

September 27, 2008 at 7:49 pm

#878119

Viewing 15 posts - 48,061 through 48,075 (of 59,095 total)