Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,026 through 44,040 (of 59,063 total)

RE: Problems using Bulk insert with a CSV file that has inconsistent quotes

WayneS (4/23/2009)
Leave it to Jeff to find another way with less code.:rolleyes:
Heh... I'm just lazy... I hate typing lots of code.
I learned how to do this just for the occasional...
--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)

April 24, 2009 at 10:36 am

#983677
RE: how to compare values in t-sql 2005

I'm thinking that once you can identify things that have more than 1 consecutive 5, you could probably write code to do anything you wanted. Here's the code that...
--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)

April 23, 2009 at 9:51 pm

#983367
RE: XACT_ABORT ON

RJ (4/23/2009)
whether XACT_ABORT ON can be used in a stored procedure where you never use begin tran commit or rollback.
i have 2 insert, 1 updates, 1 delete in a stored...
--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)

April 23, 2009 at 7:49 pm

#983356
RE: insert record

doran_doran (4/22/2009)
That's funny. LOL.
How come people have all the time to comment on how to post?
Who really cares as long as it's not all that offensive?
I need some...
--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)

April 23, 2009 at 7:24 pm

#983350
RE: Finding the best way..

I sense extreme danger... someone tell me why you'd truncate a perfectly good archive table.
--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)

April 23, 2009 at 7:18 pm

#983348
RE: Problems using Bulk insert with a CSV file that has inconsistent quotes

Actually.... let's just say the data from the original post was stored on the server in C:\Temp and the filename was called SomeFile.txt
Then, you can do a little SQL prestidigitation...
--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)

April 23, 2009 at 7:01 pm

#983345
RE: Row Size

mithun.gite (4/23/2009)
Clear with the Max row size, it wont allow char to grow more than 8060 and varchar would reside in row upto 8060 and after that off tha page...
thanks...
--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)

April 23, 2009 at 6:09 pm

#983339
RE: Crosstab type report -- Horizontal Summray

Joseph,
Did you ever get this figured out?
--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)

April 23, 2009 at 5:40 pm

#983329
RE: Pivot tha data in this format

Thanks for the feedback. I always wonder if some of these suggestions get through or not.
--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)

April 23, 2009 at 5:32 pm

#983327
RE: Are the posted questions getting worse?

GSquared (4/23/2009)
"Bait and Switch".
BWAA-HAA!!! Energy drink my foot! It would be a heck of a name for a marriage counseling service. 😛
--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)

April 23, 2009 at 5:04 pm

#983322
RE: Are the posted questions getting worse?

Adi Cohn (4/23/2009)
Since we are sharing some bad code stories, I have to tell you the true and sad story from few years ago. At that time I was...
--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)

April 23, 2009 at 4:57 pm

#983319
RE: Are the posted questions getting worse?

Alvin Ramard (4/23/2009)
GSquared (4/23/2009)
Laughable SQL would be a great topic. Probably quite popular, and potentially quite valuable.
Could have examples of some of the really bad cursor solutions as one...
--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)

April 23, 2009 at 4:51 pm

#983315
RE: Are the posted questions getting worse?

Greg Edwards (4/23/2009)
Bob Hovious (4/23/2009)
My topic would more likely be... Laughable SQL
Why isn't there an SQL equivalent to Iron Chef? That would make for an interesting competition. ...
--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)

April 23, 2009 at 4:46 pm

#983313
RE: Which country is best for Outsourcing?

Chirag,
Heh... man, I can only imagine some of the legacy code you must get from some folks. That's gotta be a nightmare especially when there's no documentation anywhere especially...
--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)

April 23, 2009 at 3:01 pm

#983283
RE: Which country is best for Outsourcing?

umar iqbal (4/23/2009)
I have on solution for all this and don't laugh. lets bring dollar value to NULL
Heh... I thought it was already there. 😀
--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)

April 23, 2009 at 2:50 pm

#983276

Viewing 15 posts - 44,026 through 44,040 (of 59,063 total)