Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,826 through 48,840 (of 59,099 total)

RE: Store word doc/image on sql server

Like I said, I've never done it before and your guess is as good as mine... maybe something like...
--===== Write text line to file
CREATE PROCEDURE sp_AppendToFile(@FileName varchar(255), @Text1 varbinary(MAX)) AS
DECLARE...
--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 11, 2008 at 10:12 pm

#856481
RE: Need assistance with a query

nwinningham (8/11/2008)
How can I get this information to come back in one row?
Thomas Hainey 999999 NULL ...
--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 11, 2008 at 9:01 pm

#856463
RE: Is there a shortage of database jobs or is there a shortage of database DBAs or developers

The answer to the infamous "chicken or the egg" problem is... the egg. A chicken can only be a chicken... it is possible for an egg to become something...
--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 11, 2008 at 8:31 pm

#856462
RE: Millions of records with no index! Query kills Transaction Log

I haven't read all the posts on this thread, but I have to ask... why do you want to return 200k+ rows for anything? :blink:
--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 11, 2008 at 8:19 pm

#856459
RE: Temporary Tables

I agree, partially... Temp tables shouldn't be used just because they can be. But, remember that a "derived table" and CTEs create "working" tables which appear in TempDB just...
--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 11, 2008 at 8:14 pm

#856458
RE: Store word doc/image on sql server

virgo (8/11/2008)
Hi jeff,
That was informative...is ther a way using sql query to retrive the doc,image,pdf from the sql server tables to local computer with out using any ADO or front...
--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 11, 2008 at 7:33 pm

#856450
RE: Trigger Not Executed even if record is inserted or Updated

smunson (8/11/2008)
Jeff,
He appears to just want a copy of the insert, so would replication meet his need, or would that cause problems on speed of "Updation" ?
Steve
(aka smunson)
:):):)
I think replication...
--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 11, 2008 at 7:25 pm

#856449
RE: Bill Baker

bakerbill (8/11/2008)
Bill will use any method to hurt whoever brings up the painful truth.
Maybe so... but you're pretty good at throwing people under the bus yourself. 😛
It sounds like...
--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 11, 2008 at 7:19 pm

#856446
RE: BCP Remote Files

Angel Miranda Nieto (8/11/2008)
thank everyone, my problem is solved, we are in contact
Two way street here, Angel... tell us how you solved your problem, 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)

August 11, 2008 at 7:12 pm

#856445
RE: SQL Year and Week numbers

jennyor (8/11/2008)
I'm trying to write an update command in sql to take the weekyear portion of a serial # and convert it back to a date by extracting the week...
--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 11, 2008 at 7:10 pm

#856443
RE: Store word doc/image on sql server

THAT, my friend, it why I recommend only storing the file name and not the file itself. 😛
You either have to capture the info in a variable in a...
--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 11, 2008 at 6:46 pm

#856437
RE: Find distinct special characters in column

shamshad.ali (8/11/2008)
I need to list them down. if there is a way. also how should i exclude space" " and dot"." from [a-z0-9]
Thanks all for help...
Shamshad Ali.
Shamshad... have you tried...
--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 11, 2008 at 5:59 pm

#856434
RE: How to ignore the comma seperator inside ","

Like I said... Books Online... lookup BCP Format file. I can't help if you don't even know what I'm talking 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)

August 11, 2008 at 5:58 pm

#856433
RE: Get duplicate range - How to

dwither_07 (8/11/2008)
Hmm..let me trace on how did I come up with the said result, I'll just use script number 6 (Sixth Data Scenario) since it has less data.
--=====...
--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 11, 2008 at 5:55 pm

#856432
RE: Uncommon Table Expressions

Good article so far as the format, readability, and revelation go. The thing I'm having a problem with is the use of recursion of any kind to create a...
--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 11, 2008 at 5:40 pm

#856429

Viewing 15 posts - 48,826 through 48,840 (of 59,099 total)