Viewing 15 posts - 4,456 through 4,470 (of 13,877 total)
Something like this?select o.OrderNumber from Orders o
where not exists (select 1 from Roles r where r.OrderNumber = o.OrderNumber and o.RoleType = 22)
May 15, 2018 at 1:02 pm
dgl - Tuesday, May 15, 2018 7:55 AMThis is what I was trying to describe as my second option.
Your second option clearly...
May 15, 2018 at 8:36 am
May 15, 2018 at 7:28 am
Output:
Names ...
May 14, 2018 at 8:55 am
Simple, effective and well written. Good stuff.
May 14, 2018 at 4:39 am
This is a requirement. What is your question?
May 13, 2018 at 8:12 am
May 10, 2018 at 12:29 pm
Apologies if you've already answered this question, but is the package deployed to SSISDB?
If so, can you check the 'All Executions' report for the package to see whether that...
May 10, 2018 at 9:43 am
Have you tried casting to VARCHAR() and then doing the comparison?
May 9, 2018 at 3:13 pm
Something like this, maybe:WITH SourceData
AS
(
SELECT
ID = ID
, EMPID = a.SNO
, TYPE = '1'
, ACTIVATE = a.StartDate
, DEACTIVATE...
May 9, 2018 at 12:12 pm
Are you saying that you have data stored in a column and you want to get all of the column's items into a string variable as a comma-delimited string?
May 9, 2018 at 9:08 am
Viewing 15 posts - 4,456 through 4,470 (of 13,877 total)