Viewing 15 posts - 8,986 through 9,000 (of 15,381 total)
John Hanrahan (3/21/2013)
March 21, 2013 at 2:35 pm
You are not new around here so you shouldn't be surprised that we need a bit more to go on. Once you post ddl (including indexes), sample data and desired...
March 21, 2013 at 2:21 pm
I don't understand why you doing the left join? You say something about making sure the values are ok. That is the point of the foreign key, so you don't...
March 21, 2013 at 2:17 pm
markcrosbie (3/21/2013)
The other problem is that the number of columns could also change having more answers. I...
March 21, 2013 at 2:09 pm
markcrosbie (3/21/2013)
id | answer1 | answer2 | answer3 | answer4 | answer
1 abc ...
March 21, 2013 at 12:53 pm
You aren't new around here so you shouldn't be surprised that we need to see ddl, sample data and desired output. Please take a few minutes and read the article...
March 21, 2013 at 12:49 pm
carlosaamaral (3/21/2013)
Sean Lange (3/21/2013)
carlosaamaral (3/21/2013)
MID=(CASE WHEN ID-100=0 THEN NULL
...
March 21, 2013 at 12:41 pm
This should work. I think you were pretty close but the RC one is a little bit more difficult.
select Name,
case
when Max(id) < 4 then 'R'
when MAX(id) = 4...
March 21, 2013 at 12:40 pm
chandni.247 (3/21/2013)
March 21, 2013 at 10:23 am
carlosaamaral (3/21/2013)
MID=(CASE WHEN ID-100=0 THEN NULL
...
March 21, 2013 at 10:19 am
mehta.saurabhj (3/21/2013)
tim_harkin (3/21/2013)
If you are talking about the index definitions, then yes they are still there. Index data is gone - their pages are deallocated as well.
I mean to...
March 21, 2013 at 9:15 am
mehta.saurabhj (3/21/2013)
When we truncate the table does the indexes made on them exists in memory??Can we check whether they exist or no???
Not really sure what you mean about indexes being...
March 21, 2013 at 8:41 am
Agreed that if using 2012 there are easier options. Also would be better if we knew what your requirements are. I took a shot in the dark.
;with Data(ID)
as
(
select 100 union...
March 21, 2013 at 7:49 am
Lynn Pettis (3/21/2013)
Sean Lange (3/21/2013)
Lynn Pettis (3/20/2013)
Sean Lange (3/20/2013)
March 21, 2013 at 7:39 am
Viewing 15 posts - 8,986 through 9,000 (of 15,381 total)