Click here to Skip to main content
14,743,823 members
Home » Discussions » Database
   

Database

 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel15-Jul-11 8:50
professionalShameel15-Jul-11 8:50 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD15-Jul-11 8:56
MemberAnnieMacD15-Jul-11 8:56 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 6:39
Membersmcnulty200015-Jul-11 6:39 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel15-Jul-11 8:48
professionalShameel15-Jul-11 8:48 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 9:08
Membersmcnulty200015-Jul-11 9:08 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD15-Jul-11 3:44
MemberAnnieMacD15-Jul-11 3:44 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 0:20
Membersmcnulty200015-Jul-11 0:20 
QuestionTemp and variable table cannot be created. Pin
Groulien10-Jul-11 23:27
MemberGroulien10-Jul-11 23:27 
So I've built a nice big Stored Procedure and call it from my SSIS package.
My SP uses a temp table since it uses nestes SP's.
Here's what I tries:
+------+-Table variable-+-Temp Table-+--Temp Table from SQL Server Management Studio--+
|Result|Failure         | Failure    | Success

It always fails unless I force a 'create table' from SQLSMS and keep SQLSMS open, the moment I close it the temp table gets dropped.

What on earth is going on?
I can only guess it's got to do with permission but I wouldn't really know where to look.
The first rule of CListCtrl is you do not talk about CListCtrl - kornman

AnswerRe: Temp and variable table cannot be created. Pin
Shameel11-Jul-11 2:42
professionalShameel11-Jul-11 2:42 
AnswerRe: Temp and variable table cannot be created. Pin
DaveAuld11-Jul-11 3:57
professionalDaveAuld11-Jul-11 3:57 
AnswerRe: Temp and variable table cannot be created. Pin
Corporal Agarn11-Jul-11 7:00
professionalCorporal Agarn11-Jul-11 7:00 
AnswerRe: Temp and variable table cannot be created. Pin
S Douglas11-Aug-11 11:07
professionalS Douglas11-Aug-11 11:07 
QuestionRestoration of publisher database to another system (merge replication) Pin
Abd.Jabbar9-Jul-11 22:39
MemberAbd.Jabbar9-Jul-11 22:39 
AnswerRe: Restoration of publisher database to another system (merge replication) Pin
Corporal Agarn11-Jul-11 4:28
professionalCorporal Agarn11-Jul-11 4:28 
QuestionWho owns the data/database? Customer or vendor? Pin
kmoorevs9-Jul-11 6:55
Memberkmoorevs9-Jul-11 6:55 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
Mycroft Holmes9-Jul-11 14:13
professionalMycroft Holmes9-Jul-11 14:13 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
PIEBALDconsult10-Jul-11 7:32
professionalPIEBALDconsult10-Jul-11 7:32 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs11-Jul-11 10:14
Memberkmoorevs11-Jul-11 10:14 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
jschell12-Jul-11 12:08
Memberjschell12-Jul-11 12:08 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs13-Jul-11 6:03
Memberkmoorevs13-Jul-11 6:03 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
jschell13-Jul-11 10:05
Memberjschell13-Jul-11 10:05 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200015-Jul-11 0:04
Membersmcnulty200015-Jul-11 0:04 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200015-Jul-11 0:01
Membersmcnulty200015-Jul-11 0:01 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 7:06
Memberkmoorevs15-Jul-11 7:06 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 8:11
Memberkmoorevs15-Jul-11 8:11 

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.