Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,721 through 27,735 (of 59,101 total)

RE: Create Table and Bulk Insert

I guess I can't help on the error because the stored proc works fine for me. Your going to have to breakdown the proc by creating some variables 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)

December 30, 2012 at 10:08 pm

#1572425
RE: Create Table and Bulk Insert

Ok... I decided to do the EQ file imports as a stored procedure for you. The hard stuff (the imports) have been done. As usual, the details are...
--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)

December 29, 2012 at 11:51 pm

#1572381
RE: Create Table and Bulk Insert

urso47 (12/29/2012)
Hi guys,
I have been struggling myself for the last two days but I couldn't make it work. Could anyone help me on this statement?
-- TABLE EQUIT
USE TEMPDB
GO
CREATE TABLE Equit
(
cGroupIDINT,
cGroupIDBillableINT,
cGroupNameVARCHAR(MAX),
cGroupDescriptionVARCHAR(MAX),
cRowIDINT,
cRowNameVARCHAR(MAX),
cRowDescriptionVARCHAR(MAX),
cTransactDateSMALLDATETIME,
cTransactTypeVARCHAR(MAX),
cChargeAccountIDVARCHAR(MAX),
cChargeAccountTypeVARCHAR(MAX),
cUserWhoPrintedVARCHAR(MAX),
cDocumentNameVARCHAR(MAX),
cUnitsINT,
cDocumentIDVARCHAR(MAX),
cDeviceIPVARCHAR(MAX),
cDevModelVARCHAR(MAX),
cDevManufVARCHAR(MAX),
cDurationVARCHAR(MAX),
cDestinationVARCHAR(MAX),
cFullNameVARCHAR(MAX),
cPrimaryPINVARCHAR(MAX),
cWorkstationVARCHAR(MAX),
cAmountINT,
JobPropertiesVARCHAR(MAX),
cAltCostINT,
cDepartmentVARCHAR(MAX),
cBillableVARCHAR(MAX),
cAlternatePinVARCHAR(MAX)
)
GO
--...
--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)

December 29, 2012 at 9:36 pm

#1572376
RE: IN CORRECT SYNTEX

JeffRush (12/29/2012)
and that's what I get for reading too quickly.
Actually, the OP should look your post over again, and again, and again. Too many people make the mistake of...
--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)

December 29, 2012 at 5:55 pm

#1572369
RE: Analyst seeking wisdoms while learning the platform

Sean Lange (12/28/2012)
I have no idea what PluralSight is ...
Heh... it's when your cataracts make you see double out of one eye. Younger folks can experience the wonder of...
--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)

December 29, 2012 at 5:41 pm

#1572367
RE: IN CORRECT SYNTEX

lonhanner (12/29/2012)
UPDATE TRP_STATS
SET TRIP_ID = TRIP[font="Arial Black"], <----<<<< MUST LOOK EYE![/font] 😛
FROM TRP_STATS JOIN TRP_DETAILS
ON TRP_STATS.TRP = TRP_DETAILS.TRP;
Msg 156, Level 15, State 1, Line 3
Incorrect syntax...
--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)

December 29, 2012 at 5:37 pm

#1572366
RE: Keeping all three environment(Dev,Stag,Prod) in sync

Wouldn't truncating a table in QA violate the idea of keeping all 3 environments in sync? Presumably, keeping all 3 enviroments in sync really means keeping Dev and Staging...
--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)

December 29, 2012 at 11:17 am

#1572349
RE: Time - Adding minutes and seconds

dwain.c (12/25/2012)
Jeff Moden (12/25/2012)
Merry Christmas Dwain.
Let me see. Christmas morning where you are and here you are posting on the SSC forum.
You must want that 32,000th post pretty bad!
Nah......
--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)

December 29, 2012 at 10:42 am

#1572344
RE: Why Allow Heaps at All?

GilaMonster (12/29/2012)
You may be interested to know that SQL Azure (or whatever it's called this week), does not allow heaps.
Understood. Found that out in the very early documentation on...
--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)

December 29, 2012 at 10:14 am

#1572340
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

buyme43 (12/28/2012)
input this URL:
***Url removed ***
you can find many cheap and high stuff
Believe you will love it.
WE ACCEPT CREDIT CARD /WESTERN UNION PAYMENT
YOU MUST NOT MISS IT!!!
Speaking of "cheap", SPAM...
--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)

December 29, 2012 at 10:05 am

#1572339
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Bruce W Cassidy (12/28/2012)
Jeff Moden (12/28/2012)
If you look at the execution plan, it doesn't actually use the "same list". CTEs have some wonderful advantages but they also have 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)

December 29, 2012 at 10:02 am

#1572337
RE: Hardware investment - I need to talk to someone knowledgeable and with no intere$t

Speaking of performance... the following is admittedly a bit long but well worth the read (IMHO).
At one company I worked at, we had a 500GB set of databases that made...
--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)

December 28, 2012 at 11:43 pm

#1572302
RE: how to fetch records from multiple tables

manibad (12/27/2012)
i have Demo,elections and electionshist tables where i should neglect the pepole who have status='t' from demo table and for those who are not neglected i should check whether...
--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)

December 28, 2012 at 10:33 pm

#1572299
RE: how to fetch records from multiple tables

CELKO (12/28/2012)
{ISO-11179 rules for data element names} Which can be downloaded where?
http://metadata-standards.org/Document-library/Documents-by-number/WG2-N1551-N1600/WG2N1580_WD_11179-5_Ed3.pdf
But you will sorry. Reading standards is like reading the law; it took me two years on...
--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)

December 28, 2012 at 10:18 pm

#1572297
RE: how to fetch records from multiple tables

Sean Lange (12/28/2012)
First of all, SSN have and will be reused. When people die their SSN gets recycled into the available pool.
While it is true that a person can...
--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)

December 28, 2012 at 10:04 pm

#1572296

Viewing 15 posts - 27,721 through 27,735 (of 59,101 total)