October 18, 2010 at 6:12 am
I have two databases and i want fetch the Month id from the one data base(like database a) based on below condition until get the record.
if max(month_id in one table of database A) > max(Month_id in another table of database B)
then keep looping until 'Yes'.
if find the record
Extract the column1 at a monthly level for each country for closed quarters.
I want write the Sp. pl hep out. how can i write the SP.
send any sample sp. That very help full for me
October 18, 2010 at 6:24 am
You're not going to get useful answers for this problem, unless you take the time to describe it properly.
See the article linked in my signature and find out how to post your question effectively.
-- Gianluca Sartori
October 18, 2010 at 6:50 am
plz send any Sample code
October 18, 2010 at 7:00 am
The point I'm trying to make is that your question doesn't contain enough information to get a sensible answer.
Read the article and add the requested info to your question.
-- Gianluca Sartori
October 18, 2010 at 8:20 am
Here's the shell (look it up in BOL for details):
CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS
DECLARE @variable char(5)
place your logic here
END
Go
-- You can't be late until you show up.
October 18, 2010 at 12:45 pm
mss.prince (10/18/2010)
I have two databases and i want fetch the Month id from the one data base(like database a) based on below condition until get the record.if max(month_id in one table of database A) > max(Month_id in another table of database B)
then keep looping until 'Yes'.
if find the record
Extract the column1 at a monthly level for each country for closed quarters.
I want write the Sp. pl hep out. how can i write the SP.
send any sample sp. That very help full for me
Looping through what?
Until you get what record?
"Yes" to what?
Can't help you without that data.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply