Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,671 through 38,685 (of 59,072 total)

RE: Data display issue

Cnu2010 (4/30/2010)
For a given County, I am returning the cities in that County
SELECT DISTINCT CITY FROM DEMO WHERE COUNTY = @COUNTY
CITY
-----
EDINA
BLOOMINGTON
EDEN PRAIRIE
SHAKOPEE
How do I display this data in a row...
--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)

April 30, 2010 at 7:00 pm

#1160834
RE: Data display issue

Ninja's_RGR'us (4/30/2010)
How the heck will that work with a country like USA or Canada where you have 1000s of cities?
Heh... one can only hope that the criteria presented is "example...
--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)

April 30, 2010 at 6:59 pm

#1160833
RE: Data display issue

GregoryF (4/30/2010)
Write a cursor.
Fetch each county into it.
Create a variable and keep concat'ing the new county + a space
When the cursor is done, print the variable that contains the string...
--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)

April 30, 2010 at 6:57 pm

#1160832
RE: The value of variable is disappearing in stored procedure

David Webb-200187 (4/30/2010)
Just a shot in the dark without being able to see the code, but if you're using the variable in any concatenation operation, you might want 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)

April 30, 2010 at 6:55 pm

#1160830
RE: Dynamic SQL To Update Table With CASE

Garadin (4/30/2010)
Danny Sheridan (4/30/2010)
(wish I went to college for CS or DB Development/Management :ermm:). Learn something new everyday!
You could probably count on one hand the number of regulars...
--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)

April 30, 2010 at 6:48 pm

#1160828
RE: Not deleting my dates correctly

I would say the following snippet of your code will probably keep all deletes from happening...
AND
UserClientMetaDataId NOT IN (SELECT USERCLIENTMETADATAID FROM dbo.LPBSecurity_UserClientSignature)
--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)

April 30, 2010 at 6:44 pm

#1160826
RE: Update records with similar values

squidder11 (4/30/2010)
Many thanks for all the code
Very helpful thanks
To help you out with what "The Dixie Flatline" is saying above, please see the article at the first link in my...
--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)

April 30, 2010 at 6:36 pm

#1160825
RE: Using Brackets and Ranges

Jacob Pressures (4/30/2010)
I'm going to find the first occurenc of a number and then count based on the occurence of dashes. If there is one dash such as 03-10, 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)

April 30, 2010 at 6:27 pm

#1160823
RE: Median

keywestfl9 (4/30/2010)
i have a table with 3 rows
Producttyp2col1 col2
A22
A02
A11
A20
B 2 ...
--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)

April 30, 2010 at 6:22 pm

#1160821
RE: Dynamic Cursor Within a Cursor

Whisper9999 (4/30/2010)
I built a dynamic SQL statement (SS 2005) that has a cursor in it. Then I executed that dynamic SQL statement within another cursor. It would just...
--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)

April 30, 2010 at 6:08 pm

#1160815
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Dennis Wagner-347763 (4/30/2010)
Super article Jeff -- as always. Thanks especially for writing something that works in SQL 2000 (until you hit the 4000 char limit). A number of...
--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)

April 30, 2010 at 7:15 am

#1160387
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Madhivanan-208264 (4/30/2010)
When I visited belution forum, I used to think you were the moderator or site owner and I came to know about you only from that forum 🙂
But what...
--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)

April 30, 2010 at 7:11 am

#1160382
RE: Please Solve This query

anshu84onnet (4/28/2010)
Hi this is the scenario please solve this query waiting for immediate response please
Please send $1,000 USD to my PayPal account as a down payment and I'll get started...
--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)

April 29, 2010 at 3:46 pm

#1160087
RE: TempDB log growth

Contact the folks at MOSS 2007... they created the problem and they need to fix it. Simply shrinking TempDB now and again isn't going to do anything except frag...
--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)

April 29, 2010 at 3:38 pm

#1160083
RE: Code challenge: Complicated CSV into table

It's a "simple" 2 dimensional split. Please see the following article for some different methods to handle such a thing.
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)

April 29, 2010 at 3:32 pm

#1160079

Viewing 15 posts - 38,671 through 38,685 (of 59,072 total)