Viewing 15 posts - 9,181 through 9,195 (of 13,876 total)
Something like this?
select t1.Key1
,t1.Key2
,t1.Type
from Table1 t1
where t1.Key2 is null
and t1.Type = 'TypeA'
and not exists (
select *
from table1 t
where t.type = 'TypeB'
and t.Key2 = t1.Key1
)
July 16, 2014 at 11:54 am
And while I'm being pedantic, I'll out-pedant your question and point out that a primary key is neither an index nor a constraint, but the values of a particular set...
July 16, 2014 at 7:01 am
Phil Factor (7/16/2014)
Regarding this
... default candidate key to be used to select particular rows of the table
Can anyone expand on what is meant by 'default' here?
In addition to what's been...
July 16, 2014 at 2:58 am
Koen Verbeeck (7/16/2014)
Phil Parkin (7/16/2014)
Regarding this... default candidate key to be used to select particular rows of the table
Can anyone expand on what is meant by 'default' here?
When there are...
July 16, 2014 at 2:15 am
Regarding this
... default candidate key to be used to select particular rows of the table
Can anyone expand on what is meant by 'default' here?
July 16, 2014 at 2:06 am
No problem and good luck. Why not use SSIS all the time? It's a perfect scenario for it.
July 15, 2014 at 9:31 am
Well that's a good start. Here's a pattern that could be worth investigating. Pseudo-code: for each table t:
1) truncate target.wrk.t
(a work table - truncated every run, same columns/constraints as...
July 15, 2014 at 8:45 am
lindsayscott23 (7/15/2014)
Is there a way to just import changes to tables in a live (Oracle 11g) database into SQL Server, rather than importing the whole table and rebuilding each time?
I...
July 15, 2014 at 7:57 am
Double click on your flat file connection manager, click on 'Advanced' in the left window.
Increase 'Output Column Width' for each column that needs it.
July 15, 2014 at 3:49 am
annlcarey (7/14/2014)
Agreed. Rather than trying to keep track of the quotes, I use the tilde ~ to represent my single quote, then do a replace at the end.
Careful with that....
July 14, 2014 at 7:48 am
If you move a file to another folder after processing it, will the vendor put it back if it is within the seven-day period?
July 13, 2014 at 11:27 pm
gregwjohnston (7/11/2014)
July 12, 2014 at 12:39 am
Kenneth.Fisher (7/11/2014)
Yep it was covered extensively. But that's ok comments are always welcome 🙂
Extensively?! Sounds like that's my bedtime reading sorted out 🙂
July 11, 2014 at 7:25 am
Koen Verbeeck (7/11/2014)
...I think you need to use a more recent version number for the SQL native client.
+1
July 11, 2014 at 5:35 am
Apologies - I have not read all of the thread, so this may already have been covered.
It may be of interest to note that, although they are often confused, a...
July 11, 2014 at 3:40 am
Viewing 15 posts - 9,181 through 9,195 (of 13,876 total)