Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,701 through 38,715 (of 59,098 total)

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
RE: Consider yourself a SQL Server Guru? - Solve this!

a1011 (4/29/2010)
I have a unique situation and I am having trouble writing a query to deal with it. This is what I have:
RowIDDatecreated Event
112010-04-01 06:16:16.6230
212010-04-01 12:25:18.9400
312010-04-01 20:03:07.1101
412010-04-01 20:40:27.2170
522010-04-01 09:48:42.4500
622010-04-01 09:51:24.8900
722010-04-01...
--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:21 pm

#1160073
RE: How to swap rows to columns

To learn how to do this in the future, please see the following article...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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 28, 2010 at 8:42 am

#1158995
RE: APPLY vs. Correlated Scalar Subquery in SELECT clause

I'd say "It Depends". In theory, they should have about the same execution plan. In reality, you need to turn on SQL Profiler and check out things like...
--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 28, 2010 at 8:39 am

#1158991
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/26/2010)
On plagiarism, my alma mater has some free software:http://digg.com/u1UU6a. I could host something using this if someone wants to help code.
Sorry Steve... I'm missing it... "help...
--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 27, 2010 at 9:42 am

#1158331

Viewing 15 posts - 38,701 through 38,715 (of 59,098 total)