Viewing 15 posts - 61 through 75 (of 81 total)
Also the XML format file.
<?xml version="1.0"?>
<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
<FIELD ID="1" xsi:type="CharTerm" TERMINATOR="\t" MAX_LENGTH="255" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="2" xsi:type="CharTerm" TERMINATOR="\t" MAX_LENGTH="255" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="3" xsi:type="CharTerm" TERMINATOR="\t" MAX_LENGTH="255" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
...
February 5, 2013 at 9:59 am
Following is some test data.
"CUSTMR_NBR","ORCL_NBR","CUST_NBR","BLNG_CD","BSNS_LN","MKT","TRTRY","AREA","PRNT_NM","MAIN_NM","LOW_NM","CUST_NM","STAT","SYS","GUD","MON_NBR","YR","RVNU","QTY"
"15.ZB.AD095K","04119.0AD09K","AD09K","9333","PROD1","BOSTON","EAST","CENTRAL","CUST_1","cust1","CUST 1 INC.","CUST 1 INC.","A","XYZ","07XYZ8782",5,2012,0,5923
"15.ZB.AD41231","04119.0AD431","AD431","890","PROD3","NEW YORK","EAST","CENTRAL","CUST_2","NONE","CUST 2 INC.","CUST 2 INC.","A","XYZ","0023XYZ56",5,2012,139.3872,341
"15.ZU.AF1317","04314.0AF117","AF117","220","PROD4","AUSTIN","WEST","WESTERN","CUST_33","CUST33","CUST 33 INC.","CUST 33 INC.","A","ABC","08216ABC1",5,2012,0,359
February 5, 2013 at 9:55 am
Thanks you and sorry for delay in acknowledging.
I used cross tab to do what I needed.
November 15, 2012 at 11:22 am
I went around by adding the following:
SET ARITHABORT OFF
SET ANSI_WARNINGS OFF
November 9, 2012 at 1:21 am
I have another query that does division month over month. I do a case there to check if either numerator or denominator is zero, then zero else division. But the...
November 8, 2012 at 7:31 pm
Thanks SSCarpal Tunnel, I used the first option as you suggested.
Greatly appreciate your help.
November 6, 2012 at 9:48 am
Sorry but I could not make it to work this way.
Not sure what I am doing wrong.
November 5, 2012 at 3:26 pm
Thank you GilaMonster, this is very informative.
September 23, 2012 at 6:55 am
Thank you GilaMonster, this is very informative. Greatly appreciate it.
September 23, 2012 at 6:27 am
Thank you I will reconfigure the DBs. I have to upgrade from SQL Express to SQL Standard next week, so that's when I will do it.
September 23, 2012 at 6:26 am
Can you please briefly explain why the log file should be on the different machine?
As I said to someone else, this is under IT radar, running on Windows...
September 22, 2012 at 8:49 am
Thanks much, the one thing that I have been doing is periodically restore the DB and make sure it works OK.
I have a bunch of ASP.NETT t code as the...
September 22, 2012 at 8:47 am
Thank you very much. I greatly appreciate it.
September 22, 2012 at 5:25 am
I just created an SP to delete the temp table.
August 12, 2012 at 6:11 am
Viewing 15 posts - 61 through 75 (of 81 total)