Search results for query: *

Thank You

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

I change the account on my SQl Agent and assign provileges to a foxpro folder. but I still get this. sound that the DTS start but when it get 5000 records stop.. Executed as user: DOMAIN\MyAccount. ...Start: DTSStep_DTSFTPTask_1 DTSRun OnProgress: DTSStep_DTSFTPTask_1; Copying file to...

here my join, how I can change to Not exists logic?. select a.bd,a.bt,a.bq,a.sm from mm a left join md b on a.bd = b.bd and a.bt = b.bt and a.bq = b.bq and a.sm = b.sm where b.bd is null and b.bt is null and b.bq is null and b.sm is null

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?

It's Posible to assign the user to run the Schedule DTS? because I think that the problem is with folder permissions. because I copy the folder to local machine and was execute perfet

is the system DSN, the strange is when I run the DTS Manualy its work fine the problem is when the schedule run the DTS.

Thanks a lot....I appreciated your time.

Great!!! one thing. tell me the query logic with these joins and expecialy the where clause.

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...

Here is the detail error: Executed as user: LCAILCA\SYSTEM. ...Executing... DTSRun OnStart: DTSStep_DTSFTPTask_1 DTSRun OnProgress: DTSStep_DTSFTPTask_1; Copying file to D:\ProvidersFiles\provider_directory_english version.XLS.; PercentComplete = 0; ProgressCount = 1 DTSRun OnFinish...

Im working with report application and db2 so, if I send a query with parameters I do that: select * from t1 where f1 = ? where ? is the param thats query work fine. but if I use "Like" with wild cards "%" in .net with sql I do that: select * from t1 where f1 like + "'%" + ? + "&'" but in...

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'...

thank you for you help.

good job I'v been working all day in that.... you take out all records with "T" then join, It's all corret?

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 '%' || ? || '%'

ok done... thanks for the help...

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...