Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,571 through 48,585 (of 59,095 total)

RE: Importing CSV files without knowing destination schema

Lowell (8/27/2008)
here's my suggestion:
add a folder which contains all of your .csv files as a linked server.
a text linked server will show evert .txt file and every.csv file as 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 27, 2008 at 8:38 pm

#864100
RE: Trouble finding the max(units) OR max(revcode) from resultset

Sergiy (8/27/2008)
Why don't you make this query a view and call that view via "Import data -> database query" in Excel?
It will allow users to refresh data instantly with single...
--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 27, 2008 at 8:23 pm

#864097
RE: SQL Bulk Insert - using " to wrap text fields

nimmi.smith (8/27/2008)
Excuse my stupidity.
I see that in my last post the data file had a comma missing between a field.
Here is my file:
"RECORD_ID","SOURCE_ID","MEDIA","CREATED_BY","DATE_ORD","AMT","F_NAME","ORD_TIME"
"MLMORD20140571","7499582HG","GVAUTO","NANCY",20080616,100.00,"WALLY","02:21:08 PM"
"MLMORD20141711","7504735LS18","GVAUTO","BILL",20080616,100.00,"ROB","11:17:13 PM"
Here is my format...
--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 27, 2008 at 8:09 pm

#864094
RE: How can I calculate how many mussels have been shucked?

Heh... sorry Tomm... bet you've had "mo-den" enough of 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)

August 27, 2008 at 7:56 pm

#864089
RE: Cursor

Simon,
Now that Gus has replied, it's very good forum etiquette/good practice to let him know if it worked or not. If it didn't work, explain why with some good...
--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 27, 2008 at 7:14 pm

#864076
RE: Cursor

simon phoenix (8/26/2008)
Here i have scripted the table and the data such that it is rerunnable
Thanks for your suggestion, Jeff
Good... Here's one more suggestion... don't edit your posts on 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 27, 2008 at 7:10 pm

#864074
RE: Create and Populate Time Dimension

colin Robinson (4/20/2008)
i would also probably drop the table rather than truncate in this instance. You would then get the same Identity value for each date each time you ran...
--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 27, 2008 at 7:03 pm

#864072
RE: Create and Populate Time Dimension

colin Robinson (4/21/2008)
Thanks for the pointer,
That would make a decent interview question. and it least a truncate means you can retain permissions etc.
Thanks for the feedback... Correct... no need 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)

August 27, 2008 at 6:54 pm

#864069
RE: Converting integer to time

Tomm Carr (8/27/2008)
jofa (8/27/2008)
The expression
TimeNumber/10000*3600 + (TimeNumber%10000)/100*60 + TimeNumber%100
can be simplified to
TimeNumber - TimeNumber/100*40 - TimeNumber/10000*2400
Actually, the code was "60 * 60" not "3600", meaning 60 minutes per hour times...
--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 27, 2008 at 6:40 pm

#864066
RE: data archiving

Heh... no... trust me... I just got done reducing/archiving a 131 million row table to a 44 million row table using the 20k method I spoke of... on a 24/7...
--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 27, 2008 at 6:35 pm

#864064
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

rog pike (8/27/2008)
dphillips (8/26/2008)
All of this aside, however, was to show that one can pull a PIVOT without NULLS, and is only for specific situations.
I should be rich 😀
http://www.rac4sql.net
http://www.beyondsql.blogspot.com
Heh... You...
--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 27, 2008 at 6:31 pm

#864063
RE: How can I calculate how many mussels have been shucked?

rbarryyoung (8/26/2008)
Jeff, dude:
Jeff Moden (8/26/2008)
SELECT ROW_NUMBER() OVER (PARTITION BY ShiftID, TableID, StationID, EmployeeID, DATEADD(dd,DATEDIFF(dd,0,CounterDateTimeStamp),0)
...
--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 27, 2008 at 6:27 pm

#864060
RE: CdoNtsMail - What are the actual size limits to the "Body"

Update:
What a huge PITA SQL Server 2000's TEXT data type is...
You can create a sproc with a TEXT datatype variable as one of the parameters. Trouble is, you can't...
--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 27, 2008 at 8:27 am

#863767
RE: How can I calculate how many mussels have been shucked?

Tomm Carr (8/26/2008)
Here is my contribution:
Ummmm... nicely done, but be careful. If you take a look at the actual execution plan, there are two flow arrows of great concern......
--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 26, 2008 at 9:51 pm

#863484
RE: Cursor

Hi Simon,
You'd probably get a faster, better response if you put your data in a ready to use/test format. Take a look at the link in my signature line...
--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 26, 2008 at 7:32 pm

#863472

Viewing 15 posts - 48,571 through 48,585 (of 59,095 total)