Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Distinct in sql with case sensetive text
ravi sharma
Jan 11 2017 4:14 AM
237
Reply
Hi,
I need to get result with distinct on tag field by considering case sensetive for following query.
SELECT
Distinct [SC].[Tag] AS Tag
FROM [dbo].[ScenarioTags] AS [sc]
INNER JOIN [dbo].[Scenarios] AS [scn] ON [sc].[ScenarioId] = [scn].[ScenarioId]
LEFT OUTER JOIN [dbo].[Scenarios_Contacts] AS [soc] ON [sc].[ScenarioId] = [soc].[ScenarioId]
INNER JOIN [dbo].[Tools] AS [tl] ON [scn].[ToolId] = [tl].[ToolId]
INNER JOIN [dbo].[Services_Tools] AS [st] ON [tl].[ToolId] = [st].[ToolId]
INNER JOIN [dbo].[Services] AS [s] ON [st].[ServiceId] = [s].[ServiceId]
WHERE [sc].[CreatedById] = '003V000000GIdvgIAD' OR [soc].[ProfileId] = '003V000000GIdvgIAD' AND [scn].[IsDeleted] = 'false' AND [scn].[IsScenarioSaved]='true' AND
[tl].[IsActive] = 'true' AND [s].[Code] IN (N'TA3-DCS', N'TA3-MOS', N'TA3-ABM', N'TA3-EGS', N'TA3-CSS', N'TA3-SOSN', N'TA3-PMGMT', N'TA3-CMKTG')
I tried to distinct but it is showing single result for both QA Im and qa IM
Please suggest.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
select sum of salary >50000 between month of jan to dec for
Is it possible to use other scripting library with JQuery li