Viewing 15 posts - 5,476 through 5,490 (of 5,503 total)
Yet another thought:
You could also use the max(Order_ID) instead of my +10 offset to generate new primary keys with ROW_NUMBER().
Therewith you could avoid the addtl. column. But instead of adding...
March 19, 2009 at 1:14 am
Hi,
as promised i looked a little deeper into the subject this evening and I think I found a way to deal with it without additional (permanent) tables.
The biggest disadvantage of...
March 18, 2009 at 4:56 pm
What you could do is to first insert the orders into the orders table by keeping the order details attached to it (adding a new colum of XML type).
SELECT
...
March 18, 2009 at 7:55 am
So, what is your requirement when it comes to two or more identical order names? (two or more separate nodes)
Do these have to be inserted as two rows in the...
March 18, 2009 at 5:11 am
If you cannot guarantee a unique value for a parent node, how it is determined whether the two order nodes (with the same order name) belong to one physical order...
March 18, 2009 at 4:42 am
Hi,
following a sample code that should do what you requested.
-- declaration of sample data
DECLARE @Orders TABLE (
Order_IDNUMERIC(18, 0) IDENTITY(1,1) NOT NULL,
NameVARCHAR(255) NOT NULL,
description VARCHAR(255) NULL
)
DECLARE @Orderdetails TABLE (
Orderdetails_ID NUMERIC(18, 0)...
March 18, 2009 at 2:20 am
Hi,
would you please explain a little more in detail what you're trying to achieve?
Basically, you could use the XQuery functionality of SS2K5 to get your data into the table.
If you...
March 17, 2009 at 12:38 pm
Lynn Pettis (3/16/2009)
I am not sure if anyone else feels this way, but I won't be hurt if Steve closed this thread.
I'm right with you Lynn!
The issues currently discussed do...
March 17, 2009 at 1:50 am
Did you notice, foxjazz didn't have to say anything within the last 70 (or so) posts? So he missed about 50% of the replies.
Maybe he's not interested anymore.
Or he...
March 16, 2009 at 1:30 pm
Even though we're drifting slightly off topic:
foxjazz (3/14/2009)
Do any of you know a language other than English? Spanish, as a second or German?
I do know a language other than English:...
March 14, 2009 at 8:16 pm
foxjazz (3/14/2009)
Why no one but me, is complaining about this is beyond my understanding.
Well, the reason might be very simple:
most of the others (C# programmers I presume you're talking about)...
March 14, 2009 at 7:41 pm
From my point of view both languages differ since their "parents" were developed for different use:
As per Wiki
"C was designed for writing architecturally independent system software, it is also...
March 13, 2009 at 3:48 pm
GSquared (3/12/2009)
...Funny. They look to me more like questions in an interview or a test. Maybe I'm getting cynical in my old age...
I had the same impression like...
March 12, 2009 at 1:32 pm
Hi Mujeeb,
you're welcome.
One correction though:
instead of using OPENXML you should consider XQuery, since
hardly anyone uses OPENXML anymore.
(quote from post http://www.sqlservercentral.com/Forums/FindPost672137.aspx"> http://www.sqlservercentral.com/Forums/FindPost672137.aspx )
I had to...
March 12, 2009 at 1:10 pm
Gail, Jack:
How can you be sure that the fragmentation question relates to indexing?
Why not Message Fragmentation in Service Broker? 🙂
March 12, 2009 at 10:49 am
Viewing 15 posts - 5,476 through 5,490 (of 5,503 total)