Search results for query: *

Hi, I have this... t1 ID,Name,Grp 1 pepe blue 2 juan black t2 ID,T1FK,Date 1 1 01/01/2006 2 1 01/03/2006 3 1 01/02/2005 my join right now get: 1 , 1 , blue,01/01/2006 1 , 2 , blue,01/03/2006 1 , 3 , blue,01/02/2005 I want this: 1 , 2 , blue,01/03/2006

Hi here Again... I have a 2 tables Parent,child... I need to take out all the records with Child without Parent and viceversa,,,right now I'm doing with left join but take much time because those tables are huge.my question is ..exist another other way to acomplish that?

Hi I have a couples repors in RS and I schedule those reports to send via email but sometime those repors comes with no rows... It is posible to cancel the email if the reports comes empty?

HI there..I have a query who take several records I was wondering if I can display the result in 6 column instead of 2.. then query select f1,f1 from t1 result f1, f2 113,343 232,323 .... ....300 rows. I want...

Hi. I have a DTS who takes data from foxpro DB in one server via ODBC System DSN and put in excel file when I run the dts from enterprise manager the dts run very well but when I make a schedule to run the dts the system throw this error: SQL Server Scheduled Job 'ProvidersFileSpanish 2'...

Table 1 f1 f2 f3 1 hey hoy 2 how hew 3 hic hoc Table 2 f1 t1fk-f2 f3 1 1 T 2 1 Y 3 3 Y I need to meke a join but if one child record has 'T' in f3 then exclude all the records for the parent child relation. my result in the example need to be: Hic Hoc Y

Hi How I do this: select * from t1 where f1 like '%joe%' with parameters I try this but does not work; select * from t1 where f1 like '%' || ? || '%'

I need to take data from one table then take data from other table and then join the 2 results. ej.. select f1,f2,f3,f4 from t1 where f1<= date and f2 > date select f1,f2,f3,f4 from t2 where f1<= date and f2 > date select a.*,b.* from t1 a left join t2 b on a.f3 = b.f3 where b.f3 is...

Hi How I can format a field with this value '6' to '06' in as400 db2... in .net would look like this format(field,'0#')

I have a webserver in a domain and application with windows security mode if when I try to access the applicacion with one computer in the domain, should a I have to view the user password screen and type the user and pass or not?

here is my data: Date Type total Change 5/17 s 5037 1 =(5/17-5/16) 5/16 s 5038 1 =(5/16-5/15) 5/15 s 5049 3 =(5/15-5/12) 5/12 s 5043 0 =.... I need the change field, the field is the dife. between him and the next record.

Hi I have this table: type Qty Qty.DIFF e 500 200 e 300 100 e 200 0 I need to calculate the third column wich is the dife. between him and the next record.