Viewing 15 posts - 11,146 through 11,160 (of 26,486 total)
How about this:
select
es.session_id,
er.session_id,
er.dbid,
db_name(er.dbid)
from
sys.dm_exec_sessions es
inner join sys.dm_exec_requests...
June 21, 2012 at 2:51 pm
ssc_san (6/21/2012)
Here is the sample code, I am trying to get the Max three letter field and date associated to it, the query mentioned in...
June 21, 2012 at 2:42 pm
Yes, you need to look at the articles in my signature block regarding cross tabs. There are two and I recommend reading both. The second, if I remember...
June 21, 2012 at 2:32 pm
This is why I like SIDs, you can have a unique key that never changes that can be used for just such cases.
Does the table have any other candidate keys...
June 21, 2012 at 2:23 pm
Give this a try. It is untested as you didn't provide DDL, sample data, or expected results.
SELECT
p.PARTNUMBER,
p.DESCRIPTION,
STUFF((SELECT...
June 21, 2012 at 2:17 pm
Evil Kraig F (6/21/2012)
yb751 (6/21/2012)
What would be the best stategy for creating a new partition on the main table in such a way that...
June 21, 2012 at 1:31 pm
I also think there is more to it than what is in OPs initial post.
June 21, 2012 at 1:29 pm
nithiraja.r (6/21/2012)
11112322aaa1
11112422aaa1
22222522bbb0
22222521bbb0
33332520ccc1
Here the NO column is not a identity column. I need to write a query to populate unique NO from the table which has highest mark1.if the mark1 value...
June 21, 2012 at 1:23 pm
Been a while since I even created a partitioned table, but bassed on the information provided so far, I have absolutely no idea, not even a shot in the dark.
It...
June 21, 2012 at 1:18 pm
Your heading is the entire error message? Doesn't tell me a thing, sorry.
June 21, 2012 at 1:07 pm
Not without greater detail. Please read and follow the instructions in the first article I reference below in my signature block. It will walk you through the things...
June 21, 2012 at 1:06 pm
I have to agree with Craig. There isn't enough information to even give you a shot in the dark. Please read the article that he suggested, it will...
June 21, 2012 at 12:57 pm
ssc_san (6/21/2012)
I was expecting the maximum value for the code mentioned below to be "005", but it is different,
Could someone explain, If hyphen "-" is preceded in the...
June 21, 2012 at 12:55 pm
Not sure what your problem/question is here, care to elaborate?
June 21, 2012 at 12:51 pm
herladygeekedness (6/21/2012)
If the former, I'm not sure how to help unless you can right-click the...
June 21, 2012 at 12:49 pm
Viewing 15 posts - 11,146 through 11,160 (of 26,486 total)