Viewing 15 posts - 9,181 through 9,195 (of 13,882 total)
Not sure whether it will work, but I think your regex may be incorrect.
string toreplace = "[\uFFFC]";
Can you try removing the square brackets?
string toreplace = "\uFFFC";
July 21, 2014 at 8:28 am
Gary Varga (7/21/2014)
--Personally, I'd much rather upscale a solution based on Access than one based in Excel.
Let's see whether anyone takes the bait 😉
July 21, 2014 at 8:05 am
Sergiy (7/18/2014)
Koen Verbeeck (7/17/2014)
Sergiy (7/16/2014)
Koen Verbeeck (7/16/2014)
So it is 100% possible to decouple the primary key from the indexCan you illustrate how?
Easy peasy. I draw a table diagram in Visio...
July 18, 2014 at 12:21 am
podmate (7/17/2014)
Now that I am building ETL apps in SSIS, I long for the days when I could script out my ETL process and did not have to deal with...
July 17, 2014 at 11:42 pm
Still nothing resembling a question.
July 17, 2014 at 9:40 am
susmitha117 (7/17/2014)
To extend further i followed this link belowI did the same way but first for loop executes but doesnot loop with the one inside
Please help
You have not asked...
July 17, 2014 at 8:53 am
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
Viewing 15 posts - 9,181 through 9,195 (of 13,882 total)