Viewing 15 posts - 2,416 through 2,430 (of 5,504 total)
Here's a "slightly" different approach:
Instead of Openxml I use XQuery together with CROSS APPLY for referencing outer node attributes.
To catch the ID values from the insert statements I make use...
December 15, 2010 at 2:23 am
Paul White NZ (12/14/2010)
...There's no Halloween protection with the loop join plan for reasons that should be obvious to anyone that knows what Halloween protection is 😉 😎
...
What would it...
December 15, 2010 at 1:38 am
Two more issues from my side:
#1: Can you post the code from inside the c.u.r.s.o.r. *cough*? In most cases such a loop can be replaced with a set based solution...
December 15, 2010 at 1:25 am
billj-705548 (12/14/2010)
December 15, 2010 at 1:11 am
krishusavalia (12/14/2010)
Thanks for your fast reply,,,but InternalID is defferent in all the tables.I am facing the difficulty into pass the identitly value of Child table to the appropriate Kid values.
Which...
December 14, 2010 at 4:34 pm
Here's a possible solution:
Please note that I used 'Make' as a hard coded value since it's used to limit the result set anyway (@ParameterName="Make"). therefore it doesn't make sense from...
December 14, 2010 at 4:27 pm
Will it ever happen that the source file could have data with identical Parent InternalID's, Child InternalID's or Kid InternalID's repeated within different nodes?
Something like
Parent InternalID="154805"
__Child InternalID="4926250"
____Kid InternalID="3406436"
__Child InternalID="xyz"
____Kid InternalID="3406436"
Parent...
December 14, 2010 at 3:49 pm
Any chance to post the index def for #DelPortList and PortSecAgg? It seems like the clustered indexes don't match.
And now I'm totally guessing: batch001 doesn't have a spool since there...
December 14, 2010 at 3:33 pm
I'm sure this sproc did never run before since the syntax is incorrect.
My guess would be that the lower part of the query (starting with "6 = receipts") usually is...
December 14, 2010 at 2:45 pm
Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?
Yes. More or less. 😀
December 14, 2010 at 2:36 pm
CirquedeSQLeil (12/14/2010)
Does this frighten anybody else? ...
Not as much as the reverse version of "99 bottles of beer" going on right now regarding Stefans "join performance" issue...
While we're at it:...
December 14, 2010 at 2:17 pm
adonetok (12/14/2010)
I tested it but became 'Jan 1 1900 12:00AM'
The reason is rather simple:
Internally, SQL Server stores datetime values as two 4-byte integers (see BOL for details).
A blank string...
December 14, 2010 at 1:18 pm
Can you change your 2008 c.u.r.s.o.r. * cough* declaration to use TOP 1 so you have just on path and post the actual execution plan of it together with the...
December 14, 2010 at 12:56 pm
parthi-1705 (12/14/2010)
PRINT (CAST(12001 AS INT)/1000 + (CASE WHEN 12001%1000=0 THEN 0 ELSE 1 END))*1000
Actual data is in float so we cant use modulo operator
Thanks
Parthi
Then you'd just have to cast...
December 14, 2010 at 12:41 pm
GSquared (12/14/2010)
Alvin Ramard (12/14/2010)
I'd prefer a picture of the horse stepping on the iPad. 😀How about a horse stepping on an iMat?
With an iMat Michael Flatley surely would have...
December 14, 2010 at 11:53 am
Viewing 15 posts - 2,416 through 2,430 (of 5,504 total)