Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,256 through 24,270 (of 59,102 total)

RE: Trouble looping through a cursor

You've marked your own answer as the "worked for you" answer but it's not the correct answer. You don't need a cursor for this at all. The following...
--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)

March 2, 2014 at 11:02 am

#1693378
RE: subquery

adhamihab (3/2/2014)
how can i write this query using subquery and keeping the from as orders only.
USE northwind
SELECT max(OrderID) as OrderID
FROM Orders join Employees
on Orders.EmployeeID = Employees.EmployeeID
...
--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)

March 2, 2014 at 10:51 am

#1693376
RE: Performance troubles

Jake Shelton (3/2/2014)
Thank you Sean - again, is it worth changing the table structures? Also, will we need to point the sprocs to the new indices?
BTW - we 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)

March 2, 2014 at 9:35 am

#1693370
RE: Problem with date variables

What is the datatype of the DATE column?
--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)

March 1, 2014 at 7:39 pm

#1693352
RE: Trigger Usage

born2achieve (2/28/2014)
almost 25 columns i need to track and put it in audit table. any suggestions please
Post the CREATE TABLE statement for the audit table, please. I need 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)

March 1, 2014 at 7:33 pm

#1693351
RE: How to Get data from Table2 instead of Table 1?

manavairajan (3/1/2014)
Kindly help me my requirement?
I have two tables and similar column like (year, week, day, and shifts, Totalvalue)
Table 1 having full data of 2013 but Table2 few weeks 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)

March 1, 2014 at 7:28 pm

#1693350
RE: Regular Expression for Capital Characters in String

caippers (3/1/2014)
After messing with this all night I think I might be close but not sure
I believe what I have is to take the first character of the string ensure...
--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)

March 1, 2014 at 7:21 pm

#1693348
RE: Remove non alpha chars from a column

Yes, there are many other possible ways that use things like Tally Tables, cascading CTEs, etc, but... none of them are faster than what you have. This is 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)

March 1, 2014 at 2:38 pm

#1693342
RE: How to avoid using a cursor?

I believe that you shouldn't stop counting days just because of the latest location. I believe that you need to consider how long something has been at the latest...
--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)

February 28, 2014 at 10:18 pm

#1693309
RE: Capturing the Reason For Change for Type 2 changes

Lempster (2/27/2014)
Thanks for the replies folks. As JustMarie and EricEyster made opposing arguments, I guess the most important point is to be consistent!
Jeff, I don't see it as much 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)

February 28, 2014 at 8:55 pm

#1693308
RE: Help finding an old post

sqldriver (2/28/2014)
Jeff Moden (2/2/2014)
sqldriver (2/1/2014)
Yes, Jeff, now give me something to spend all this DBA money on that wasn't bottled and corked by a guy in a kilt.
BWAAA-HAAAA!!!!! 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)

February 28, 2014 at 8:48 pm

#1693307
RE: Audit who is logging in as sa

Lizzie (2/28/2014)
Thanks; I'll go back to doing a server-side trace then.
I agree with you about the password, but my manager is trying the diplomatic approach first, i.e. finding out...
--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)

February 28, 2014 at 7:43 am

#1693074
RE: exclude CTE values

pmadhavapeddi22 (2/27/2014)
...but I need everything in a single query.
Why?
--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)

February 28, 2014 at 7:08 am

#1693053
RE: Invalid Cursor Position - No Cursor in Use...

Thanks for the feedback. 🙂
--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)

February 27, 2014 at 4:01 pm

#1692915
RE: compressing read only file groups

muthyala_51 (2/27/2014)
i am not making the database into single user mode. I just leave the latest partition to read write and change the rest of the filegroups to read only....
--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)

February 27, 2014 at 3:47 pm

#1692913

Viewing 15 posts - 24,256 through 24,270 (of 59,102 total)