Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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)
|Full Text Search string||5||33|
|Numeric sequence in SQL||14||38|
|How can I use one field instead of another in an SQL query when conditions apply||12||19|
|Search and display values in the textbox using VB.net and SQL||19||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!