Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,486 through 46,500 (of 59,101 total)

RE: duplicate data

Wait a minute! What are you calling a duplicate!? You mean to tell me that no other username can make an entry on that date for that sLevel?
--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)

December 22, 2008 at 12:57 pm

#916338
RE: streamlining sql for a defined week columns

The reason it takes so long is because you've not aggregated the data. Please see the following for how to do a proper cross tab...
[font="Arial Black"]http://www.sqlservercentral.com/articles/T-SQL/63681/[/font][/url]
Without some actual test...
--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)

December 22, 2008 at 12:48 pm

#916333
RE: Stopping Loop when Using tally table loop for date ranges in stored procedure

In the previous post, you wrote ...
The select works to get me the counts. And the idea of the Tally table does make the selects more simplistic. I...
--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)

December 22, 2008 at 12:41 pm

#916330
RE: converting int to char and concatenating

Comparing that to the original, it looks like all you were missing was the FROM clause.
--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)

December 22, 2008 at 12:27 pm

#916318
RE: The Set-Based Limit

Kit Brandner (12/22/2008)
Consider the one exception I've encountered - generating a variable number of PIN codes according to a proprietary algorithm. There are easily several set-based approaches, but they run...
--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)

December 22, 2008 at 12:24 pm

#916314
RE: converting int to char and concatenating

Can you post what you ended up with, please? Thanks.
--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)

December 22, 2008 at 10:38 am

#916257
RE: Query to Calculate Cumulative Salary

This is what Vladan is talking about...
--===== Move just the data we want to a place where we can work on it
SELECT ISNULL(Sal,0) AS Sal,
...
--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)

December 22, 2008 at 5:58 am

#916084
RE: User Defined Function: order by won't work

GilaMonster (12/22/2008)
Jeff Moden (12/22/2008)
Ohhhhh.... that stuff..... gee... I wonder when they'll come out with an EDI data type? 😛
CREATE TYPE EDI
EXTERNAL NAME EDI.[PointlessClrTypes.EDI] ;
:hehe:
--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)

December 22, 2008 at 5:25 am

#916070
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

AnzioBake (12/22/2008)
What happens for for tables that the rows are not in a clustered index with the right order.
Like I said in the article... copy to a temp table and...
--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)

December 22, 2008 at 5:14 am

#916063
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

I agree... this one looks like RBAR because it does something for each row... but so do all of the queries built in SQL Server. The difference here...
--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)

December 22, 2008 at 5:12 am

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

AnzioBake (12/22/2008)
Although I know the value this article can represent you can actually be far more generic than you suggest.
You can write an SP that given the Source Table 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)

December 22, 2008 at 5:01 am

#916059
RE: Partitining an existing table

Hooman Shamsborhan (12/21/2008)
So what I've done so far is not going to help me at all?
I don't believe so... I believe you need to setup a new single partition 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)

December 22, 2008 at 4:50 am

#916057
RE: User Defined Function: order by won't work

GilaMonster (12/22/2008)
Jeff Moden (12/21/2008)
So, what is it, supposedly?
Spatial, xml, hierarchy, etc. The 'rich' data types that some bright spark in marketing thought meant SQL was evolving beyond a relational database....
--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)

December 22, 2008 at 4:46 am

#916054
RE: The Set-Based Limit

timothyawiseman (12/21/2008)
So when I have the time, I always think through the set based solution for SQL, but I have no hesitation to just jot out the procedural version one...
--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)

December 22, 2008 at 4:42 am

#916053
RE: Partitining an existing table

I believe you're looking for ALTER TABLE / SWITCH. There's a few caveats to it, but it's all covered in Books Online.
--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)

December 21, 2008 at 6:20 pm

#915918

Viewing 15 posts - 46,486 through 46,500 (of 59,101 total)