Click here to Skip to main content
15,120,459 members
Home / Discussions / Database
   

Database

 
QuestionHow to select the records who are completed exactly years comparing with joining date and todays date Pin
ven75326-May-14 7:09
Memberven75326-May-14 7:09 
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
jschell26-May-14 9:11
Memberjschell26-May-14 9:11 
GeneralRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
ven75326-May-14 22:27
Memberven75326-May-14 22:27 
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
Mycroft Holmes26-May-14 13:52
professionalMycroft Holmes26-May-14 13:52 
GeneralRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
Sunasara Imdadhusen26-May-14 22:30
professionalSunasara Imdadhusen26-May-14 22:30 
AnswerRe: How to select the records who are completed exactly years comparing with joining date and todays date Pin
NitinDhapte16-Jun-14 3:18
MemberNitinDhapte16-Jun-14 3:18 
Questionaccess2010 pivot table Pin
hakata21-May-14 6:59
Memberhakata21-May-14 6:59 
QuestionAbnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad20-May-14 21:52
Memberjugnu_ad20-May-14 21:52 
Dear members,

I have recently installed SQL Server 2008 Enterprise Version. I have a database built in SQL SERVER 2000 which I attached in 2008.

I have a stored procedure which calculates the Inventory Stock.

In some cases the sp deducts qty twice when call from front end (VB 6.0) whereas when I run the sp in SQL Server it returns correct result

It was running perfectly in SQL Server 2000 from VB 6.0

What could be the cause of this abnormal behavior?
Note: The Compatibility Level of the database is set on SQL Server 2000 (80)

Waiting for your kind replies.

Thanks & Regards,
Syed Adnan Shah
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Richard MacCutchan20-May-14 22:45
mveRichard MacCutchan20-May-14 22:45 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad20-May-14 22:47
Memberjugnu_ad20-May-14 22:47 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Richard MacCutchan20-May-14 23:26
mveRichard MacCutchan20-May-14 23:26 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Tim Carmichael21-May-14 2:35
MemberTim Carmichael21-May-14 2:35 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad21-May-14 2:45
Memberjugnu_ad21-May-14 2:45 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Simon_Whale21-May-14 2:50
professionalSimon_Whale21-May-14 2:50 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
jugnu_ad21-May-14 2:56
Memberjugnu_ad21-May-14 2:56 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Eddy Vluggen21-May-14 8:52
professionalEddy Vluggen21-May-14 8:52 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Mycroft Holmes21-May-14 13:51
professionalMycroft Holmes21-May-14 13:51 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Tim Carmichael22-May-14 4:41
MemberTim Carmichael22-May-14 4:41 
GeneralRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Eddy Vluggen22-May-14 6:10
professionalEddy Vluggen22-May-14 6:10 
AnswerRe: Abnormal Behavior of SQL Server 2008 Enterprise Store Procedure Pin
Shameel22-May-14 4:05
professionalShameel22-May-14 4:05 
Questionhow to updat a column from start point Pin
mhd.sbt20-May-14 1:59
Membermhd.sbt20-May-14 1:59 
AnswerRe: how to updat a column from start point Pin
Shameel20-May-14 2:19
professionalShameel20-May-14 2:19 
GeneralRe: how to updat a column from start point Pin
mhd.sbt20-May-14 2:35
Membermhd.sbt20-May-14 2:35 
GeneralRe: how to updat a column from start point Pin
thatraja20-May-14 3:14
professionalthatraja20-May-14 3:14 
GeneralRe: how to updat a column from start point Pin
mhd.sbt20-May-14 8:57
Membermhd.sbt20-May-14 8:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.