Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to select rows that not meet a join condition
hi, how can i do to select those invoices that their numbers parts have rate "tlcan" and dont have a valid "tlcan" certificate of origin for the invoice date select claused have 3 tables and a just want those rows that not meet the join condition here its my code select invoice, date, part...- bmeza
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
filter select
I have @depto beachible and I want to make a filter in "select" when @depto is different from blanks here its my code: declare @depto as varchar(12) set @depto='1500' if @p_depto!='' begin select distinct p_parte,p_depto from products where p_type in ('A', 'P') and p_status='A' and...- bmeza
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
-
bulk insert
Hi, I have a text file and I want to use bulk insert, I now how to do it, but in the text file I have header record and detail record, how can I make a difference to insert in boot tables;the text file can have lot a heaaders and details example text file H^MP^319267228^17-FEB-06^^^^GXB... -
CR Change database location at run time vb6 help!!!!
Hi I have a report that use Microsoft sql server to connect at data base and I want to change the data base at run time in vb6.0; But I always get the data base that I put in cr at set location here its my code: For Each crxDBTable In Reporte.Database.Tables...- bmeza
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
