DSXchange

Perfect, thank you kindly.

Haha.. point taken.

I never looked at the date.
But, hopefully it'll update the thread in case someone else come along.

Why not use these?

MeasureTime YearsToSeconds
MeasureTime WeeksToSeconds

Look in the help file under "Measurement Transforms - Time"

Hello All, I copied this, http://www.dsxchange.com/viewtopic.php?p=304267#304267, to try and get community input to create a solid full featured DateAdd routine. Please assist. I tried to get the Add years functionality but I'm failing dismally due to my shocking Basic knowledge. But I'm pressing on...

Hello All, I'm battling to add years together. Is there anyway I can expand on this to add years.? I currently have a problem like this. maturity_date = commencement_date + term_years I suppose what I'm really looking for is this function above to add years as well, but the numbers won't be right be...

Thank You Very Much.

Thank You Very Much.

Hello, I have a requirement to extract a Surname from a name field. The issue is when the user has multiple second names. How would I extract the last "field" from the string? example: 'Joe Blogs'[' ',2,1] = 'Blogs' 'Jenny Marge Ashby'[' ',2,1] = 'Marge' *here is should be Ashby Thanks.

Is it possible to backup the scheduling details of scheduled tasks? We are busy moving DS to another server/DB and need to reinstate the scheduling details of scheduled jobs on the new installation. Alternatively, can I find the schedulling details in the DB? If so, where? We are running on SQL2005 ...

Can Anyone help me with the configuration for XMETA and IADB?

I need to find way to point to the local SQL installation and not the current installation over the network

Thanks.

Hello Everyone,

Has anyone been able to try and get this working.? Does anyone else have this requirement.?

I've been on other projects and only really come back to this problem yesterday.

Any help will be greatly appreciated.

Regards.

Please can someone help me here, I still haven't found a solution to this.
I'm currently running the XMETA and IADB on a separate server.

From previous posts, there is a way to run this off a SQL2005 Express server. However, I'm still baffeled as to how.?

Please help.

Thanks in advance.

Was there any solution to this problem.
I'm getting the same error message.

I'm converting a decimal(3,2) to numeric(3,2) and I still get that error.
I've tried all kinds of data types. Varchar, real, decimal. But everything gives me that error.

BTW this DISABLE feature is anly available in SQL 2K5 and SQL 2K8.

Here we go peoples. turns out when you disable your clustered index the SQL bulk loader, or any loader, fails with some error. So you can only really disable your non clustered indexes. FYI: order your data you loading the same as the clustered index for speed. So... check this little proc out. I've...