Viewing 15 posts - 8,866 through 8,880 (of 13,882 total)
legeboka (12/12/2014)
I have SQL 2008, LAG wouldn't work
You realise you're in the 2012 forum? 🙂
December 12, 2014 at 7:37 am
Indianrock (12/11/2014)
December 11, 2014 at 9:38 am
First, I am assuming that you confused 'BB' and 'CC' in your sample data and query.
No, that is what I wanted just the casenumbers.
Really? Your sample query includes this...
December 11, 2014 at 9:08 am
IMO, your suggested approach is not optimal.
A better model is one package per table, with some sort of controller/master package which executes them all.
If your loading methodology is similar for...
December 11, 2014 at 3:02 am
sunder.bugatha (12/11/2014)
save it as a SSIS package and use data conversion transformation to convert it to relevant datatype.
Any data that has already been lost during the conversion to SmallDateTime will...
December 11, 2014 at 2:16 am
First, I am assuming that you confused 'BB' and 'CC' in your sample data and query.
It would probably be easier to use T-SQL to get your data into the required...
December 11, 2014 at 1:05 am
Is there any way around this without doing some crazy file manipulation?
1) Use a delimiter which does not appear in your data.
2) Use SSIS 2012 onwards. See here.
December 11, 2014 at 1:00 am
JoshDBGuy (12/10/2014)
Grant Fritchey (12/10/2014)
December 10, 2014 at 10:10 am
tiredofchoosing (12/9/2014)
Oh, old files are not archived. They simply accumulate in the folder.
This is not best practice – you should consider moving the files to a 'Processed' folder after they...
December 10, 2014 at 12:21 am
You could avoid the whole issue (assuming the import folder only ever contains the files to be processed, because processed files are archived) by using a FOREACH loop selecting files...
December 9, 2014 at 2:16 pm
What is the error?
Is the server in the same domain as the machine she's trying to log in from?
December 9, 2014 at 9:09 am
butcherking13 (12/9/2014)
She has asked for sys admin rights because we...
December 9, 2014 at 9:06 am
butcherking13 (12/9/2014)
I work with one developer who has a few years experience....
December 9, 2014 at 8:30 am
Do not use SET IDENTITY INSERT ON – that is telling SQL Server that you wish to override the auto-increment for some reason. So given a table X
Id int identity...
December 6, 2014 at 11:09 am
Can you write out the desired results, based on your sample data?
If you could provide your input data in consumable (ie, runnable in SSMS) format, you will be more likely...
December 6, 2014 at 5:29 am
Viewing 15 posts - 8,866 through 8,880 (of 13,882 total)