Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,971 through 32,985 (of 59,099 total)

RE: Add a calculated percentage in a report

@Josep,
Do you always want to show Jan thru Dec or do you really want to show comparisons for the previous 12 months? For example on the previous 12 months......
--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)

August 7, 2011 at 10:11 am

#1364893
RE: Search & pattern matching within text/html values

Could you attach a text document containing a couple of lines of the "rich text/html formatted data", please? We also need to know what the maximum number of characters...
--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)

August 7, 2011 at 10:06 am

#1364892
RE: while condition or loop

sdgray01 (8/7/2011)
Thank you for the response, but basically I just need it to run that code 3 times, each time it will look at the table, find the lastest year...
--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)

August 7, 2011 at 9:57 am

#1364891
RE: Splitting City and State with variable formats

trstringer (8/6/2011)
Nobody?! I had to further tweak that code because it was moreso a SELECTed column in an INSERT VALUES clause. But that's the gyst of it.
Heh... you've...
--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)

August 7, 2011 at 9:16 am

#1364885
RE: BCP command to import data from txt file (Pipe as Field terminator)into SQL Table.

anand_vanam (8/6/2011)
Hi all
I am facing hard time in configuring the BCP command to to import data from txt file (Pipe as Field terminator)into SQL Table.
As the TAB is 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)

August 6, 2011 at 2:38 pm

#1364824
RE: xp's in SQL2000

The clean version is "Can't Remember Stuff". 😉
--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)

August 6, 2011 at 2:32 pm

#1364822
RE: Using SSIS

ankit.shukla1105 (8/6/2011)
It would help you if you could post zombie DDLs for your tables. Here it seems that the input table does not contain the UserID. So if you need...
--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)

August 6, 2011 at 2:25 pm

#1364820
RE: query datetime column

shank-130731 (8/3/2011)
Got to be something simple I'm not seeing here. Trying to query a datetime column.
Example date: 2011-01-02 00:00:00.000
SET @ETD = '%' --works as expected, all rows
SET @ETD = ''...
--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)

August 6, 2011 at 2:21 pm

#1364819
RE: spliting columns data

Please see the first link in my signature line below for how to get quicker and coded answers for future posts.
This is the way you should post data for problems...
--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)

August 6, 2011 at 2:11 pm

#1364818
RE: How to Become MVP?

gah (8/6/2011)
From the MS site...(nothing more than Gail has already stated)
https://mvp.support.microsoft.com/gp/mvpbecoming
List of SQL MVPs.....dbl click on any name to give an idea of the committment these people make to 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)

August 6, 2011 at 1:25 pm

#1364814
RE: nvarchar(max)

I understand what you're trying to do and this is an easy thing to do, Sean. If you would post the data in a readily consumable format (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)

August 6, 2011 at 1:22 pm

#1364812
RE: How to set length for a numeric column and datetime in SSIS?

BCP with a BCP formatfile would do this easily and with great speed. You could also create a VIEW of the data were the column datatypes are CHAR(2), CHAR(6),...
--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)

August 6, 2011 at 1:13 pm

#1364810
RE: Cleaning Duplicate Data

I guess my first three recommendations would be...
1. Stop using a table variable for this. The data is way too big.
2. Partition the target tables by date.
3....
--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)

August 6, 2011 at 1:05 pm

#1364807
RE: find the position of an alpha numberic

It doesn't and that wasn't a part of what the OP asked for.
i'm trying to remove all non alphnumberic characters [font="Arial Black"]at the front of the string[/font]
--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)

August 6, 2011 at 12:14 pm

#1364796
RE: find the position of an alpha numberic

SELECT SUBSTRING(@String,PATINDEX('%[A-Z0-9]%',@String),100)
--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)

August 5, 2011 at 10:07 pm

#1364734

Viewing 15 posts - 32,971 through 32,985 (of 59,099 total)