That would alos be a good solution. Since I have a select statement that defines the tables I need to copy, I can pass the list to a table, temp table, sursor, etc. I am mystified about how I get that result set into DTS so it can use it.
2004-04-01
I used this UDF alot to return only the date part. I got from some site. It is also possible to get the time part mathematically. I just forget the URL though!CREATE FUNCTION fn_Date ( @ADate datetime ) RETURNS datetime AS BEGIN declare @DateVal datetime set @DateVal = CAST(FLOOR(CAST(@ADate AS float)) AS datetime) return @DateVal END
2004-03-29
Hi, allI just built a trigger for my table, both for insert and update. The purpose is to log history of the data table to another table. The question is, how am I gonna classify the trigger run under insert action or update action.The triggers is similar likethis :CREATE TRIGGER [sp_trrequest] ON [dbo].[TrRequest] FOR INSERT, […]
2004-03-17
1 reads
Hi Jonathan.I used the "ON UPDATE CASCADE" option, and it worked, cheers.The reason i wanted to change the attributeId is because I wanted my query to return the results in the ORDER BY attribId:<code>SELECT DISTINCT p.productId, p.productName, a.attribName, pa.attribValue FROM tblProduct p, tblProductAttribute pa, tblAttribute a WHERE p.productId = pa.productId AND a.attribId […]
2004-03-11
I would recommend setting up a DOS batch script to handle the ftp and kick that off using DTS. You'll find it works very consistently and is relatively simple. Make sure to have full path names for all file references in the DOS scripts (ex. e:\my_scripts\ftp\some_ftp_script.bat).
2004-01-28
1 reads
2004-01-27
2004-01-09
1 reads
I have would have an another approach. For me in a small db of 80 MB a query of 30 sec or even minutes is inimaginable. Something must be wrong out there. Therefore did you check in the profiler if you are using the indexes correctly or it is making a table scan? Do you […]
2003-12-30
quote: I am trying to figure out how to export the results of a query to Excel with some specific formatting. Is this possible to do without using DTS? One method could be -- Inputs:File name of the excel document. -- Returns:The query result, written directly in Excel document! DECLARE @err_desc varchar(255) DECLARE @i int […]
2003-08-27
Hi happyshan_1980, quote: hello everyone: I have a trouble .My operation system is red hat 9.01 ,and when I use the kylix 3 I can't connect with mysql .Please help me. Thank you ! I think you should subscribe to a MySQL mailing list http://lists.mysql.com/list.php and ask your question there. The probability to get a […]
2003-08-21
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers