I have an application that inserts data into tblBox. tblBox is comprised of (TranID, PO, BoxNo, Username,SiteID, EnteredTime). Somehow I need to also insert a part of this data into another ta...
I current have a DTS package that contains the import of a text file (looping thru a list of text files), unfortunately, the package fails if the delimiter is off - meaning the actual text ali...
I have a stored procedure and I like to call this from select script.
This stored procedure returns a record with one column wichi is a recordset by select command inside.
How to call a stor...
Hi all,
I have a field with the following datatype: decimal-->precision (7) , scale (0), identity(yes), identityseed(1), increment(1) and here is what i want:
i want the field store 0000001 ...
did something really stupid
-got a local sql db
-restored a different backup set from the remote version of this db
but lost all other tables that were added in the local version, inclu...
i have a column defined as text. It has some numeric entries and some text.
I will be accessing the column with excel and it needs to look at the numeric values as numeric and not text.
...
I've used basic triggers for inserts, but never for an update and I searched and didn't quite find anything like this.
I guessed:
CREATE TRIGGER logchanges ON [dbo].[maintable]
FOR UPD...
I am trying to get XML file information passed into a stored procedure so that I can insert it into my database. If I hardcode the xml into the stored procedure, everything works fine. But i...
I am using SQL 7 with service pack 4
the sql server gives this error and terminates the application when application is run again it runs normally
"The MSSQLServer service terminated un...
I manage an MSSQL 2000 Windows 2000 server with about 100 databases on it for various customers. All of these customers manage their databases remotely via Enterprise Manager and scripts on t...
Ok here is the problem
SELECT 1602/4 AS rVALUE
should return 400.5 correct?
its returning 400.
What made me relize this was the return between an Access DB and its SQL Replacement...
I copied a database file (MDF) and it's related logs from one server to another. I am now trying to attach the database, and get:
Error 3624
Location: filemgr.cpp:1890
Expression: fcb-...
This is driving me crazy... here's my current code:
CASE WHEN [Plank6Num]> 0 AND [Plank6Num] IS NOT NULL THEN '6,' END
+ CASE WHEN [Plank8Num]> 0 AND [Plank8Num] IS NOT NULL THEN '8,' END...
hi all
i have a field which is stored as a varchar(30). I need it as varchar as the value can be characters or numbers etc.
in some case i need to add two of these fields when the tex...
I need to import 3 text source files of 10 rows each. I've created the DTS package to perform these imports however now I want to add additional logic into the package. I want to check the ...
Hi,
The scenario is - I have to transfer n number of excel file data to sql server 2000 and the excel fields are varying. so different activex task are defined. excels results are queried i...
I am trying to free log space - data size: 4GB space available 2.2 GB, log size 550MB space available 0 MB. I have allocated more space to the database device, then expanded the log (which is...
I have SQL Server Enterprise Addition with newly installed Analysis Services, we are trying to install MS Project Server to test an Enterprise Project Configuration company wide. I see that I...
I am trying to use BCP to get a text file into a table. I have never used BCP before and am having trouble getting it to work. I thought if I showed you guys what I have so far, you may be abl...
I have created 2 jobs in DTS which run fine,
But when i schedule them to run they error
with this log.
Executed as user: ORION\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTS...
Hello,
I needed to migrate the 'msdb' from ServerA to ServerB.
I put ServerB into single user mode using C:\......sqlservr.exe -m -c
I restored the 'msdb'
Now....How do I get ServerB bac...
I am using this SQL Query
SELECT c.ID, d.*
FROM Company c RIGHT OUTER JOIN
OPENQUERY(Dynamics,
'SELECT h.CUSTNMBR, s.ITEMNMBR, MONTH(h.DOCDATE) AS CubeMonth,
SUM(s.QTYTOINV) AS CubeQty,...
Hello,
Some bizarre stuff is happening here, first my setup.
- MS SQL2000 sp2 on a remote server (Win2k-sp2) (LAN / WAN)
- SQL Query Analyser (sp3) on my desktop (Win2k - sp2)
Now, see...
I have a malformed SQL statment and not sure how to fix the syntax
Set Rs9 = Cn.Execute ("select (count(*)) as val, survey.questionid, surveyquestions.questionid from survey, surveyquestion...
I have a varchar field that has both numeric and alpha values. I want to pull only the numeric values. I've tried CONVERTing and CASTing, > 0 and everything else I can think of. Can anyone els...
