I'm looking for some basic info on how to set-off a dts package via a trigger.
I've seen some options but they seem incomplete.
I installed Sql Server SP4, and I get this message whenever I try to save changes for a view on the
sql server.
Error Message:
An invalid parameter or option was specified for procedure
...
Hello, I have a MySQL database that is connected to a web page. I user's enter information into a textarea control. The information goes right into my sql table field. How can i set my (dat...
I notice that there are two files for an sql database - one is MDF and one is LDF. What are these two files? and if I want to move the data to another pc with its own SQL Server do I need to m...
I am trying to translate the following stored procedure code to do an insert on a linked server table. Is this accurate or am I missing some code?
INSERT INTO OPENQUERY(TEMS, 'select * from...
How do I set a varchar feild default value to 1-9 (means one through nine)
I want it to display 1-9
Dear Experts,
I'm doing a BULK INSERT, using the FORMATFILE option. One column (BankID) will always be the same. It doesn't appear in my source file. Is there any way to hard-code it wit...
Hi,
I have a DTS package that take two parameters to a SP and export the results to an excel file. The problem is the data is growing, I want to export them to an txt file. This is what I...
Hi,
I was looking for a system integrated way (SQL Server 2000) to replace placeholders from sysmessages with the appropriate values ... all I found was http://www.experts-exchange.com/Data...
Hello,
I have a problem with a bulk insert. Here is the code:
create table #DocumentTemp_tb (segment varchar(1024));
bulk insert #DocumentTemp_tb
from 'myfile.txt'
with (...
Hi experts,
I have a table with muliple columns and need to get selected columns from each row into a table with a single column.
Example:
Table1
row1: col2, col2, col3
Table 2
t...
I am trying to use xp_sendmail to send company users (on LAN) an email with a list of candidates - the list is formed from a query (see variable @cand below) which is a distributed query acces...
Hi,
I have to create the output from the sql statement with the line breaks to the file (say on C:\ drive)
Here is the sample code I am working with.
DECLARE @cmd sysname, @var sysname
S...
I am scheduling to import a xls file into SQL server by using Import/Export Data. I need to match values in a cloumn of the xls file to values in a field of an existing table in the same DB in...
I am trying to create a View in SQL Server 2000 to UNION several tables. I am getting an error "The Query Designer does not support the UNION SQL construct." The View is pretty straight for...
Hi,
I currently schedule to transfer several tables from IBM DB2 to MS SQL Server. The problem is I should only import data which occured during weekdays. I have to use query to specific da...
Hi Gang,
I need to query a SQL Server database using a stored procedure and pass the results to a Crystal Report, v9.
My SQL stored procedure needs to calculate an XIRR consistent with t...
In a company there are 2 groups of people. One group gets paid on commission 50% for all gross revenue they bring in. Another group gets paid on commission, but on a tiered basis. That is, som...
Hello ,
I need to know in a sentence wich is stored in a varchar column what is the position of a specific character ( the first occurence ).
I know that in PHP the code and the function are...
I have two tables: table1 and table2.
Here is query:
update table1
set table1.UseAsPrimary = 0
where table1.ID = table2.ID
and table2.UseAsPrimary = 1
The error is
The column pre...
Ok folks, Here's my situation.
Tomorrow I have to go and interview with the IT guy at a large company and convince him that I can do his project. They download a zip file with 30,000,000 r...
It seems that each time I create a new table it sets the fields to Latin1_General_CI_AS all original fields are SQL_Latin1_General_CP1_CI_AS.
Is there any way to change the default for...
Hi
I have a working store procedure that process an XML string received as a text parameter.
I would like to return a "nice" error to the client process if the xml string can't be parse...
Hi Dudes,
Will try to explain the question with an example.
----------
Delete Into tab1 ...
Begin Tran T2
Insert Into tab2 ....
Commit Tran T2
Rollback
-...
Another Newbie question -
I am executing a DTS Package thru Enterprise Manager ver. 8.0 by selecting Task button then execute.
Source = sql table
Destination = AS/400 file
In the Transfo...
