Search results for query: *

thanx. it works.

How do i group by a case in oracle. ? In sybase my statement looks like this. select case when c.cust_unit_number is null then 'private' else 'business' end,count(distinct a.cust_id_resp) from cm.account a, cm.customer c where a.info_is_deleted = 'N' and a.foreign_account is not null and...

I mean use BCP, to bcp the file into the table.

Use ISQL in a unix script, and put the script into a crontab job. Thats what I would have done!.

The syntax isnt wrong. dont need bracets in header.. Restrictions on text and image Columns text and image columns cannot be used: As parameters to stored procedures or as values passed to these parameters As local variables In order by, compute, group by, and union clauses In an index In...

??.. Your file is split into fields alredy.. with a ; seperator. If u mean splitting it into 3 different files with 1 field in each u can use awk.

Thanx. Cakiwi. Worked perfectly.!

Can someone help me with a command for deleting lines ending with tab ?..

I think this will work: declare @database varchar(30),@searchstring varchar(128) select @database = 'xxx' select @searchstring = 'hello' exec ( "select so.name,count(*) from " + @database + "..syscomments sc1," + @database + "..sysobjects so where sc1.text like '%" + @searchstring + "%'...

Select distinct(convert(varchar(255),ErrorDescription)) from Errrors.. If text is longer than 255 chars, then the rest is cut off.

If you want the top10 prices from a table ie.. u can use set rowcount10 select price from table order by price desc

Thanx.. Figured it out myself after som hard tinking.. My brain sometimes get's bluescreen.. :)

I have this file... insert.sed 10i"Hello" It inserts a Hello on line 10.. if i export a variable $line_num I cant use $line_numi"Hello" Any ideas ?

My cursor suddenly stops ?. @@sqlstatus = 2 when it stops even though there are more rows to be fetched... Anybody have an idea why ?.. set nocount on go declare tell cursor for select driver_id, avtale_nr from GRUNNLAG_DRIVERFILER_AVTALE where info_is_deleted = 'N'...

How the f... do i remove the office bar in windows 2000.. Im tired of closing it manually every time i restart. I hate it......

Thanx... it worked with grep -v '^123+RS' input >output

I want do delete the lines from a file where column 1 matches an exact pattern. ( I want to delete the lines where column 1=123, not the lines where its 21234 ) Please Help!....