Search results for query: *

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)

Prefix it with sp_ and create it in master. It will execute in the context of the database called from. --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)

So I can't bring the database online until all filegroups have been restored? It was my understanding that tables would be available as soon as each filegroup was restored. Our endmonth process only requires about 1/3 of the tables in the database. I would love to get it churning without waiting...

I need advise on refining our backup/restore process. We have a big honkin' production database that needs to be backed up, BAK copied to 2nd server, then restored on 2nd server for Endmonth processing. Currently the backup/restore time is quite lengthy. It is my understanding that I can...

Check out sp_start_job in BOL. --John [rainbow] ----------------------------------- Behold! As a wild ass in the desert go forth I to do my work. --Gurnie Hallock (Dune)

How about creating a view that normalizes the data, then querying the view? CREATE VIEW SomeView AS SELECT Code, Year, Month_1 AS July FROM YourTable UNION ALL SELECT Code, Year, Month_2 AS August FROM YourTable UNION ALL ...etc... It will take a little more work to get the From and To...