Viewing 15 posts - 6,061 through 6,075 (of 15,381 total)
Koen Verbeeck (12/19/2013)
GilaMonster (12/19/2013)
Not that I would stoop so low as to beg for votes, but I do need a new costume (Star trek if anyone cares)https://www.surveymonkey.com/s/TribalAwardsVoting
😀 :hehe: 😉
I am...
December 19, 2013 at 2:21 pm
Please don't cross post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1524759-391-1.aspx
December 19, 2013 at 1:13 pm
Did you try google???
https://www.google.com/#q=Where+can+I+down+load+SQL+Server+2012+Upgrade+Adviser%3F++
That is the exact title of your thread (including the incorrect spelling of Advisor). The very first return takes you to the technet page that discusses the...
December 19, 2013 at 1:02 pm
Hi and welcome to the forums. In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form...
December 19, 2013 at 10:35 am
spaghettidba (12/19/2013)
What about UNPIVOT?
I don't use UNPIVOT a lot because I don't have tables denormalized like this as a general rule. You got me curious so I put together one...
December 19, 2013 at 10:33 am
vignesh.ms (12/19/2013)
Sean Lange (12/19/2013)
Not quite sure what you want for output? What should the query do or return?query should return if 10 continues nos is available in unused state ...
Then...
December 19, 2013 at 9:30 am
... Got bitten by the quote bug...
It seems Lowell was on top of this already.
December 19, 2013 at 9:20 am
Something like this?
declare @Threshold int = 340
select MIN(TimeStamp)
from YourTable
where LoadTemp1 > @Threshold
or LoadTemp2 > @Threshold
or LoadTemp3 > @Threshold
or LoadTemp4 > @Threshold
If you have a lot of data this is going...
December 19, 2013 at 9:15 am
Not quite sure what you want for output? What should the query do or return?
December 19, 2013 at 8:53 am
abhas (12/19/2013)
Hi,Sorry Sowbhari,
its working.
DECLARE @StartTime VARCHAR(MAX),@X XML
SELECT @StartTime = '7:00 AM <br/> 12:30 PM'
SELECT @X = CONVERT(XML,'
' + replace(@StartTime,'<br/> ','</br>
') + '</br>')
SELECT x.i.value('.','varchar(max)') AS [StartTime]
FROM @X.nodes('//br') x(i)
Thanks.
I would again...
December 19, 2013 at 8:01 am
Take a look at this article. It explains how to do exactly what you are trying to do here.
December 19, 2013 at 7:59 am
vignesh.ms (12/19/2013)
Please consider the following data
create table #sampletbl
(
Category varchar(100),
Numbers varchar(100),
Status varchar(100)
)
insert into #sampletbl values ('A','29710000001','0')
insert into #sampletbl values ('A','29710000002','0')
insert into #sampletbl values ('A','29710000003','0')
insert into #sampletbl values ('A','29710000004','0')
insert into...
December 19, 2013 at 7:53 am
Jeff Moden (12/18/2013)
December 19, 2013 at 7:28 am
Everyone on this thread should take a look at the link in my signature for splitting strings. In there you will find a number of ways to split a string...
December 19, 2013 at 7:24 am
mcfarlandparkway (12/18/2013)
Need help please!!
Help us to help you by posting some details and we can help. This is at least the third time in this thread alone you have been...
December 18, 2013 at 2:38 pm
Viewing 15 posts - 6,061 through 6,075 (of 15,381 total)