Try this. The issue seems to be that the DATEDIFF and DATEPART functions seem to return an INT value, which at a precision level of 7 gets overflowed. So I...

A "Tally" table (sometimes called a "Numbers" table) is...

dwain.c (9/2/2012)

---

I don't know if this is any lighter or better performing but it's another option:

SELECT *

FROM @NumberTable

ORDER BY RIGHT('000' +

REPLACE(

SUBSTRING(ItemNumber,...

The procedure does several Inserts/Updates, some of which are executions of other stored procedures. If you can identify which table and column is causing the error then check the datatype...

Here's a revised version of the function I posted above which in addition to checking for normal ASCII characters will...

Keep in mind that just because a column has the Identity property that's no guarantee that values in the column will be unique or consecutive. Usually (but not always) Identity...

I didn't write this code and can't remember where I got it so apologies to the original author. In my case I only cared about non-ASCII characters outside the range...

Try this:

CREATE FUNCTION dbo.svfRemoveLeftMostCharacters

(

@Source VARCHAR(1000)

,@Char CHAR(1)

)

RETURNS VARCHAR(1000)

AS

BEGIN

/* This function requires a Tally or Numbers table */

/* http://www.sqlservercentral.com/articles/T-SQL/62867/ */

DECLARE

@NewValue VARCHAR(1000)

,@Pos...

But to answer your question, sometimes XML PATH('') is left blank and other times you can specify a node value as in this example. Notice in the rendered XML how...

Another way to create a delimited string from table data WITHOUT using XML. This can easily be turned into a function if so desired. If so, it's best used as...

This should have no length limitations since the result is a string.

DECLARE

@s-2 VARCHAR(50)

,@Split CHAR(1)

,@X XML

,@strNewValue...

Good point, but I made a quick...

I didn't write this function (though I made some minor mods), but picked it up somewhere along the way. It is a standard tool-box item I use on almost every...

You can use this in a stored procedure or turn it into a table-valued function.

DECLARE

@s-2 VARCHAR(MAX)

,@Split CHAR(1)

,@X XML

SET...

If you want some flexibility to change fiscal year date ranges the case statements are a bit tedious. I happened to need some fiscal year calculations just the other day...