Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,956 through 35,970 (of 59,102 total)

RE: Dynamic SQL issue

Heh... not to worry, Lutz. You've seen the mess I can make of things if I PBC (Post Before Coffee). 😀
--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)

November 24, 2010 at 2:38 pm

#1255347
RE: Logging by TSQL

Ray K (11/23/2010)
Please do NOT waste people's time by cross-posting!!!
All: do not respond to this post; please use http://www.sqlservercentral.com/Forums/Topic1025402-391-1.aspx.
Whoa! No need to yell, Ray. And considering the OP...
--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)

November 23, 2010 at 10:39 pm

#1254891
RE: Need help with some code..

WayneS (11/22/2010)
jguerra2 (11/22/2010)
Hey thanks alot. Havent learned and thing about Cross Tabs and Pivot Tables. I am checking you article out now 🙂
Thanks for the code. I will try...
--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)

November 23, 2010 at 10:36 pm

#1254890
RE: Big table 50MB containing just 1000 records ( a few small fields each record)

Iulian -207023 (11/23/2010)
I am sorry Chris I don't have the table structure at hand.
Thanks,
Iulian
Heh... you know how much the table is using for space and can't generate the script...
--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)

November 23, 2010 at 10:28 pm

#1254889
RE: Need help building a query.

Ram2002 (11/23/2010)
Hi Thanx for Reply...
Yes based on Emp_ID and start date. It is like the row follows with end date or if end date not there then next row will...
--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)

November 23, 2010 at 10:25 pm

#1254888
RE: cross apply

kevin4u06 (11/23/2010)
I dont want to join the function and the table ...i want to pass data in the column from the table as a variable to the function
Cross Apply is...
--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)

November 23, 2010 at 10:22 pm

#1254885
RE: Dynamic SQL issue

LutzM (11/23/2010)
What's the specific reason for you not to use global temp tables (##table)
Concurrency and logical separation of data between concurrent runs because all sprocs that use it see 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)

November 23, 2010 at 10:17 pm

#1254884
RE: Dynamic query in a function

sumit.agrawal (11/23/2010)
this proc should store the output in temp table.. then create a function which will get the values from the temp table....
Just to be clear, one can no more...
--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)

November 23, 2010 at 7:58 pm

#1254864
RE: Dynamic query in a function

S_Kumar_S (11/22/2010)
Well Jeff, I didn't ask if we can execute a dynamic sql from function, I asked if there is a work around for it. i knew there is no...
--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)

November 23, 2010 at 7:54 pm

#1254863
RE: Work around for SQL server performance issue

Gangadhara MS (11/21/2010)
Dear Experts,
We are having performance issues on production server.
The following task i have carried out and i need your suggestion further.
1.I have used profiler to trace 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)

November 23, 2010 at 7:27 pm

#1254858
RE: how to get consecutive records grouped

@Justin,
Are you all set now?
--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)

November 23, 2010 at 7:42 am

#1254463
RE: how to get consecutive records grouped

mister.magoo (11/23/2010)
This sounds like it could be solved by the "Quirky Update" method to me - as you need to compare each row to the previous row.
See Jeff's article about...
--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)

November 23, 2010 at 7:41 am

#1254462
RE: how to get consecutive records grouped

Justin,
Sachin's code almost did it. It just needed a push over the edge to get it where you wanted it. Here's the push...
WITH
cteGroups AS
(
SELECT dt,
...
--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)

November 22, 2010 at 11:41 pm

#1254198
RE: how to get consecutive records grouped

Sachin Nandanwar (11/22/2010)
It's quite difficult to give a solution without actually looking at the records which are causing the problem.
What on Earth are you talking about? The OP gave...
--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)

November 22, 2010 at 11:37 pm

#1254196
RE: need help with loading a string

WayneS (11/22/2010)
kevin4u06 (11/22/2010)
There is one more added complexity , in some recordds the state has for example
Arizona
New Jersy
instead of just their abbreviation
The spaces in this are going to complicate things...
--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)

November 22, 2010 at 8:01 pm

#1254156

Viewing 15 posts - 35,956 through 35,970 (of 59,102 total)