Viewing 15 posts - 361 through 375 (of 595 total)
Could you do a quick Response.Write on your querystring and post the results? Are you absolutely positive that the string being passed to the Recordset.Open method is the same...
June 6, 2003 at 1:33 pm
The SQL is correct. Perhaps you could post an error message or the VB/ASP code you are using?
June 6, 2003 at 12:49 pm
quote:
can I user If condition in cursor
Yes, you can use it same as if you...
June 6, 2003 at 12:30 pm
Try:
SELECT LEDef_PK
FROM LEDef
WHERE LEDef_ActiveInd = 1
AND LEDef_Cd LIKE '10-%'
June 6, 2003 at 12:20 pm
How are you obtaining the resultsets? If from ADO, be sure to set the IsolationLevel of the ADODB.Connection object to ReadUncommitted. If from SQL, then you can issue...
June 6, 2003 at 12:01 pm
If you can rely on a child only having 1 parent, then use a linked list approach, built on a single table:
CREATE TABLE Nodes
(
NodeID...
June 6, 2003 at 11:57 am
1) Fillfactor: This depends on how often you rebuild the indexes. If you can rebuild the indexes directly after the DELETE/INSERT, and there are no updates throughout...
June 6, 2003 at 11:45 am
quote:
...I've a bunch of php scripts which comprise a DB. I'd like to import the php scripts into mssql 7.0 to...
June 6, 2003 at 11:23 am
quote:
I would like to have 009 in a numeric field but it save it as 7.
June 6, 2003 at 11:18 am
quote:
ok, how do i avoid the ERROR:"divide by zero error encountered"
Use a CASE expression in...
June 5, 2003 at 1:56 pm
satish,
Take a closer look at my earlier query. The DELETE FROM Orders FROM Orders was actually not a typo, although I admit that the SQL syntax in this situation...
June 5, 2003 at 12:41 pm
You don't want the SUM in the percent part, plus you can't use aliases in the SUM expression...must use the full expression. If you don't want to do this...
June 5, 2003 at 12:31 pm
satish,
the AS is technically optional, so you can remove it if you want. Other than that, my colleague and I can't see anything wrong with it. However, to...
June 5, 2003 at 12:24 pm
Or, neither of those solutions and normalize the data:
CREATE TABLE Interest
(
Code CHAR(1) NOT NULL
, Description VARCHAR(100) NOT NULL
)
CREATE TABLE [User]
(
...
June 5, 2003 at 12:15 pm
Viewing 15 posts - 361 through 375 (of 595 total)