Viewing 12 posts - 1 through 12 (of 12 total)
Phil Parkin (3/17/2010)
March 17, 2010 at 3:55 am
Phil Parkin (3/17/2010)
Do you really need many files, or just many...
March 17, 2010 at 3:32 am
Baronage12 (1/28/2010)
Table name is iitempath
Two columns: citemno which is the primary key (PK, char(20), not null)
and cimagepath (varchar(250), not null)
My Select statement...
January 28, 2010 at 9:01 am
GSquared (9/28/2009)
Tobie-189314 (9/28/2009)
September 29, 2009 at 9:25 am
jghali (9/25/2009)
WOW...That one works too.
I just need to try to understand it.:-)
if you have further question or need help ,don´t hesitate to ask here 😎
September 28, 2009 at 2:39 am
try this and give me feedback:
with duplikate as (
SELECT row1,row2,row3,
row_Number () Over (partition by row1,row2,row3 order by row1) -- sortierung ist eigentlich egal
as RowNumber
FROM...
September 25, 2009 at 10:24 am
yes you´re able to store the value DataRowtoSkip in a table like Default SSIS Configurations. right click in the Package..Package Configurations .. add.. Configurations Type Sql Server..then specify the...
March 16, 2009 at 3:41 am
aveerabadran (3/9/2009)
I load all the 100 records of F1 file successfully using Package1. But during loading of flatfile F2 using Package2, 50 records gets loaded successfully(gets commited) , but 51st...
March 9, 2009 at 10:14 am
tuyetmuadong (3/3/2009)
link ---mte_type---mte_num
1 AAA CA
1 TRG...
March 4, 2009 at 6:47 am
view are not allowed on tempTables (#xyz) . I think you muss create permanent tables (without #) then it will works
Sry for my bad english :unsure:
February 27, 2009 at 5:24 am
Hi,
this is my first reply - wow !
set @charpos = charindex('and',@SearchTerm) instead of
set @charpos = charindex(@SearchTerm,'and')
February 27, 2009 at 5:07 am
Viewing 12 posts - 1 through 12 (of 12 total)