Recent content by JohnDTampaBay

Have you tried using an expression for the Visibility.Hidden property of that row? =IIF( Parameters!ViewReport.Value = "B", True, False) Good luck! --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)

select count(DISTINCT A.mbr_ssn_nbr) from dsnp.pr01_t_mbr_sys A, dsnp.pr01_t_mbr_hist B where A.mbr_ssn_nbr = B.mbr_ssn_nbr and B.benef_stat_cd = 'K' --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)

FOREIGN KEY constraint on FKeyDoc referencing the audit should do the trick. The constraint does not validate NULL against the referenced table, only actual values. --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie...

What version of SQL Server are you running? This should work for 2000 and higher. SELECT Character_Maximum_Length FROM Information_Schema.Columns WHERE Table_Name = 'myTable' AND Column_Name = 'myColumn' --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go...

Sorry about that. I wrote them as CASTs, then decided to change to CONVERTs mid-post. Glad you figured it. --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)

There is no CONVERT style for that. You will have to do it manually. Try this: CONVERT(Month(m.DOB), varchar(2))+'/'+CONVERT(Year(m.DOB), char(4)) --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)

Give this a shot... good luck. DECLARE @UserID int -- or whatever SET @UserID = 123 -- or whatever SELECT ug.UserGroupID, ug.Description, CASE WHEN ugm.UserID IS NOT NULL THEN 'Yes' ELSE 'No' END AS UserX FROM UserGroup AS ug LEFT OUTER JOIN UserGroupMember AS ugm ON ug.UserGroupID =...

Assuming TAble_1 and Table_2 have identical structures, a simple trigger would be ... CREATE TRIGGER trg_Table1_Delete ON Table_1 AFTER DELETE AS INSERT INTO Table_2 SELECT * FROM Deleted --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to...

Ah, gmmastros beat me to the punch and is much more concise. [thumbsup2] --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)

Will the order portion (a,b,etc) of the QuestionNumber always be a single character at the end? Do all QuestionNumber values have an order? Here's a little something to start with: SELECT QuestionNumber, Right(QuestionNumber,1) AS QuestionOrder, Replace(QuestionNumber...

Here's one way. It isn't elegant but it works. Good luck! SELECT Column1, Column2 FROM ( SELECT 1 AS SortIt, 'Column1' AS Column1, 'Column2' AS Column2 FROM ...etc... UNION ALL SELECT 2 AS SortIt, Column1, Column2 FROM ...etc... ) a ORDER BY SortIt --John [rainbow]...

You can use an ActiveX script to dynamically calculate the filename and change the DataSource property of the Destination connection, or possibly just a Dynamic Properties Task. Good luck! --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do...

UPDATE table SET column = Left(column, Len(column) - 2) + '.' + Right(column, 2) Something like this should work. --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)

No need for parens around the datetime datatype. create table #commissions ( employeeid int, woid int, worid int, custid int, custcode char(20), custname varchar (255), Effdate datetime , WeekEnd datetime ) --John [rainbow] ----------------------------------- Behold! As a wild ass in...

SELECT Reason, Min(ClientNo) AS ClientNo FROM yourtable GROUP BY Reason How does this work for you? --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)