Viewing 15 posts - 5,641 through 5,655 (of 5,678 total)
Personally, I'd bulk insert into a staging table and then run on my insert to the real one a REPLACE( Column, ',', '') statement.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 7, 2010 at 2:48 pm
I'm sorry, but without having the data and the database in front of me to help figure out what exactly is going on there, I'm afraid I'm at a loss....
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 7, 2010 at 12:52 pm
Try this (note the two left joins now)
SELECT
RM20101.DOCDATE AS bldat,
RM20101.POSTDATE,
RM20101.DOCNUMBR,
RM00101.CUSTNAME,
RM20101.CURNCYID,
RM20101.ORTRXAMT,
CASE WHEN RM20101.ORTRXAMT = RM20101.CURTRXAM THEN 0 ELSE RM20101.CURTRXAM END AS 'Remaining Amt',
RM20101.ORTRXAMT,
RM20101.CUSTNMBR,
SOP10106.USRTAB09...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 7, 2010 at 12:45 pm
Well, since we only have psuedocode from you, you'll have to include our results and translate it into whatever you've got.
Basically, for the above calculations:
UPDATE
...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 3, 2010 at 1:00 pm
This is borrowed from:
http://www.eggheadcafe.com/software/aspnet/30488923/script-which-will-shrink-all-databases.aspx
EXEC sp_MSForEachDB @Command1 = N'DBCC SHRINKDATABASE (?, 10)', @replacechar = '?'"
There's some other notes and scripts there that may be more in line with what you're...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 3, 2010 at 12:50 pm
NJ-DBA (9/3/2010)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 3, 2010 at 12:28 pm
Looks like you've just got nasty data issues. I would start with going after the knowns instead of the unknowns. Do a replace on ," with ,| then...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 3, 2010 at 12:24 pm
Hey Jatrix,
Wayne will swing by I hope with his link snippet to one of the cleanest functions I've seen regarding separating delimited lists, but in your case, I think the...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 3, 2010 at 12:15 pm
I wouldn't worry as much about values to the right of the decimal, it should round in. It's the ones to the left that'll cause the error. Somehow...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 3, 2010 at 11:17 am
idea 1: Does the proc return multiple rows when the report does?
Need to see the proc code for any others.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 2, 2010 at 11:18 pm
Run a WHERE LEN(col) > 4 against the one you're converting to Numeric(4,2). If you don't find anything, Try WHERE CHARINDEX( '.', col) > 3, to see if you...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 2, 2010 at 11:12 pm
MyStoredProc(
@SearchContains VARCHAR(20)=NULL,
@SearchStartsWith VARCHAR(20)=NULL)
NOTE: Field 'OrderName' is a VARCHAR field
SELECT OrderID, OrderName, OrderValue FROM <table>
WHERE OrderName like '%' + @SearchContains + '%'
or
SELECT OrderID, OrderName FROM <table>
WHERE OrderName like @SearchStartsWith...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 2, 2010 at 6:18 pm
Where, or how, in this proc is the user actually going to be able to respond to 'liking' the new calculated value?
Transactions that require a user-initiated action to continue to...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 2, 2010 at 6:00 pm
Steve Jones - Editor (9/2/2010)
You can build a simple SSIS package using the import/export wizard in SSMS.
Yeah, that link above walks you through that as the first step. My...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 2, 2010 at 4:37 pm
Off a couple of google hits I briefly checked before deciding this one seemed sound:
SSIS: http://www.mssqltips.com/tutorial.asp?tutorial=200
Linked Servers: I'd recommend just using Books Online. They're not that particularly difficult...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 2, 2010 at 4:21 pm
Viewing 15 posts - 5,641 through 5,655 (of 5,678 total)