Viewing 15 posts - 7,591 through 7,605 (of 11,677 total)
GSquared (3/15/2012)
... world conquest through a secrect society of elite DBAs.
*gasp*
It can be no coincidence that this topic is full of elite DBA's!
(for some strange reason I first read evil...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 2:21 pm
Strange indeed.
What if a full row comes after the half row?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 2:06 pm
GilaMonster (3/15/2012)
Koen Verbeeck (3/15/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 8:08 am
GilaMonster (3/15/2012)
Koen Verbeeck (3/15/2012)
However, the syntax for creating a UNIQUE constraint is as follows:That's the syntax for creating a unique index, not a unique constraint.
You're right. Usually I use the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 7:45 am
Yup.
I guess there are plenty of sources on the net on how to create XML in .NET.
p.s.: my guess is that you'll be begging for the temp table 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 7:34 am
Gerbera (3/15/2012)
Koen,Is it not possible without storing flat file data in Staging table?
Thanks.
Yes, if you construct the XML yourself in a script task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 7:01 am
Do the tables in SAP keep record of the changes somehow? (for example a LastModified column?)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 6:46 am
GilaMonster (3/15/2012)
Koen Verbeeck (3/15/2012)
It seems there are 2 correct answers :w00t:No, there's only one that will both work and do what the question requires.
Ah, I see.
I didn't know about that...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 6:42 am
You can put a constraint on multiple columns.
However, the syntax for creating a UNIQUE constraint is as follows:
CREATE UNIQUE NONCLUSTERED INDEX [test] ON [dbo].[myTable]
(
[myColumn1] ASC,
[myColumn2] ASC
) ON [PRIMARY]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 6:33 am
It seems there are 2 correct answers :w00t:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 6:26 am
You mean the attachments here at SQLServerCentral?
When you create a new post, you have a button Edit Attachments in the Post Options a bit down.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 5:41 am
Charmer (3/15/2012)
Friends,Some one temme how to add files over here...?
Add files where? Your email attachment?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 4:54 am
Yeah well, I once tried to log the beginning and the end of the package using Pre- and PostExecute and I was a bit surprised my package had started and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 4:53 am
Try using the ACE OLE DB provider (used for .xlsx). It should normally be able to read .xls as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 2:15 am
What did you do exactly with the file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 2:14 am
Viewing 15 posts - 7,591 through 7,605 (of 11,677 total)