Viewing 15 posts - 7,681 through 7,695 (of 13,876 total)
Grumpy DBA (1/14/2016)
Luis Cazares (1/14/2016)
Phil Parkin (1/14/2016)
Grumpy DBA (1/14/2016)
January 14, 2016 at 9:52 am
sqlnewbie17 (1/14/2016)
Is there a better way of doing this.My environment is sqlserver...
January 14, 2016 at 7:52 am
Are you opening a VS solution which includes the package? Or attempting to open the dtsx directly?
January 14, 2016 at 7:24 am
Remove the where clause.
Add a column to your select
Iif (Cola >Colb, 'true','false')
January 14, 2016 at 7:19 am
Grumpy DBA (1/14/2016)
January 14, 2016 at 6:42 am
monilps (1/13/2016)
Thanks, this is exactly what I was looking for.
I disagree. Well, it may be what you are looking for, but it does not match your original requirement.
In order...
January 14, 2016 at 5:56 am
PearlJammer1 (1/14/2016)
January 14, 2016 at 5:50 am
I would say yes. But as this is a job, presumably it was working before? Or has the proc definition changed recently?
January 14, 2016 at 5:33 am
Did you try putting your DISTINCT on the nested SELECT?
January 13, 2016 at 1:20 pm
monilps (1/13/2016)
The query is close by what I am looking for but two things:
- Query is only resulting back original rows which has similar duplicate data.
- What if data...
January 13, 2016 at 11:49 am
This fits your example data. But is it too specific for your real-world data?
if OBJECT_ID('tempdb..#dupes') is not null
drop table #dupes;
create table #dupes ( Id int identity (1,1) primary...
January 13, 2016 at 10:48 am
monilps (1/13/2016)
For above example Col3 needs to check with Col3 only.
I'm sorry, but your vague single-sentence responses are not providing the level of clarity required to answer such a complex...
January 13, 2016 at 9:57 am
monilps (1/13/2016)
Yeah, this is for any column.
OK, this answer contradicts the earlier one.
So ... you want to identify rows where another row exists which is 'similar'.
'Similar' here means that all...
January 13, 2016 at 9:34 am
monilps (1/13/2016)
I need to identify possible duplicate (not exactly duplicate row) data without primary key:
Table A:
Col1 ...
January 13, 2016 at 8:58 am
Please explain how the 'customized' figures are determined.
January 13, 2016 at 6:20 am
Viewing 15 posts - 7,681 through 7,695 (of 13,876 total)