SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION BigMoney

(

@value float

)

RETURNS VARCHAR(500)

AS

BEGIN

DECLARE @numreal BIGINT, @num BIGINT,

@Result VARCHAR(200)

...

Actually, mine doesn't consider the fractional part of the number.

DECLARE @numreal BIGINT, @num BIGINT,

@Result VARCHAR(200)

SELECT @numreal = -123456789012,

@num = ABS(@numreal),

@Result = CASE(SIGN(@numreal)) WHEN 1 THEN '' ELSE...

FYI, you do need to make sure that the order by's on the insert and the CTE match. If they don't you will delete the wrong rows.

i.e. It should...

IF OBJECT_ID('tempdb..#temp') IS NOT NULL

DROP TABLE #temp

IF OBJECT_ID('tempdb..#temp2') IS NOT NULL

DROP TABLE #temp2

SELECT * INTO #temp

FROM sys.columns

SELECT COUNT(*) FROM #temp

SELECT TOP(500) *

INTO #temp2

FROM [#temp] ORDER BY [#temp].column_id

;WITH x AS...

aggregate functions need to be coded as CLR's. Look into VS if you really need an aggregate.

You can get pretty complex and my experience is they don't perform as...

Mark Markov (4/17/2008)[/b

Dear Mr. John Rowan:

I come from a former Soviet republic and I have difficulty determining when Americans are joking and when they are serious... Just in case you...

Mark Markov (4/17/2008)

I am confused because while I may be lying to get a job, I did not lie to YOU and I said in my first post that I...

When I went to my second interview for my current job, the manager interviewing...

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=323974&wa=wsignin1.0

Hello Bob,

Thanks very much for sending this our way. Looks like this was caused by a regression from a Yukon bug fix. We have fixed this in SQL Server 2008...

Since the statement used returns the entire...

DonaldW (4/10/2008)

Yes. That is my daughter. And thank you!...

I will continue to live in my make believe world for as long as I can.

http://video.google.com/videoplay?docid=-1491861000307198203&hl=en Mine is the second to sing. I expect that I have little chance...

I am expecting it on youtube any day now 🙁 But yes, I do have the...

So, in addition to annoying people, we entertain Mike 😎

Last night, the other parents and I,...