Search Results

Hi Don,

Thanks for your help and suggestions and apologies for the confussion. Hope the below will explain better :



SOURCE_FILE
-----------------------------------
...

Hi Don,

Thanks for your reply.

I don't see how you get rid of all duplicates by selecting on a few samples???
- The duplicates will be eliminated first and then sample records will be...

Hi,

I am planning to automate the comparison of data between few tables in 2 different databases ( Teradata and sql server).
Below is the approach which I think of. Please suggest any...

Hi Don,

It is a typo mistake. The date is @date_val = '2014-01-01 23:00:00.999' only. Thanks for pointing it out.
The same sql is working in sql server but giving error in unix.

Please...

Hi All,

I am trying to execute a set of sql statements in sql server 2008 using the sqlcmd command in unix and passing the query in the "input" parameter. It is giving me an error "incorrect...

HI Balaji,

Thanks for the reply. I have tried the below code, it's working fine for most of the dates but with few discrepancies.


date_var=$1
day_var=${date_var##*-}
...

Hi All,

I am getting a date from environment variable and want to do some processing by subtracting 2 months from the date passed through the environment variable.

I am trying the...

Hi Durden,

The data type is datetime.

Hi DG,

Thanks for your suggestion.

I am currently using the date criteria as yyyy-mm-dd hh:mi:ss.mmm in the between condition for the current date and add_date(mm,-3) 3 months before...

Hi Rudi,

I checked the PID's using the PS command in unix and based on the PID of the SQLCMD used the command KILL -9 PID .

Not sure if this will kill the session in the sql server as...

Hi,

I am using sql server 2008 version and invoking the stored procedure using unix script. I want to know the procedure of killing the stored procedure in sql server.
If I kill -9 the unix...

HI Blackrageous,

Yes, I am passing the date variable through unix. We are using Linux version.

I am able to pass the variable but still will need suggestions in case of improvements.
...

Hi Blackrageous,

Thanks for the reply!

it's SQL SERVER 2008 R2 version.

I will check on the -v switch and let you know. But my doubt is how to pass the date from the unix script to...

HI,

I am calling a stored procedure to archieve records from the DB based on a date condition. The syntax for the same is as below:
shell script - xyz.sh

sqlcmd -s<servername> -U...

Hi,
Thanks for the prompt response. The hashbang syntax is #!/bin/ksh or [#!/bin/sh] only but I typed it incorrectly in my earlier post. So what I incur from the above comments is that the syntax...

HI,

I am facing an error while executing a script in for loop.

the syntax is : for (( i=0;i<=${v_colcnt};i++ )); do
Error : '(' unexpected

I am new to unix and have tried...