Click here to Skip to main content
15,917,928 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to replace string with stuff ? Pin
Mycroft Holmes16-Jul-13 12:44
professionalMycroft Holmes16-Jul-13 12:44 
QuestionMounting .DBF files (Oracle Database 11g) Pin
prathameshpitale15-Jul-13 5:33
prathameshpitale15-Jul-13 5:33 
AnswerRe: Mounting .DBF files (Oracle Database 11g) Pin
Maciej Los29-Jul-13 23:46
mveMaciej Los29-Jul-13 23:46 
GeneralRe: Mounting .DBF files (Oracle Database 11g) Pin
prathameshpitale30-Jul-13 5:40
prathameshpitale30-Jul-13 5:40 
QuestionORA-12560 TNS : protocol adapter error; ORA-1033 Oracle initialization or shutdown in progress Pin
prathameshpitale15-Jul-13 5:33
prathameshpitale15-Jul-13 5:33 
QuestionHow to find ladder in sql query Pin
Member 356741115-Jul-13 2:02
Member 356741115-Jul-13 2:02 
AnswerRe: How to find ladder in sql query Pin
Niral Soni15-Jul-13 5:00
Niral Soni15-Jul-13 5:00 
AnswerRe: How to find ladder in sql query Pin
karna from Hyderabad22-Jul-13 21:01
karna from Hyderabad22-Jul-13 21:01 
USE tempdb ;
GO
DECLARE @ladderTable TABLE ( Col1 INT ) ;
DECLARE @incrementValue INT = 0 ;

INSERT INTO @ladderTable ( Col1 )
VALUES ( 5 ),
( 10 ),
( 15 ),
( 20 ) ;

SELECT TOP 1
@incrementValue = Col1
FROM @ladderTable
ORDER BY Col1 ASC ;

SELECT st.Col1,
CAST(st.Col1 AS VARCHAR(20)) + '-'
+ CAST(ISNULL(dt.Col1, st.Col1 + @incrementValue) - 1 AS VARCHAR(20)) AS LadderSequence
FROM @ladderTable AS st
LEFT OUTER JOIN @ladderTable AS dt ON st.Col1 < dt.Col1
AND ( st.Col1 + @incrementValue ) >= dt.Col1 ;
GO

Thanks,
Karunakar
Questiondatabase course Pin
V.14-Jul-13 22:32
professionalV.14-Jul-13 22:32 
AnswerRe: database course Pin
Eddy Vluggen15-Jul-13 0:30
professionalEddy Vluggen15-Jul-13 0:30 
GeneralRe: database course Pin
V.15-Jul-13 1:30
professionalV.15-Jul-13 1:30 
QuestionFIlestream of varbinary ? ( To Store files) Pin
Amol_B14-Jul-13 21:22
professionalAmol_B14-Jul-13 21:22 
AnswerRe: FIlestream of varbinary ? ( To Store files) Pin
Richard MacCutchan14-Jul-13 22:29
mveRichard MacCutchan14-Jul-13 22:29 
AnswerRe: FIlestream of varbinary ? ( To Store files) Pin
Mycroft Holmes14-Jul-13 22:42
professionalMycroft Holmes14-Jul-13 22:42 
GeneralRe: FIlestream of varbinary ? ( To Store files) Pin
Amol_B14-Jul-13 22:58
professionalAmol_B14-Jul-13 22:58 
Questionneed an sql query to extract results in the attached format Pin
vijays.30198914-Jul-13 3:40
vijays.30198914-Jul-13 3:40 
Questionbackup in sqllocaldb Pin
dharmaa.m12-Jul-13 7:57
dharmaa.m12-Jul-13 7:57 
AnswerRe: backup in sqllocaldb Pin
NotPolitcallyCorrect12-Jul-13 8:36
NotPolitcallyCorrect12-Jul-13 8:36 
GeneralRe: backup in sqllocaldb Pin
dharmaa.m12-Jul-13 10:03
dharmaa.m12-Jul-13 10:03 
QuestionMysql query with date conditions not working in server Pin Pin
ven75312-Jul-13 4:11
ven75312-Jul-13 4:11 
GeneralRe: Mysql query with date conditions not working in server Pin Pin
Eddy Vluggen12-Jul-13 4:52
professionalEddy Vluggen12-Jul-13 4:52 
SuggestionDatabse for broadcasting company Pin
aman wangde11-Jul-13 12:34
aman wangde11-Jul-13 12:34 
GeneralRe: Databse for broadcasting company Pin
Eddy Vluggen12-Jul-13 7:57
professionalEddy Vluggen12-Jul-13 7:57 
QuestionExport data in SQL 2008 Pin
vkEE11-Jul-13 9:05
vkEE11-Jul-13 9:05 
AnswerRe: Export data in SQL 2008 Pin
Richard Deeming11-Jul-13 10:40
mveRichard Deeming11-Jul-13 10:40 

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.