Viewing 15 posts - 1 through 15 (of 61 total)
Have made a few changes:
Only looks at databases which are online, also added square brackets by the "USE" statements in case a database has an illegal character e.g. a number...
November 12, 2013 at 3:21 am
Tried Googling it?
July 12, 2013 at 8:44 am
can u give me example with indexes
July 12, 2013 at 8:30 am
Assuming I've understood what you're on about you might have to do your delete as:
DELETE FROM dbo.cart C
LEFT OUTER JOIN
June 21, 2013 at 8:30 am
WHEN NOT MATCHED BY SOURCE AND
June 21, 2013 at 7:53 am
You might be suffering from parallelism. If you run this
And see several rows of the same SPID then there might be a parallel query issue
Then try this:
MERGE dbo.cart AS c_target
June 21, 2013 at 7:28 am
When you say "hanging" what do you mean? I take it as there is something blocking which in turn implies that the update would not complete.
Like I said, check any...
June 21, 2013 at 7:21 am
Have you seen why it is hanging? Is it being blocked by another process?
June 21, 2013 at 7:05 am
You're going to have a problem as it looks like you want to update a join key on the PO Table
Why do you want to update the PO Table? Which...
June 19, 2013 at 7:43 am
Trying to run a .NET statement in SSMS (?) :unsure:
June 2, 2013 at 6:08 am
Thanks for the tip but it doesn't seem to have worked. Basically my CLR is a modified version of this:
July 25, 2012 at 1:40 am
January 31, 2012 at 5:00 am
In essence I checked the flat file source and previewed the data. I saw that for some reason the odd numbered rows (i.e. rows 1,3,5,7,9 etc) seemed to be ignoring...
October 12, 2011 at 11:13 pm
All sorted, it was carriage return/line feed weirdness :blush:
October 12, 2011 at 1:15 pm
Seems to have been sorted. In the Excel source editor I changed the table source from the worksheet name to worksheet name $
So from "SourceSheet" to "SourceSheet$" and it worked...
September 20, 2011 at 9:44 am