Viewing 15 posts - 10,276 through 10,290 (of 13,874 total)
OK, then you need help from an Oracle developer to design your SELECT statement for the OLEDB source.
Select col1, col2
from table
where [convert varchar date and time to datetime] between [startdate]...
December 27, 2012 at 2:54 am
buyme22 (12/27/2012)
input this URL:you can find many cheap and high stuff
Believe you will love it.
WE ACCEPT CREDIT CARD /WESTERN UNION PAYMENT
YOU MUST NOT MISS IT!!!;-):-D:-D
Reported as...
December 27, 2012 at 2:48 am
Is the source a SQL Server database?
December 27, 2012 at 2:18 am
asita (12/26/2012)
Could you please help me out here, i am totally stuck here,
i have total 20 tasks in my ssis package (dataflow, execute sql task, etc)
at 16 dataflow task...
December 27, 2012 at 2:03 am
Depending on the nature of your OLEDB source (is it an RDBMS?), the most efficient way would be to CAST the varchar date/time columns to a single column with a...
December 27, 2012 at 1:53 am
There's an interesting script written by Dan Guzman here which demonstrates that the physical ordering is not necessarily the same as the clustered index logical ordering.
December 26, 2012 at 7:18 am
Nice article, but rather than fields and records, I think you really mean columns and rows - there is a difference.
December 24, 2012 at 6:59 am
Eugene Elutin (12/21/2012)
Phil Parkin (12/21/2012)
...
And as to common practice - not in my experience. I guess it depends on whatever standards are in place where you are working.
In SSMS Object...
December 21, 2012 at 10:24 am
Comments can precede CREATE/ALTER line.
It is most common practice to have stored procedure header comments section outside of stored proc body.
While true, that's being a bit picky:-) Comments immediately preceding...
December 21, 2012 at 8:24 am
Shadab Shah (12/21/2012)
December 21, 2012 at 7:31 am
Mitesh Oswal (12/21/2012)
DECLARE @tbl TABLE
(
ID INT IDENTITY(1,1),
SomeData VARCHAR(100)
)
INSERT INTO @tbl SELECT 'NA11345'
INSERT INTO @tbl SELECT 'NA113456'
INSERT INTO @tbl SELECT 'RA11345'
UPDATE @tbl SET SomeData = SUBSTRING(SomeData,CHARINDEX('NA',SomeData)+2,LEN(SomeData))
WHERE CHARINDEX('NA',SomeData) = 1
select *...
December 21, 2012 at 5:56 am
eklavu (12/20/2012)
UPDATE #TEST_TABLESET COLS = SUBSTRING(COLS,3,LEN(COLS)-2)
WHERE LEFT(COLS,2) = 'NA'
Possibly not relevant here, but if the 'COLS' column is indexed, a better option would be
where cols like 'NA%'
As this will...
December 21, 2012 at 2:18 am
Someone at MS will write a conversion utility for sure if this is implemented. I don't think it's worth worrying about - there is no agreement as to exactly when...
December 20, 2012 at 9:35 am
Koen Verbeeck (12/20/2012)
you could use the Export column to export each location to a seperate flat file (you'd need to combine all the data columns you need...
December 20, 2012 at 7:59 am
Another way:
where len(Col) > len(replace(Col, '''', ''))
December 20, 2012 at 4:22 am
Viewing 15 posts - 10,276 through 10,290 (of 13,874 total)