Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,631 through 27,645 (of 59,101 total)

RE: Conditional criteria on Where Clause and Quota distribution

vikrantkale18 (1/26/2013)
Hello Guys
I have table Named Information with columns Gender,car,Age,Employment Status
below are possible values above columns
In Gender : - Male , Female
Car :- Maruti, Tata, Skoda
Employment status :-...
--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)

January 26, 2013 at 5:54 pm

#1581342
RE: XML with word document style

elham_azizi_62 (1/26/2013)
Dear Tavis.
my goal is to create word mail merge with T-sql in a store procedure use of creating xml from query result.
is there Easier way to do this if...
--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)

January 26, 2013 at 5:43 pm

#1581341
RE: The query has been canceled because the estimated cost of this query

Anuj Rathi (1/26/2013)
I have found a solution. I also want to share with you guys.
http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/31f80c1f-6285-4966-b7ed-9d0f93816f52
Whoa! Thank you very much for posting the solution and it's real nice that 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)

January 26, 2013 at 5:24 pm

#1581340
RE: pass variables between SQL Server tasks in a JOB

SQL ORACLE (9/4/2009)
How about the global variable?
I know this is an old post and I might not get an answer from you but I have to ask... keeping in...
--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)

January 24, 2013 at 10:08 am

#1580626
RE: SQL Server 2005: Script all Indexes

Caveate Emptor. The latest listed script misses unique (clustered or not) and clustered indexes.
--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)

January 22, 2013 at 8:57 am

#1579680
RE: Antipathy for Entity Attribute Value data models

I agree with tymberwyld above. I normally limit EAVs to those things that cannot be known at design time.
I also think that the ability to datatype 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)

January 21, 2013 at 7:57 am

#1579266
RE: Using PATINDEX to find all numeric values

Jeff Moden (8/1/2008)
Sean Peters (7/31/2008)
No IsNumeric('11,22,33') = 1
Ummm... nope... it isn't...
SELECT ISNUMERIC('11,22,33')
-----------
0
(1 row(s) affected)
I will agree,...
--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)

January 20, 2013 at 1:20 pm

#1579041
RE: How to save sp exec result into a temp table

MyDoggieJessie (1/18/2013)
Jeff Moden (1/18/2013)
INSERT INTO #BreakDownByCategories
EXEC dbo.exec spGetCategoriesByDocIDAsTable @DocID
I believe an accidental typo?
INSERT INTO #BreakDownByCategories
EXEC dbo.spGetCategoriesByDocIDAsTable @DocID
Thanks for the catch. You are correct.......
--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)

January 18, 2013 at 2:53 pm

#1578894
RE: How to save sp exec result into a temp table

INSERT INTO #BreakDownByCategories
EXEC dbo.spGetCategoriesByDocIDAsTable @DocID
--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)

January 18, 2013 at 2:40 pm

#1578891
RE: Cramming for Interviews

lewandot (1/17/2013)
You can teach them SQL.
I'm finding that to be less and less true. Some people will never actually get 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)

January 18, 2013 at 2:35 pm

#1578888
RE: How to Make Scalar UDFs Run Faster (SQL Spackle)

Ah, Sergiy... my ol' friend. Long time no see. Thank you for stopping by and thanks for the great explanations.
Yeah... I agree... most folks using front...
--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)

January 17, 2013 at 11:04 pm

#1578561
RE: Cramming for Interviews

As those that have come to know me over the years will tell you, this is a REALLY sore spot with me especially for people that have alphabet soup after...
--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)

January 15, 2013 at 4:03 pm

#1577555
RE: Better Way to Perform this Query

dwain.c (1/14/2013)
Good grief! Now I suppose I'm going to need to put up or shut up.
Heh... glad it's not me this time. 😛
--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)

January 14, 2013 at 8:11 pm

#1577135
RE: Flattening a Parent Child Hierarchy

codeplexer (1/13/2013)
Oops, I should have say "I think this is a better way...." You can find your proof easily if you know copy and paste. But SQL newbie would 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)

January 14, 2013 at 4:33 pm

#1577115
RE: SQL Query

ChrisM@Work (1/11/2013)
Hi Paul
I'll try to have a look over the weekend. Meantime, it's the last 5 mins of my last day here - and it's BEERTIME!
Cheers
ChrisM
Voluntary job change? Or???
--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)

January 13, 2013 at 9:49 pm

#1576761

Viewing 15 posts - 27,631 through 27,645 (of 59,101 total)