Viewing 15 posts - 9,811 through 9,825 (of 15,381 total)
SoberCounsel (12/18/2012)
December 18, 2012 at 7:56 am
gheinze (12/18/2012)
I search a lot for this issue but I can't realize what happen.
The case is, randomly (no very often, but last two weeks happend) we experiment problems...
December 18, 2012 at 7:52 am
Here is an example using the DelimitedSplit8K function that you can find at the link provided, or you can follow the link in my signature for splitting strings.
;with cte (Col1)...
December 18, 2012 at 7:48 am
As Scott said learning the dynamic sql technique is a good one. And he is correct that sp_msforeachdb has a bit of overhead. I would however say that with 700...
December 18, 2012 at 7:25 am
aha!!! I had a feeling this was a loop through all the databases on my server and do something kind of situation. In general cursors are to be absolutely avoided....
December 17, 2012 at 3:39 pm
Brandie Tarvin (12/17/2012)
Steve Jones - SSC Editor (12/10/2012)
Saw this and thought of Brandie: http://scott-lynch.livejournal.com/159686.htmlAn Author's response.
Hee.
I think I just found my next kindle title. 😀
December 17, 2012 at 3:20 pm
zilla (12/17/2012)
December 17, 2012 at 2:43 pm
asita (12/17/2012)
yeah you are correct.
but the thing is, we can take any assumption but the out put need to match
just require to get that outcome, it is really a...
December 17, 2012 at 2:32 pm
eugene.pipko (12/17/2012)
Thanks for reply,I've changed "begin tran" to "BEGIN DISTRIBUTED TRAN", but still getting the same error.
Is there anything else I need to change?
If that is all you did I...
December 17, 2012 at 2:26 pm
ColA looks like just a ROW_NUMBER for each Territory.
select *, ROW_NUMBER() over(Partition by Territory order by Name) as ColA
from TestTask1
for col2 it will be based on sales_amount (duplicate value consideration)
same...
December 17, 2012 at 2:17 pm
You need to enable and utilize distributed transactions. http://msdn.microsoft.com/en-us/library/ms188386%28v=sql.105%29.aspx
December 17, 2012 at 12:14 pm
justfillingtime (12/17/2012)
I have a quick question. My code below shows the data I'm pulling from my temp table
select
[year],[date],[dayofweek],[daynum],
cast(count(CASE WHEN area = 'City & County' THEN 1 END)...
December 17, 2012 at 9:30 am
Andre Ranieri (12/17/2012)
December 17, 2012 at 9:27 am
Lisa Liel (12/15/2012)
Sean Lange (12/14/2012)
December 17, 2012 at 7:40 am
sgmunson (12/14/2012)
Sean,I wonder if the OP has a case-sensitive collation in place and just miscapitalized something?
That could be...didn't even think about being a case-sensitive collation.
December 14, 2012 at 3:31 pm
Viewing 15 posts - 9,811 through 9,825 (of 15,381 total)