Viewing 15 posts - 3,931 through 3,945 (of 5,502 total)
Hard to tell based on that limited information...
Please provide table def, sample data and your update query (or is it a cursor????).
For details on how to post sample data please...
March 23, 2010 at 10:02 am
What exactly is your question?
Please read and follow the first link in my signature on how to post sample data.
In your specific case: It is more than likely that you...
March 22, 2010 at 2:59 pm
register 97758 (3/21/2010)
March 21, 2010 at 5:45 pm
Roust_m (3/21/2010)
CirquedeSQLeil (3/19/2010)
You say the execution plans are the same. Is that the estimated or the actual exec plans?How many rows difference is there between the environments?
Both estimated and...
March 21, 2010 at 5:36 pm
Would the following code snippet help you?
DECLARE @xml XML
SET @xml=
'<?xml version="1.0" encoding="UTF-8" ?>
<locations>
<location>
<id>11111</id>
<name>Business Name</name>
<address>
<street>111 Street Address</street>
<delivery_point/>
<city>City Name</city>
<state>ST</state>
<postal_code>44444</postal_code>
<cross_street/>
<latitude>33.00</latitude>
<longitude>-100.00</longitude>
</address>
</location>
</locations>'
SELECT @xml
SELECT
c.value('id[1]','int') AS id,
c.value('name[1]','varchar(30)') AS name,
v.value('street[1]','varchar(30)') AS street,
v.value('city[1]','varchar(30)') AS city
FROM @xml.nodes('locations/location') T(c)
CROSS APPLY
t.c.nodes('address')...
March 21, 2010 at 4:40 pm
It seems like we have to start at the very beginning:
"Niederschlag" should be stored as a numeric value.
What you're trying to do is to change the german decimal notation to...
March 21, 2010 at 10:00 am
ihsanps (3/21/2010)
HI ,...
Can you give me an example script or some useful links to run this Cursor or give me an example i can do row by row operations.
...
No....
March 21, 2010 at 9:36 am
Step 1: try to get your code for the insert and update right (that is performing it not row by row but set based). Once that's done, we'll help you...
March 21, 2010 at 9:01 am
What are you trying to do?
It seems like you won't need a cursor for it.
Side note: you can drop me a PM if you prefer to continue in German (my...
March 21, 2010 at 8:37 am
Hi Prakash,
either the column names you provided is wrong or you're using the wrong column (PId=31).
Other than that I guess you want to find the rows where your parameters are...
March 21, 2010 at 5:01 am
I think it's a great question.
Not because I've got it right (I didn't).
But it started a discussion on what we think about the QotD responsibilities in general. Instead of...
March 19, 2010 at 3:57 pm
Here's what I came up with:
DECLARE @xml XML
DECLARE @strFieldName VARCHAR(200)
SET @strFieldName = 'txtFieldSubmitURLH'
SET @xml='
<panel>
<name>coolingContent</name>
<question...
March 19, 2010 at 3:15 pm
What you could use is a query like the one below.
The disadvantage is that it will query all nodes on each and every level within the file.
What I'm trying to...
March 19, 2010 at 2:04 pm
I'm guessing you 're trying to insert data in the wrong format.
Most probably it's caused by the format you're trying to insert conflicting with the current setting of DATEFORMAT.
Example:
SET DATEFORMAT...
March 18, 2010 at 7:03 pm
I'd recommend using a calendar table as a left outer join part. If you don't use one already you might want to have a look at the Tally table article...
March 18, 2010 at 6:38 pm
Viewing 15 posts - 3,931 through 3,945 (of 5,502 total)