Viewing 15 posts - 5,161 through 5,175 (of 5,590 total)
Gary Hines (6/23/2009)
Background: We have a sales application that processes an XML packet sent...
June 23, 2009 at 2:58 pm
Florian Reischl (6/23/2009)
Roy Ernest (6/23/2009)
Florian Reischl (6/23/2009)
Roy Ernest (6/23/2009)
Did anyone see this requestHe has some nerve...:-)
Yep. There is the second part of the story:
http://www.sqlservercentral.com/Forums/Topic740368-146-1.aspx
it is good that you put a...
June 23, 2009 at 2:28 pm
kiranjanga2 (6/23/2009)
i am getting the error as (Invalid object name 'dbo.fn_hex_to_char'.)
kiranjanga2,
I've found the solution for your issue. However, since we're doing your work for you, it's only fair...
June 23, 2009 at 2:27 pm
David O (4/9/2008)
If you've go the maintenance window. I'd run dbcc dbreindex against...
June 23, 2009 at 2:13 pm
Jeff Moden (6/22/2009)
WayneS (6/22/2009)
Jeff Moden (6/20/2009)
June 22, 2009 at 11:22 pm
Lynn Pettis (6/22/2009)
How about this one? 😛Now I'm being called a troll.
Really now, shouldn't that be Saint Troll?? 😉
Absolutely. As anyone that has followed Lynn will know, any reference...
June 22, 2009 at 11:19 pm
Jeff Moden (6/20/2009)
June 22, 2009 at 2:46 pm
ktlady (6/20/2009)
Wayne, I added "select * from @tmp" at end of your code. And here is the result I get from.ColumnAColumnBTmpCol
a11:3:5:61356
a22:4:5245
Does this match the expectation?
Yes, that is what was...
June 22, 2009 at 2:44 pm
Gatekeeper (6/22/2009)
Well, I guess I was off a bit more than I thought I was.
No problem. When I saw the way he wanting his output, I knew it was going...
June 22, 2009 at 2:44 pm
Without an execution plan (see the article that Lutz referenced), we can't tell. That long-distance brain-meld just isn't working, so we don't have enough information.
That being said, I would bet...
June 22, 2009 at 2:39 pm
You can do it without an identity column:
/*
-- replace this code
SELECT @maxvalue
select identity (int, 1,1) as Id , col1, col2
into #ABS
from #test
*/
-- with this
select row_number() OVER (Order by Col1) +...
June 22, 2009 at 2:25 pm
Gatekeeper (6/22/2009)
This was answered 2 days ago: http://www.sqlservercentral.com/Forums/Topic738904-338-1.aspx
No it wasn't. Similiar, but yet completely different.
June 22, 2009 at 1:16 pm
HTH
-- NOTE - putting your sample code like this helps people quickly help you!
declare @list varchar(1000)
set @list = '1,11,2,22,3,33'
-- make an XML variable to hold the list
declare @xml XML
--...
June 22, 2009 at 1:13 pm
naveenreddy.84 (6/22/2009)
Depening on what value is send from the front end, i need to set the value for a...
June 22, 2009 at 12:50 pm
Based on your XML code above, what does your expected results look like?
June 22, 2009 at 12:44 pm
Viewing 15 posts - 5,161 through 5,175 (of 5,590 total)