If you have SQL 2005+ you can use a CTE to get the results:

DECLARE @StartDate DATETIME;

DECLARE @EndDate DATETIME;

SET @StartDate = '4/1/2012';

SET @EndDate = '6/15/2012';

;WITH

n AS (SELECT num...

This is a very useful script. However, there is really no need to use a cursor here. The code can be simplified just by deleting rows which do...

This could also be done simply using the INFORMATION_SCHEMA.TABLE_CONSTRAINTS view.

SELECT 'EXEC sp_rename ''[' + c.CONSTRAINT_SCHEMA + '].[' + c.CONSTRAINT_NAME + ']'', ' +

'''PK_' + c.TABLE_NAME + ''',...

I agree. Most vendors can easily switch translations, either EBCDIC or ASCII test as part of the FTP Upload process. But the issue of how to deal with...

I edited the original post containing the fnUnpack function to fix the undeclared @i variable error (should be @pos). Please let me know if there are any other problems...

As mentioned earlier in this thread, the @i variable is incorrect and should be @pos. I had changed the variable name for clarity's sake in the original post and...

ava1over: Thanks for the posting that link. You are right, no need for 3rd party controls when you simply need a way to translate fields like we've been...

That code was written so long ago, but by the looks of things, I probably changed the [font="Courier New"]@i[/font] variable to [font="Courier New"]@pos[/font] at the last minute to make the...

I ended up taking a slightly different approach and created a stored procedure to call before creating a default constraint. The stored procedure is merely an IF EXISTS...DROP CONSTRAINT...

Paulo,

Not sure about your question. Do you mean you want to convert data to packed decimal (as in export) or read in a data field as a decimal value?...

One way you could do this (which I believe is also the fastest), is to use BULK INSERT into a staging table. First, create a staging table:

[font="Courier New"]

CREATE TABLE...

You are absolutely right. Welcome back to the "dark ages" of programming...:(

I have had to create this in the past, and came up with a simple technique that relies on a UDF to translate the field. The best approach requires...