Click here to Skip to main content
15,868,016 members
Home / Discussions / Database
   

Database

 
QuestionSSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Mangesh678616-Jul-14 2:04
Mangesh678616-Jul-14 2:04 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Eddy Vluggen16-Jul-14 5:03
professionalEddy Vluggen16-Jul-14 5:03 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
PIEBALDconsult17-Jul-14 13:39
mvePIEBALDconsult17-Jul-14 13:39 
QuestionExtract Data in Single Record Pin
mrfalk15-Jul-14 13:05
mrfalk15-Jul-14 13:05 
AnswerRe: Extract Data in Single Record Pin
data modeling guy15-Jul-14 19:32
data modeling guy15-Jul-14 19:32 
AnswerRe: Extract Data in Single Record Pin
Richard Deeming16-Jul-14 2:42
mveRichard Deeming16-Jul-14 2:42 
AnswerRe: Extract Data in Single Record Pin
PIEBALDconsult17-Jul-14 13:54
mvePIEBALDconsult17-Jul-14 13:54 
Questionlinked list using CTE Pin
Ali Al Omairi(Abu AlHassan)14-Jul-14 22:29
professionalAli Al Omairi(Abu AlHassan)14-Jul-14 22:29 
guys;
I trying to design a query that returns products ordered based on a self-reference foreign key (just like a linked list). I tried to make a recursive query (CTE), but i couldn't return the records as the table below.

SQL
product_id | next_id | product_name
-----------------------------------
5          | 3       | product 5
3          | 2       | product 3
2          | 4       | product 2
4          | 1       | product 4
1          | null    | product 1


I am wondering if you can help me with this.
Help people,so poeple can help you.

AnswerRe: linked list using CTE Pin
Ali Al Omairi(Abu AlHassan)14-Jul-14 23:14
professionalAli Al Omairi(Abu AlHassan)14-Jul-14 23:14 
QuestionOVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 4:44
Ambertje14-Jul-14 4:44 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 5:13
mvePIEBALDconsult14-Jul-14 5:13 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 5:15
Ambertje14-Jul-14 5:15 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 5:27
professionalEddy Vluggen14-Jul-14 5:27 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 5:29
mvePIEBALDconsult14-Jul-14 5:29 
QuestionRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 7:47
professionalEddy Vluggen14-Jul-14 7:47 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 8:33
professionalJörgen Andersson14-Jul-14 8:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Mycroft Holmes14-Jul-14 12:54
professionalMycroft Holmes14-Jul-14 12:54 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 22:20
professionalJörgen Andersson14-Jul-14 22:20 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 22:12
Ambertje14-Jul-14 22:12 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
jschell14-Jul-14 10:07
jschell14-Jul-14 10:07 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
GuyThiebaut14-Jul-14 21:33
professionalGuyThiebaut14-Jul-14 21:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 22:13
Ambertje14-Jul-14 22:13 
QuestionError: Can't delete row or update row in SQL Server ? Pin
taibc11-Jul-14 18:29
taibc11-Jul-14 18:29 
AnswerRe: Error: Can't delete row or update row in SQL Server ? Pin
Mycroft Holmes11-Jul-14 23:32
professionalMycroft Holmes11-Jul-14 23:32 
GeneralRe: Error: Can't delete row or update row in SQL Server ? Pin
taibc13-Jul-14 20:36
taibc13-Jul-14 20:36 

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.