Viewing 15 posts - 1 through 15 (of 28 total)
Yes. I want only one column as the output. And the condition for the output is the <blank> value in one of the columns. In my table, only one column...
January 30, 2013 at 11:09 am
Thank you Mr.Ron. It worked like a champ. I just had it tweeked a little bit to suit my requirement. Yes. It is indeed an odd requirement to store a...
January 25, 2013 at 12:24 pm
Hello Lowell,
I am sorry i forgot to add the primary Key in the Master_Detail Table. Yes, there is one primary key called Detail_Id (as you mentioned) which is the key...
January 25, 2011 at 2:18 pm
Thanks a lot for the guidance Ron. Was very helpful. The code was right. One of the values in the Number column of table had length more than 6 and...
April 9, 2010 at 7:12 am
Thanks a lot. I tried soemthing like this initally, but did not do order by. I did give a sample table (i has to edit initial post) ...dont know for...
April 5, 2010 at 2:34 pm
oh..thatz quite something...Well..thanks for letting me know..i will work on it and see if i can succeed in restoring the differential now..
March 6, 2009 at 1:35 pm
I will do so... but now i tested a sample..After i restored the full backup with NORECOVERY, i found that in the console tree, the database seems unavailable..It says NO...
March 6, 2009 at 1:04 pm
Thanks a lot...i understood what is the difference..and it worked just fine now :D:)
March 5, 2009 at 2:55 pm
Thanks,
But there are no topics for incremental backup in Books online. I need to learn how to setup incremental bakps that runs every 4 hours and how can i get...
February 3, 2009 at 10:35 am
I am not familiar with views. However, will give it a try using help topics.
How do i script all the 1000 procs without using the console? I mean sp_help juist...
October 9, 2008 at 10:06 am
Thanks, i will try that.
Also can i implement this snippet inside a cursor? coz a person will have multiple entries in Assignment table and all the records need to be...
August 15, 2008 at 2:32 pm
The UNION kind of hinders performance of the procedure. So i am figuring out how it can be done?
April 1, 2008 at 10:50 am
SELECT distinct
--
FROM
PlanBudgetDetail P
join
Allotment A
On
P.id = A.id --match id's
JOIN
Left Join
Tracker_Comments T
on
--
P.fy_dt = T.fy_dt--match the year
and P.appr_cd = T.apprcd--match the codes
and A.id...
April 1, 2008 at 10:48 am
The 3rd table is just to match certain records so that the result set is a valid one. it doesnt really matter. What matters is the record in table 2...
April 1, 2008 at 10:39 am
oops !! sorry fi it was too confusing.. Am confused as well :p
Basically all 3 tables undergo a transaction process. So eventually "one data" is not entered in Table1, but...
March 12, 2008 at 10:38 am
Viewing 15 posts - 1 through 15 (of 28 total)