|
Can the ISAM database be accessed via, say, OleDB or ODBC?
If it can, then a simple Export/Import package should do the trick nicely, shouldn't it?
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson
"Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin
Edbert
Sydney, Australia
|
|
|
|
|
Unfortunately the ISAM database cannot be accessed in this way.
|
|
|
|
|
I am getting a "Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated."
On My Sql Statement adn I can't figure out why, I have included my statement below, can anybody give me any pointers?
Declare @xmlDoc as varchar(1000)
DECLARE @DocHandle int
Declare @Loc_ORDER_REF varchar(50)
declare @loc_Order_Name varchar(50)
SET @Loc_ORDER_REF = 'Bollox'
declare @DateFormat varchar(10)
-- Get the Current Dateformat stored in l8_config
Select @DateFormat = 'dmy'--(select config_value from l8_config where config_name = 'SQLDATEFORMAT')
set dateformat @DateFormat
Set @loc_Order_Name = null
set @xmlDoc = '<Root><OPType>1</OPType><Purpose>45</ Purpose><Category>7</Category><IssueDate>23/10/2006</IssueDate><StartDate>23/10/2006</StartDate><ReviewDate>23/10/2006</ReviewDate><Brief>dzscdsxdfvszdf</Brief><IHC>1</IHC><SpecEvent>1</SpecEvent><Oedfin>6523</Oedfin><Oicfin>6523</Oicfin></Root>'
EXEC sp_xml_preparedocument @DocHandle OUTPUT, @xmlDoc
INSERT INTO OP_ORDER
(
[OP_ORDER_REF],
[OP_ORDER_NAME],
[OP_PURPOSE_ID],
[OP_CAT_ID],
[OP_ISSUE_DATE],
[OP_START_DATE],
[OP_REVIEW_DATE],
[OP_IHC_COPY],
[OP_SPEC_EVENTID],
[OP_OFF_ENT_DET_FIN],
[OP_OFF_IN_CHRG_FIN],
[OP_BRIEF_DESC],
[OP_DIV_FLAG]
)
SELECT
@Loc_ORDER_REF,@loc_Order_Name ,
Purpose,Category,
IssueDate , StartDate ,
ReviewDate ,
Case ltrim(rtrim(IHC))
when 'true' then 1
when 'false' then 0
else 0
end ,
case ltrim(rtrim( SpecEvent))
when 'true' then 1
when 'false' then 0
else 0 End , Oedfin, Oicfin, Brief, OPType
FROM OPENXML(@DocHandle, '/Root',2) WITH (Purpose int, Category int , IssueDate datetime , StartDate datetime ,
ReviewDate datetime , IHC bit, SpecEvent bit , Oedfin varchar(50), Oicfin varchar(50), Brief varchar(1000), OPType Bit )
EXEC sp_xml_removedocument @DocHandle
Select @@Identity
-- modified at 18:00 Monday 23rd October, 2006
"a fool will not learn from a wise man, but a wise man will learn from a fool"
"It is hard to fail, but it is worse never to have tried to succeed." - Theodore Roosevelt
"Success is going from failure to failure without losing your enthusiasm." - Winston Churchill
My Website || My Blogpx" targer="_blank">My Blog</a></div>
|
|
|
|
|
i have a query that returns 2 rows and i want to add 1 row manualy, so the final query would return 3 rows. can anyone help me with this?
cellardoor
|
|
|
|
|
Select your 2 rows into a view or temporary table, then add your additional row into that view/table.
Final step: select everything from that table/view.
Note: if you are using stored procedures, then temporary table will be
deleted automatically when the stored procedure is done (at least in SQL 2005)
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
select Column1,Column2 from MyTable
union
select 9000 as Column1,'whatever' as Column2
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
|
Hi,
In my report for the columns iam providing sorting feature.In the report header i have one image.
Image disappears when using sortable columns.That image originally appears when opening report, but disappears after sorting columns.
Why this happens.
Please help me.
Thanks in advance
|
|
|
|
|
i want to search for specific row in database:
first: stored procedure
create procedure search
@name varchar (50)
as
select * from members where name = @name
second:C#
-create connection and open it
-create command and set it to stored procedure
-create parameter and pass value i want to search for to that parameter
i want to know the index of that row sotred procedure returned to pass it to :
DataRow dataRow = dataTable.Rows[index]
to fill textboxs of other fields "phone,hire_date,email,..."
textbox.text = dataRow["phone"];
|
|
|
|
|
If your Stored Procedure only returns one result (because the field 'name' is unique) then the index would be 0, which is the first row in the DataSet/DataTable that you filled using the Stored Procedure.
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson
"Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin
Edbert
Sydney, Australia
|
|
|
|
|
hi all
i need to get the difference between 2 dates
so i use datediff function in SQL to get it but it doesn't work
eveery time it get te same output even if i change the dates i don't know where is the problem
select datediff(year,12/2/2000,getdate())
and the output is 106
tank
abdelhameed81
|
|
|
|
|
abdelhameed81 wrote: select datediff(year,12/2/2000,getdate())
Try putting the date inside apostrophes. Also, it is generally advisable to use the ISO format (yyyy-mm-dd) so that internationalisation problems don't arise.
e.g.
datediff(year, '2000-02-12', getdate())
|
|
|
|
|
Just to further explain what happend. SQL Server interpreted 12/2/2000 as 12 divided by 2 divided by 2000 which is 0.003. Since the the calendar in SQL Server starts on 1st Janurary 1900 you had actually requested the difference in years between 04:19:20 on 1st January 1900 and midnight on 12th February 2006 (or 2nd December 2006 if you use the American format) which is 106.
|
|
|
|
|
Hi
I want to find out the no of rows returned by a select statement in a stored procedure within the stored procedure
ie i have a select statement say
select * from employees where deptid=2
now for the no of rows returned i want to perform a calculation for each row in the stored procedure itself
how can i loop in it and get the no of rows and the records for each row to handle all these in the stored procedure rather than in the front end
Waiting for reply
Happy coding
Subhash
Subhash Chatterji
|
|
|
|
|
SQL cursor[^] to the rescue! 
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson
"Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin
Edbert
Sydney, Australia
|
|
|
|
|
|
Hi All,
If we have a table in database which has one of the columns as XMl, we can use that XML record.value('/fieldname[1]','varchar(10)') to get the actual value of the fieldname from that XML record.
But what if we don't know the exaxt name of the field whose value has to be fetched, but we are sure that the pattern we give in will only fetch us one record, then is there a way to specify a pattern matching stuff like a normal like statement using '%Something', which would give us all records ending in "Something".
How do i do this.
Pls guide me
Omkar
|
|
|
|
|
Hi,
I have the following tables:
Item (ItemID) and Item_Keyword(ItemID, KeywordID).
ItemID is a primary key in the Item table.
In the Item_Keyword table, both ItemID and KeywordID are foreign keys.
I need to select such ItemID, that has ALL specified keywords.
Thanks in advance for any idea/help
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
There might be a better way, but this will work:
specified keywords='C++','C#','ASP'
the where clause of the outer query will need to have the TotalWords = the number of specified keywords (3 in this case).
select itemid from (select count(*) as TotalWords, itemid
from item_keyword ik inner join keyword k on ik.keywordid = k.keywordid
where k.keyword in(<code>'C++','C#','ASP'</code>)
group by itemid) as tbl
<code>where TotalWords = 3</code>
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
Thanks, I cam up with the similar solution.
My concern is, that if there are 3 keywords, say 'Java','C#','ASP',
this query will still select it, or wouldn't it?
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
Elina Blank wrote: My concern is, that if there are 3 keywords, say 'Java','C#','ASP',
this query will still select it, or wouldn't it?
I don't understand the question. Please clarify.
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
Sorry, you are absolutely right!
It works, thanks a lot!
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
I have created a win service which executes a long latency SQL Server stored procedure. The service sits on a different server than SQL Server. If the win service server unexpectedly crashed right after I have called the stored procedure, would the stored procedure continue its execution or fail because the connection was lost?
|
|
|
|
|
I'm trying to run the following ODBC command. It's returning 0 when I'm expecting a positive integer. Can anyone see where I'm going wrong?
ok=DBC (PREPARE, db_conn, "SELECT c.QuestionID FROM (SELECT DISTINCT QuestionID FROM Questions WHERE TopicID = ?) AS c LEFT OUTER JOIN (SELECT DISTINCT QuestionID, UserID FROM UserResponses WHERE UserID = ?) AS d ON c.QuestionID = d.QuestionID WHERE d.UserID <> ? OR d.UserID IS NULL ORDER BY c.QuestionID": db_stmt)
I am (fairly) confident that the SQL is correct as it is performing as expected when tested in Visual Web Developer.
Thanks,
Alice
|
|
|
|
|
In my ASP.NET.net site ,I sometimes(but not always) get this error :
Timeout expired.The timeout period elapsed prior to completion of the operation or the server is not responding.
I think its sql server error . Someone tell me how I can solve this problem.
I need urgent help .
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
