PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
declare @ssid varchar(max) declare @stid varchar(max) declare @RegionID varchar(10) set @ssid='acd5eb63-6cf5-4ae0-9d26-afa76f2cd83f' set @stid='' set @RegionID='' select distinct cstitle as PageTitle,substring(convert(varchar(4000),csChallenge),0,150)+'...' as Excerpt,'Client Success' as AreaName,'' as OfficeName,convert(varchar(38),tbl_CS_Master.csID) as csid ,'' as ksID ,'' as "Filename" ,'' as ks_FName ,'' as ks_LName from tbl_CS_Master left join tbl_cs_service on tbl_cs_service.csid= tbl_CS_Master.csid left join tbl_CS_Regions on tbl_CS_Master.csID = tbl_CS_Regions.csID where (convert(varchar(36),tbl_cs_service.ssid) in (select cast(value as uniqueidentifier) from dbo.ParmsToList(@ssid)) or @ssid is null) and (tbl_CS_Regions.RegionID in (select cast( value as int) from dbo.ParmsToList(@RegionID)) or @RegionID is null)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Convert results from the query output to insert into sql table||3||28|
|sql, how to change the data type after data loading?||9||58|
|how to resize column length with primary ket||4||33|
|sql server string_split||4||28|
Join the community of 500,000 technology professionals and ask your questions.