Jeff Moden (9/8/2010)

---

That may be true... from BOL 2k (had a handy reference there)...

IF ( (SUBSTRING(COLUMNS_UPDATED(),1,1)=power(2,(3-1))

+ power(2,(5-1)))

...

I've never seen a situation where it didn't unless the clustered indexing was changed (since you don't have an order by) or there's something strange going on with the identity...

igngua (9/7/2010)

---

.[EICANALESRES](

[IdContrato] [decimal](10, 0) NOT NULL,

[EiCanalId] [decimal](10, 0) NOT NULL,

[EiFechServ] [datetime] NOT NULL,

[EiFechMaq] [datetime] NOT NULL,

[EiFechCorr] [datetime] NOT NULL,

[EiValorFis] [decimal](25, 4) NOT NULL,

[EiValorNum] [decimal](25, 4) NOT...

If I'd...

Um, errr... dang, I'd have sworn I've done that before. I'm off...

Jeff Moden (9/7/2010)

---

Data this type of thing is stored as the Least Significant Byte First (on the "left"). That's why it appears to be backwards. Then, within each...

I think you're looking for something like:

CREATE TRIGGER tr_test ON dbo.A FOR INSERT AS

UPDATE inserted

SET col1 = <value>

where col1 = 'm'

UPDATE inserted

SET col2 = <value2>

where col2 = 'n'

END

Personally, I'd bulk insert into a staging table and then run on my insert to the real one a REPLACE( Column, ',', '') statement.

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....

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...

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

...

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...

NJ-DBA (9/3/2010)

---

So my question then is this: lets say 90% of objects have been moved to another file group. and 1 object is the last in the datafile....

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...

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...