Viewing 15 posts - 826 through 840 (of 1,183 total)
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 24, 2007 at 4:19 pm
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 24, 2007 at 6:02 am
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:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 23, 2007 at 9:27 pm
Thanks Ramesh... 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 23, 2007 at 7:37 am
WITH
cte_tbl
AS ( SELECT
a1, a2, a3, a4
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 23, 2007 at 7:04 am
It looks to me that you need and OR clause and not a CASE.
LEFT OUTER JOIN @TEMPTABLE RT
ON D.THEDATE >= RT.CHECKIN
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 23, 2007 at 6:23 am
This should help get you there.
http://www.sqlservercentral.com/articles/Development/2824/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 23, 2007 at 6:15 am
homebrew01 (10/22/2007)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 22, 2007 at 9:34 am
Sorry, you got me on this one. :unsure:
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 22, 2007 at 6:08 am
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...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 22, 2007 at 5:34 am
Oh, and NO REASON to apologize. We all learn. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 22, 2007 at 5:30 am
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
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 22, 2007 at 5:29 am
David McFarland (10/20/2007)
Jason Selburg (10/20/2007)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 20, 2007 at 4:00 pm
SELECT
taxAmount = CASE
WHEN billAmount > 300 THEN
(300 * .03) + ((billAmount - 300) * .01)
ELSE
billamount * .03
END
FROM
....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 20, 2007 at 11:16 am
Jeff Moden (10/20/2007)
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,...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgOctober 20, 2007 at 11:08 am
Viewing 15 posts - 826 through 840 (of 1,183 total)