Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,046 through 30,060 (of 59,101 total)

RE: T-SQL took more than 45 minutes, and it still Executing query

CELKO (5/12/2012)
Code should be in Standard SQL as much as possible and not local dialect.
Heh... and you shouldn't use any of the higher level functions of scientific calculators because someone...
--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)

May 13, 2012 at 2:05 pm

#1486888
RE: joins with 3 tables

selvakumar.sms (5/13/2012)
please guide me!!! ur answer very helpful for me!!! i am begineer, masters please help me!!
In that case, please click on the following for some guidance that will easily...
--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)

May 13, 2012 at 1:53 pm

#1486887
RE: SSRS Chart issue..Bars dont show up but data does

debrucer1 (5/13/2012)
it was my experience two weeks ago, when Report Server was only displaying down to the orange/blue line, no admin controls, no menus. Restarting the services corrected the first...
--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)

May 13, 2012 at 1:01 pm

#1486884
RE: difference between union all and full outer join

selvakumar.sms (5/13/2012)
dear Jeff
i dont know how to use books online effectively,so ly i am keep on asking simple question in this forum.
...
--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)

May 13, 2012 at 12:56 pm

#1486883
RE: change dbo of database

You can also do this by right-clicking on the database, selecting "properties", and then follow your nose.
--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)

May 13, 2012 at 10:33 am

#1486875
RE: SSRS Chart issue..Bars dont show up but data does

BWAAA-HAAAA!!!! If you have to restart the services and/or the server just to get the bars of a chart to show up, then there's a serious flaw in SSRS!...
--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)

May 13, 2012 at 10:31 am

#1486872
RE: select from multiple comma separated string

Like this...
SELECT f1.ItemNumber,
Str1 = f1.Item,
Str2 = f2.Item,
...
--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)

May 13, 2012 at 10:23 am

#1486871
RE: difference between union all and full outer join

You've asked a couple of such questions and I'm concerned for you. Do you know what Books Online is and how to use it?
--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)

May 13, 2012 at 10:13 am

#1486868
RE: RegEx for DBAs

David.Poole (5/13/2012)
Jeff Moden (5/12/2012)
SPAM reported.
Time for a spot of RegEx pattern matching:hehe:
Only if it doesn't take too long. 😛
--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)

May 13, 2012 at 10:11 am

#1486867
RE: Help me understand vendor provide calendar table

If you know the table name, why not just list the first 60 rows of data and the DDL to start with?
--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)

May 13, 2012 at 10:10 am

#1486866
RE: Columns to Rows

I don't know if it's possible for you to make changes to the tables or not, but you might want to consider normalizing them a bit. Having to unpivot...
--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)

May 13, 2012 at 10:05 am

#1486864
RE: usage of joins

selvakumar.sms (5/12/2012)
Every experts was once a beginners!!! every pros was once an amateur
Just a suggestion... While what you say (as quotes above) may be true, the difference between high...
--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)

May 13, 2012 at 9:57 am

#1486862
RE: trimming a text string

Just reread the problem again. If you really want to preserve the 2nd backslash, just remove the STUFF from the code above. Like this.
SELECT d.ProdPath
...
--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)

May 13, 2012 at 9:42 am

#1486860
RE: trimming a text string

Ah... I just kind of assumed what you wanted if there were no second backslash. A simple addition to the code above will return the blank you want for...
--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)

May 13, 2012 at 9:38 am

#1486858
RE: trimming a text string

polkadot (5/13/2012)
you are correct. Thanks Jeff. It's still totally relevant (ie. not just an exercise). :kiss:
Perhaps this, then.
--===== Create some test data
SELECT d.ProdPath
INTO #TestTable
...
--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)

May 13, 2012 at 9:30 am

#1486857

Viewing 15 posts - 30,046 through 30,060 (of 59,101 total)