Viewing 15 posts - 1 through 15 (of 33 total)
vopipari (2/1/2016)
delete Customers
where CustID in (
...
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
February 1, 2016 at 7:46 am
andy_111 (2/1/2016)
Adrian_1 (2/1/2016)
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
February 1, 2016 at 5:44 am
andy_111 (2/1/2016)
Daniel Matthee (1/31/2016)
There is nothing to indicate that you just want to...
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
February 1, 2016 at 1:10 am
I have not tested but just by looking at the code will it not delete both the records???
There is nothing to indicate that you just want to get rid of...
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
January 31, 2016 at 11:41 pm
Hi
No problem at all. That is why are here 🙂
Kind Regards
Daniel
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
January 4, 2015 at 11:34 am
Hi
Of course you can. Change the last select * from CTE to select * Into <permanent table> from CTE
Kind regards
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
January 3, 2015 at 8:49 am
Hi
So this was not so of a twist after all 🙂
Here is the code that you needed. The only difference is in the where clause where you combine the 2...
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
December 24, 2014 at 12:32 am
No Problem at all
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
December 22, 2014 at 12:14 am
So trying to post this from my phone
SELECT Distinct c.[Name]
FROM [EPDM].[dbo].[Projects] a
Join [EPDM].[dbo].[ProjectTree] b
ON B.ProjectID=A.ProjectID
join [EPDM].[dbo].[Projects] c
On b.childprojectId=c.projectid
Where a.name ='projects'
and a.[Deleted] = 0
Hope this is what you...
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
December 21, 2014 at 3:43 pm
No prob at all. Hope this helped
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
December 20, 2014 at 9:27 am
o sorry for that, just add a ; before the with CTE clause or copy below
create table #Info(
EQPT varchar(20),
Seq int,
ActivityDate date,
Type varchar(5)
)
insert into #Info
select
'Vehicle1',221,cast('2013-1-11'as date),'IN'
union select
'Vehicle1',223,cast('2013-1-15'as date),'OUT'union...
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
December 20, 2014 at 8:59 am
Hi
So OFF course there are better ways of doing think but a quick fix/idea you can use the following.
create table #Info(
EQPT varchar(20),
Seq int,
ActivityDate date,
Type varchar(5)
)
insert into #Info
select
'Vehicle1',221,cast('2013-1-11'as...
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
December 20, 2014 at 8:37 am
If the above is not what you are looking for please provide some sample data.
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
December 20, 2014 at 8:15 am
Hi
Well If i understand you correctly.
You want to filter (where clause) by Project.name.
Just looking at you table i think firstly your joins are incorrect, just by looking at your...
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
December 20, 2014 at 8:15 am
Yes the email is validated.
In a perfect world I just want the best and fastest way getting the domain info
--------------------------------------------------------------------------------------------------------------------------------------------------------
To some it may look best but to others it might be the worst, but then again to some it might be the worst but to others the best.
http://www.sql-sa.co.za
November 12, 2014 at 6:15 am
Viewing 15 posts - 1 through 15 (of 33 total)