Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,576 through 34,590 (of 59,099 total)

RE: want funstion

SUPER SQL STAR (3/16/2011)
hi,
i have data like
1234.45.1.46.678.1
i want a function which return when I Passesd 1 it will return the 1234
...
--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 16, 2011 at 8:04 pm

#1299767
RE: T-SQL Help

MattW2010 (3/16/2011)
Hi Jeff,
I don't think it matters. That column was more for illustration to help make clear the issue. The numbered column provided was sufficient for the business...
--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 16, 2011 at 7:43 pm

#1299763
RE: T-SQL Help

No, you're correct. That's the one I was replying to. Damned spammers. I wish I could reverse the tables on them. I'll report 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)

March 16, 2011 at 7:41 pm

#1299762
RE: Split Comma Seperate Column Problem

Ok... I'm pretty much ignorant of SSIS. My question at this point is why couldn't one of the common split functions written in T-SQL work here for 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)

March 16, 2011 at 7:32 pm

#1299759
RE: Split Comma Seperate Column Problem

Phil Parkin (3/16/2011)
Jeff
FINDSTRING is a built-in SSIS function, see here.
Ah! Thanks, Phil... That's what I get when I post on a forum for something I don't use. :blush: ...
--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 16, 2011 at 7:29 pm

#1299756
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

DZN (3/15/2011)
Great Store Proc !!!
It will help me a lot.
Now, I have to access a shared drive.... not a local drive and (of course) this is not working....
Any help would...
--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 16, 2011 at 7:25 pm

#1299755
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

Khades (11/5/2010)
I have created an account on these forums just to let you know how awesome you are Jeff.
Thank you for the code, not only does it work great, but...
--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 16, 2011 at 7:18 pm

#1299754
RE: Group by

Before I answer, I don't know what you specifically mean by "overloading" in this case. Do you simply mean using something for which it was not intended? Please...
--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 16, 2011 at 7:06 pm

#1299751
RE: Are the posted questions getting worse?

Craig Farrell (3/16/2011)
GilaMonster (3/16/2011)
I object, I'm a model of good behaviour
well, compared to others on that list anyway...
Isn't that like saying you're a 'nice' barbarian because you only rape and...
--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 16, 2011 at 5:24 pm

#1299729
RE: Identity column gernerating non unique value

kotnala_manish (3/15/2011)
I had created a sp which is creating a non unique value for n concuurent user using this table.Might be concurrency issue what it might be.
If you were 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 16, 2011 at 6:26 am

#1299306
RE: Split Comma Seperate Column Problem

jscot91,
We need to know something to wrap it up with code, though. What is the code for FINDSTRING?
We're just trying to help here.
--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 16, 2011 at 6:09 am

#1299300
RE: Split Comma Seperate Column Problem

Gurulakshmanaprabhu Gurusamy (3/15/2011)
Hi,
Data of this kind could be broke down using split function available in VB.Net.Hence instead of using derived column transformation with substring function , same result would be...
--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 16, 2011 at 6:06 am

#1299298
RE: T-SQL Help

The most recent code offered by Wayne S works exactly the way you want it to. Try it.
However, the problem remains... what if you have more than 26 groups...
--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 16, 2011 at 6:05 am

#1299297
RE: How To Work with Files based on file name patterns

Heh... and they say xp_CmdShell is a risk. 🙂
--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 16, 2011 at 6:02 am

#1299295
RE: Locked tables clarification

pwalter83 (3/14/2011)
Hi,
Does somesone know if a table is been updated every 5 minutes using an SSIS job…i.e. data being inserted, updated or deleted and someone tries to access 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)

March 15, 2011 at 10:01 pm

#1299204

Viewing 15 posts - 34,576 through 34,590 (of 59,099 total)