Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,596 through 47,610 (of 59,099 total)

RE: Updating Values Without Cursor

Parul Sharma (10/24/2008)
a big thank you to each one of you guys. All the solution provided are working for me. Only thing I have to check is to find the...
--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)

October 25, 2008 at 5:01 pm

#889688
RE: Updating Values Without Cursor

AnzioBake (10/24/2008)
either one of the following does what you are asking. The Second query is marginally faster...
Both methods use a "triangular join" which, because of the way it's used,...
--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)

October 25, 2008 at 4:59 pm

#889687
RE: excluding nulls from a table

I think it would be best that if the function receives a NULL, it should return a NULL. NULL has the special meaning of "unknown" and changing it to...
--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)

October 25, 2008 at 4:38 pm

#889684
RE: help with datediff and datepart in sql express

Try this...
SELECT COUNT(*)
FROM dbo.RentalHistory
WHERE FromDate >= DATEADD(mm,DATEDIFF(mm,0,'20080901'),0)
AND ToDate < DATEADD(mm,DATEDIFF(mm,0,'20080901')+1,0)
... and there's only 4 items 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)

October 25, 2008 at 4:18 pm

#889683
RE: SQL Server 2000

Greg Snidow (10/25/2008)
Ahh, what relief. I get it, the trigger would fire when it updates the field in question, which would cause it to fire again. Never thought...
--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)

October 25, 2008 at 4:01 pm

#889681
RE: SQL Server 2000

GilaMonster (10/25/2008)
Jeff Moden (10/21/2008)
Shifting gears a bit here... What a PITA.... I hate it when they do stuff like that... In 2k, the default was OFF, in 2k5, the default...
--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)

October 25, 2008 at 3:59 pm

#889680
RE: Count of matching data in two tables

1mwalsh1 (10/25/2008)
Hi all,
Working with SQL Server 2008 Express, I am trying to match user answers to correct answers and tally up the score. Tables are as follows;
Answers
GameNo
Ans1
Ans2
Ans2... etc.
PlayerAnswers
GameNo
Player
Ans1
Ans2
Ans3... ...
--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)

October 25, 2008 at 11:18 am

#889658
RE: Count of matching data in two tables

Jerry Hung (10/25/2008)
See forum best practice
http://extras.sqlservercentral.com/prettifier/prettifier.aspx
Heck... make it as pretty as you want... that's only part of the "best practice". What is a "best practice", though, is actually posting...
--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)

October 25, 2008 at 11:16 am

#889657
RE: SQL-Server 2005: Change Ordinal Column Position

baumgaertner (3/31/2008)
Thank you for you answer, Karl.
But I do not want to rename the table and then insert the data to the new table.
When you have big tables this approach...
--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)

October 25, 2008 at 11:05 am

#889656
RE: counters

It sounds like you're passing each stage as a parameter and that you're looping through each stage. It sounds like each stage may be different enough where you are...
--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)

October 25, 2008 at 9:54 am

#889650
RE: How to update a null column at very first row creation

First, what do you get when you run the following?
SELECT * FROM tabUserInfo
Where (UserID Is Null or UserID <= 0)
Now, what do...
--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)

October 25, 2008 at 9:48 am

#889649
RE: Indexing large tables

If the table is that large, consider splitting it into smaller tables based on a PK and then build a partitioned view to put it all back together again. ...
--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)

October 25, 2008 at 9:38 am

#889648
RE: convert a varchar(4000) to a int !?

smunson (10/24/2008)
It's good to have a working solution, but the performance of a WHILE loop construct for splitting strings could have problems with performance when dealing with a large number...
--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)

October 25, 2008 at 9:31 am

#889647
RE: Absolutely (Not?)

I guess I'd have to argue that developers are sometimes even more arrogant than the DBA. What makes a GUI developer think (s)he knows something about how to store,...
--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)

October 25, 2008 at 9:17 am

#889645
RE: Need Help with Query

Doing it the old fashioned way using a "Derived table" instead of a CTE...
SELECT orig.AgentID, orig.AgentType
FROM #a orig
INNER JOIN
...
--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)

October 25, 2008 at 8:43 am

#889640

Viewing 15 posts - 47,596 through 47,610 (of 59,099 total)