Search results for query: *

On the same table I have table rows that are broken from the import and went to the next row. I need to bring it back to the parent row. For example ID 1 Col3 supposed to have the value 'GHI' but the 'I' went to the 2nd row or ID 2 Col1 cell. Same applies to ID3 supposed to have 'GGG' but it...

I am looking for examples to use Java Script to parse and import word and pdf into SQL server table. The word or pdf might have format from the link below. Can this be done using Java script? Thanks http://naturalbuffdog.com/assets-and-liabilities-spreadsheet/examples-of-assets-and-liabilities/

Hi, I am using VB script for Active X DTS. I have mulitple files like (AA.txt, BB.txt. CC.txt) in a directory \\servername\Data and I need to archive it to the directory \\servername\Data\Archive once it is exported through DTS. I like to archive it and add latest date after the original names...

HI ,I am new to SAS and I have a 9.1.3 SAS installed on my workstation. When I executed the script below I ran into error stated "The format $SEX was not found or could not be loaded"'. Below is my script and I have commented with "ERROR HERE !!!". Please advise. Thanks. libname dummy1...

Hi, I need to create a DTS to output and SAS xpt format. The DTS will connect to SQL 2000 server and Ther SAS include comment and label. Where do I start and how is the connection establish for SAS to SQL server in DTS. Please advise. Thanks.

Hi, I have a table below Table A ID ModDate InputDate Type 1 12/1/05 12/3/05 2 2 1/13/06 1/30/06 5 3 2/14/06 2/23/06 4 and I need to create a trigger to capture only if there is an Update on 'ModDate' with the 'Type' = 5 or an Insert row with the...

Hi All, I have a xml document to import and export and how do I go about using the DTS to import the XML file as well as export it? BTW I am new to XML.I do not know how to call the XML file and data and insert it into SQLserver or vice versa. Any example will be greatly appreciated.Thanks.

HI I need to update A table B column with squential numbers in the order of 1,2,3,4 5 and so forth. Currently, the B column has the of 2,5,7,8, 15 and so forth. Please advise. Thanks

Hi, I have a table name AA and I need to update a field name 'Priority' in the AA table using trigger when a row is inserted to the AA table. Is that possible? Thanks Priority 1,2,3, or 4 AA Table Num OrderNum Salesperson Date Priority --- -------- ---------- ----...

Hi, Is there a way to convert Datetime to Date without using varchar or char? This is because the date will be using for calculation later. Thanks.

Hi, I accidentally rename dbo.AA table to dbo.AA_1 and now it has become dbo.dbo.AA_1 table. Is there a way to remove the dbo prefix? Please advise. Thanks.

Can I create an index on a variable table? I got an error declare @AA table ( ID int, TC varchar(20) ) create index index1 on @AA (intExportUID) --Line 149: Incorrect syntax near @AA

Hi, I have a cursor that is causing performance and I want to replace it for better performance what would be a best way to do it. Thanks. set @SID = 0 Declare 4D_curs Cursor LOCAL FAST_FORWARD for Select distinct SID from @4Ept Open 4D_curs Fetch Next from...

Hi, I am trying to replace the Delete statement because it causedperformance issue and take up CPU. I try to replace the using 'NOT IN' I am not sure anybody has any advice for me. Thanks. delete from @AA where orderid not in ( select max(orderid) as orderID from @AA group by BaseID

Hi, I have a variable error that stated that I have to declare @table which I already declare when I run my query below. Please advise. Thanks DECLARE @YR varchar(4) DECLARE @QTR varchar(3) DECLARE @Table varchar(30) SET @YR = Year(getdate()) If Month(getdate()) IN (1,2,3) SET @QTR = '_Q1'...

Hi, I need to archive weekly data from AA server archive database to BB server archive database. I need to do a rowcount on AA server archive database of that week and insert into BB server archive database. Before the insert I want to compare the rowcount between these 2 servers and if is...

Hi All, on SQL 2000 can I use a IF statement to execute a dynamic sql. If I get the print statement output to creat tables theyare fine but in the Dynamic sql in the IF statement the tables did not get created. Below is my script DECLARE @YR varchar(4) DECLARE @T_Yr varchar(25) DECLARE...

Hi, I am using SQL 2000 and I have renamed AAA table to BBB table and created a new table named AAA. However, the BBB table has 20 dependencies (SP and Trig) that I wanted to move back to the new AAA table. I do not want to drop and recreate the dependencies. Is there a way to move to the new...

I am using CR 10 and the report is run through a backend procedure for Aging. When I ran t the proc through the backend with the paramters it took less then a minute to retrieve 1 year of data. However, when I run through CR 10 developer version it took basically took more than 2 hours to...

I am using SQL Anywhere 9.0. I have a store procedure that has 5 parameters. Each time when I enter a value of a parameter it took 16 seconds however, when I tried to enter a different value on the same parameter it took 20 mins up. Is there way to trace the input and output or which table is...