Click here to Skip to main content
Page 1 of 6,733
Page Size: 10 · 25 · 50


Category filtered by:  Database & SysAdmin [x]
Forum Message 13 May 2013  
I wouldn't do that. It's against the "Rules" of normalization. You don't want to make a row dependant on another row in the same table. Think of all the fuzz to update the table when you find out som
Database & Sysadmin » Database
Forum Message 13 May 2013  
Bikash Prakash Dash wrote:You have to provide any value for that No you have to provide the correct key, any key will corr
Database & Sysadmin » Database
Forum Message 13 May 2013  
Primary key value cant be null. You have to provide any value for that.
Database & Sysadmin » Database
Forum Message 13 May 2013  
Firstly, you have to download the Oracle Database Software. go to oracle.com and download the software. I suggest to download 11g R2 windows version. It's more easier to install on windows than on
Database & Sysadmin » Database
Forum Message 13 May 2013  
Hi, Check the Script SELECT M.ID,(ROW_NUMBER() OVER(PARTITION BY M.EmpID ORDER BY M.EmpID)) 'RowNumber', M.EmpID, M.Leave_Year, M.Taken, M.Credit, (SELECT SUM((ISNULL(Balance,0
Database & Sysadmin » Database
Forum Message 13 May 2013  
Hi All, In DB2, i have used XMLAGG built in function in order to convert Rows to Column String Concatenation. Since lot of records are available in the table, performance wise it was too slow. Whet
Database & Sysadmin » Database
Forum Message 13 May 2013  
Can you explain more in details your case? I Love T-SQL
Database & Sysadmin » Database
Forum Message 13 May 2013  
EmpID Leave_Year Taken Credit Balance 435 2014 0 22 22 435 2013 10 22 12 435 2012 24 22 0 435 2011 20 22 2 435 2010 23 22 0 435 2009 21 22 1 I
Database & Sysadmin » Database
Forum Message 13 May 2013  
Several screens (or one very functional one) to view the data in a variety of ways like by Phase, by ESXHost, by Application. I think if we have several drop downs for filtering then that would work;
Database & Sysadmin » Database
Forum Message 12 May 2013  
Thank you very much. I just needed a clarification for not under-estimating my decision over my superior. Thank you very much.
Database & Sysadmin » Database

Page 1 of 6,733
1 2 3 4 5 6 7 8 9 10


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid