Clecko,

I read your post and it makes me want to go out and buy all of your books.

What a great way to start the New Year.:hehe:

Happy New Years.:w00t:

How can I modify the function so that you can pass a data type and it returns the result in the specified format and avoid using the Convert Function

as...

No hints?:crazy:

What I'm trying to do is Repeat header rows on each page.

I have not be able to find anything that works.

It should as simple as setting a property at...

PaulB-TheOneAndOnly (12/29/2011)

---

I remember having to do it a few years ago.

Didn't use a third party tool but a set of three stored procedures: sp_hexadecimal, sp_help_revlogin and a sligthly hacked version...

Brandie Tarvin (12/29/2011)

---

I've never had to, so I can't tell you the consequences of doing so. But a few years back, I know of one SSC poster who swore by...

tfifield (12/29/2011)

---

If you have 3 different databases then you need 3 different DSN's. Use the appropriate DSN for for the table you are linking. I usually have no...

Reposted to the following thread:

http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=tn4hztje0kd2zlfndsa2noie

Please do not respond to this thread.

Don't forget to make sure that the Account that is stored in the connections column of mysysobjects matches up with the Account used by the DSN.

Also make sure that the...

If you log on with an...

Very clever. I appreciate all of the feedback from everyone.

Thanks.

I guess that it depends because you may not always have a presentation layer...

CREATEFUNCTION[dbo].[fncConvertAS400Date]

(@AS400Datevarchar(9))

RETURNSdatetime

-------------------------------------------------------------------------------------------

AS

-------------------------------------------------------------------------------------------

BEGIN--Beginning of Function

-------------------------------------------------------------------------------------------

DECLARE@numDateint

DECLARE@varDatevarchar(10)

DECLARE@rtnDatedatetime

-----------------------------------------------------------------------------------

IfIsNumeric(@AS400Date) = 1

BEGIN

SET@numDate =CAST(@AS400DateASint)

SET@numDate =@numDate + 19000000

SET@varDate =CAST(@numDateASvarchar(8))

SET@varDate =Substring(@varDate, 5, 2) + '/' +--Month

Right(@varDate, 2) + '/' +--Day

LEFT(@varDate, 4)--Year

END

ELSE

BEGIN

SET@varDate =NULL

END

-----------------------------------------------------------------------------------

IfIsDate(@varDate) = 1

SET@rtnDate =CAST(@varDateASdatetime)

ELSE

SET@rtnDate =NULL

-----------------------------------------------------------------------------------

RETURN@rtnDate

-------------------------------------------------------------------------------------------

END--End of Function

-------------------------------------------------------------------------------------------

DECLARE @sales DECIMAL (18,2)

DECLARE @Commission DECIMAL (18,2)

DECLARE @CommissionRate VARCHAR(200)

SET @sales = '1800'

SET @Commission =...