|
Update question
I have table ORDERITEMS, where I have items of orders for different
countries (different countries can have the same order ids):
COUNTRY_ID
ORDER_ID
ITEM_ID
VALUE
POSITION
I would like to UPDATE position of item of the order regards to it's value.
The item with greater value should have greater positi ...
Thu, 6 Jan 2005 17:05:34 +0100
|
SP for list of table dependencies
Hi
I need to write a SP to generate a list of
(a) all the tables that reference tableX (ie they have a foreign key that
links to this table)
(b) all tables that tablex references (ie tablex has a foreign key that
links to them)
Thanks in advance
John
...
Thu, 6 Jan 2005 11:04:10 -0500
|
Update question
Is there a more efficient update statement to update a country field with
either US of CA, in one statement? Currently I use two Update statements.
Thanks. ...
Thu, 6 Jan 2005 07:49:01 -0800
|
Continuous varchar data
I have got following type Records. I need that I have to check continuous
record structure like following table.
idCol StartPort EndPort
1__A to B <-- Rec1
2__B to C <-- Rec1
3__C to B <-- Rec1
4__B to A <-- Rec1
5__B to A <-- Rec2
6__F to Z <-- Rec3
7__Z to F <-- Rec3
How can I check this continuo ...
Thu, 6 Jan 2005 17:47:06 +0200
|
Crosstab query
I am new to SQL Server programming. I am trying to upgrade my MS Access
database into SQL server. I have got the tables imported into SQL server.
Amongst the queries I have, is a crosstab query in MS Access which I am
trying to make it work in a similar way in SQL server. My table has records
containing, eg ...
Thu, 6 Jan 2005 07:27:02 -0800
|
Latest Record (again)
Hi there
I still can't get this to work
Table Paul
F1 Char ----Name
F2 Smalldatetime ----Event Date
F3 varchar(30) ------Event Action (choce list on the front end)
Data:
F1 F2 F3
---- --------------------------- ------------------------------
A ...
Thu, 6 Jan 2005 07:19:01 -0800
|
Problem with NULL--
Hi,
I am getting 'Zero' instead of null.
Here is the situation
declare @XML nvarchar(400)
declare @hDoc int
DECLARE @int int
set @XML = ''
exec sp_xml_preparedocument @hDoc out, @XML
select @int = isnull(tag,9)
from openxml (@hDoc, '/XML')
with (tag int 'tag')
select @int
He ...
Thu, 6 Jan 2005 20:07:32 +0530
|
Procedures
Hello,
I have a small procedure that I want to apply to a table. What is the
syntax for that?
CREATE PROCEDURE foo @in VARCHAR(32), @out OUTPUT
AS
[...]
DECLARE @output VARCHAR(255)
UPDATE tablename SET column = (EXECUTE foo 'Andrew', @output OUTPUT)
-- this isn't right...
Thanks,
Andrew ...
Thu, 06 Jan 2005 14:29:13 GMT
|
Anyway to Make Query More Efficient?
Here is my query:
Use WinPayment
GO
SELECT
pos_condition_code,
convert(char(11), retrieval_reference_number) RR,
message_type,
authorization_identification,
convert(char(8), card_acceptor_identification) SN,
convert(char(25), transaction_name) TransactionName,
isnull ...
Thu, 6 Jan 2005 06:27:05 -0800
|
alter tables add 365 columns
i need to create a table with a column for every day of the year
but i don't feel like typing everything manually
so far i have this
CREATE TABLE tblMyTable
(
Column01PK int NOT NULL IDENTITY(1,1) PRIMARY KEY,
Column02 NVARCHAR(50) NOT NULL
)
GO
DECLARE @x int
@x = 1
WHILE @x < 366
ALTER TABLE ...
Thu, 6 Jan 2005 06:25:04 -0800
|
Aggregating strings
I have a select like
select Contact_FirstName + ' ' + Contact_LastName as ContactName
from tblContact where Contact_ID = XXX
I would like to use this result as a derived column in a larger
SELECT, but the problem is that there can be multiple records matching
here, and I would like one string returned. So ...
Thu, 06 Jan 2005 14:13:33 GMT
|
reduce physical memory usage by updating ntext field
Hi,
I have 5 ntext fields that have 40k value string each for every record
The table has 23,000 records so the table occupies about 3G of data.
So I tried to changed values inside the ntext fields to be a string such as
'Deleted' in order to free some memory, this data in no longer needed.
I have used Updat ...
Thu, 6 Jan 2005 06:09:06 -0800
|
Copy complete tables - What is the best pattern?
Hi Space!
I need some pattern (optimized for ressource usage and then speed) for doing
the follwowing:
In my DB there are two tables "TableA" and "TableB" which are complete
identical (100% same schema).
TableA is the "master" tabele which will be updated (add, update, delete
entries) from the administ ...
Thu, 6 Jan 2005 05:59:02 -0800
|
Surrogate Key
Hi, all gurus
Can any one guide me about what is Surrogate Key, how it differ from others.
--
Thanking You
Amish M Shah
Sr.Software Engineer
IntraAction Software(Ahmedabad, India)
Mo - 9879398697
...
Thu, 6 Jan 2005 19:10:08 +0530
|
Help with performance of sql construct - reduced version
Hi, I've made the problem a bit more simple:
declare @i int
set @i = 0
select ID_Address from tblAddress WHere ID_Address like CASE WHEN @i = 0
THEN '%' ELSE @i END
returns an error; "Syntax error converting the varchar value '%' to a column
of data type int". Is there a way not to use CAST in order t ...
Thu, 6 Jan 2005 13:23:44 -0000
|