Raj Malwade | SQLServerCentral

Raj Malwade

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

RE: Converting DATE from ORACLE to SQL Server

William:
Thanks for your answer. I solved the problem by using DECODE on the ORACLE and coverted 01/01/0001 date to NULL at the source. It looks like this:
DECODE(to_number(substr(TO_CHAR( T$PRDT,

August 13, 2004 at 5:44 pm

#518985

RE: Script to wait for file to start executing package. Event based Triggering.

Matthias :

Your solution certainly works.

Others have mentioned that :

1. I can use "retry functionlality built in the job" - I was wondering if you can point me where this feature...

August 3, 2004 at 9:52 am

RE: Convert table into a crosstab table in SQL Server

Nivedita:

This query does work. Thanks for your help.

July 21, 2004 at 9:59 am

RE: Convert table into a crosstab table in SQL Server

HI: Thanks for your help. But with the query you have specified the

result I get is:

ITEM SOUCE1 SOURCE2 SOURCE3 SOURCE4

a bb bb bb bb

b ee ee ee ee

The result I...

July 20, 2004 at 10:10 am

RE: Function to get "day of Quarter" in T-SQL or DTS ?

Thank you very much for everybody's help. It works.

July 15, 2004 at 6:04 pm

RE: Function to get "day of Quarter" in T-SQL or DTS ?

Hello:

Thanks for your help. This certainly works in "Execute SQL Task" in DTS

Both the answers work. But how do I do this in Active X script of Transform Data...

July 15, 2004 at 4:46 pm

Viewing 6 posts - 1 through 6 (of 6 total)