You can query the system table sys.check_constraints to get the definition. You would then have to parse out the result to get what you wanted in list format.

SELECT definition

FROM sys.check_constraints...

The trick is to set the page width (under Report Properties and Layout) to a setting that fits that actual report's width and NOT to the actual PAPER's width.

So if...

Sorry for the OBVIOUS mistakes.

It's been a rather unusual day today, but I'm glad yo got what you needed from it! :w00t:

Thanks Ramesh... 😀

WITH

cte_tbl

AS ( SELECT

a1, a2, a3, a4

...

It looks to me that you need and OR clause and not a CASE.

LEFT OUTER JOIN @TEMPTABLE RT

ON D.THEDATE >= RT.CHECKIN

...

This should help get you there.

http://www.sqlservercentral.com/articles/Development/2824/

homebrew01 (10/22/2007)

---

Are you doing it through the GUI ?? I think I remember that in SQL 2000 I would get timeouts using the GUI because it had a timeout...

Sorry, you got me on this one. :unsure:

You need to encapsulate the SQL text in single quotes as below.

CREATE FUNCTION dbo.ExecuteStringAsQuery

(@empID as nvarchar(500))

RETURNS Varchar(8000)

AS

BEGIN

DECLARE @SQLQuery AS NVARCHAR(500),

@RESULT AS NVARCHAR(500)

/* Build Transact-SQL String with parameter value */

SET @SQLQuery...

Oh, and NO REASON to apologize. We all learn. 😀

Try reading up on the CASE statement in BOL (Books On Line)

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/658039ec-8dc2-4251-bc82-30ea23708cee.htm

David McFarland (10/20/2007)

---

Jason Selburg (10/20/2007)

---

Man, my eyes are going bad too! Now correct me if I'm wrong, but wouldn't the statement fail without having the Committed_Fund_Item_ID in the GROUP BY?...

SELECT

taxAmount = CASE

WHEN billAmount > 300 THEN

(300 * .03) + ((billAmount - 300) * .01)

ELSE

billamount * .03

END

FROM

....

Jeff Moden (10/20/2007)

---

Heh... I thought the same thing... but there's two columns that look very much alike...

Committed_Fund_ID

Committed_Fund_Item_ID

I don't see the Committed_Fund_Item_ID being used in the problem GROUP BY query... 'course,...