Viewing 15 posts - 1,201 through 1,215 (of 7,636 total)
Are they both running on the same server/instance and the same disks?
December 10, 2009 at 11:21 am
sqllearner-339367 (12/10/2009)
Lowell,Grant,Barry,As lowell suggested I executed stored procedure as following and attaching new execution plan.
set ansi_nulls on
go
SET QUOTED_IDENTIFIER ON
go
exec getorders 1,10,0,0,''
go
Much better.
December 10, 2009 at 9:42 am
sqllearner-339367 (12/10/2009)
For clarity I have posted the exact code of stored procedure and adhoc query below
...
From the above code we can come to know that queries are same in...
December 10, 2009 at 9:41 am
Looks good, Ron. Though I cannot test it right now to be certain, this is basically the approach that I would take.
December 10, 2009 at 9:34 am
Also, *please* stop going back and editing you previous posts and attachments, it's just making a confusing situation worse.
Instead, when you have new or corrected information or files, then make...
December 10, 2009 at 9:19 am
sqllearner-339367 (12/10/2009)
I have just named the temp tables differently. I have now include the execution plan for both adhoc and stored procedure, please take a look when you next...
December 10, 2009 at 9:16 am
And the two sqlplans in the attached ZIP appear to be for yet two more SQL queries, both completely different from each other and from the two queries above.
December 10, 2009 at 8:57 am
sqllearner-339367 (12/10/2009)
Hi Grant,Please find the xml version of execution plan for stored procedure followed by dynamic query below
Stored Procedure
...
FYI: these are for completely different SQL queries'
The first (stored procedure) is...
December 10, 2009 at 8:53 am
Roman-334857 (12/10/2009)
After googling found this
State=16 means that the incoming user does not have permissions to log into the target database. So...
December 10, 2009 at 8:27 am
Leaving my mistaken post out of it then, the outstanding question still is "Why does it choose to truncate to 6 decimal places?"
December 10, 2009 at 8:12 am
Since the View that you want to ALTER already exists, you cannot create is as a new object, but must instead retrieve it from the database's Views collection:
myview = db.Views("Test4_View",...
December 10, 2009 at 1:59 am
sknox (12/9/2009)
I beg to differ, RBarry. MAX() returns the maximum of the two values. So MAX(6,49) is 49.
Uuhhhh, ... right you are. Never mind. :blush:
December 10, 2009 at 1:38 am
Why not re-script them into a single file?
December 10, 2009 at 1:34 am
Viewing 15 posts - 1,201 through 1,215 (of 7,636 total)