Viewing 15 posts - 286 through 300 (of 326 total)
MyDoggieJessie (8/6/2012)
It's an integration services control "- Slowly Changing Dimension"
Apart from ssis control , It's a theory and can be implemented out of SSIS .
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 6, 2012 at 10:43 pm
how do you want to store it ?
check out nodes method at msdn .
http://msdn.microsoft.com/en-us/library/ms188282.aspx
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 6, 2012 at 6:44 am
texpic (8/5/2012)
New error now, "Msg 530, Level 16, State 1, Line 12 The statement terminated. The maximum recursion 100 has been exhausted before statement completion."
use MAXRECURSION hint.
check this out:
http://msdn.microsoft.com/en-us/library/ms186243(v=SQL.105).aspx
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 10:51 pm
thanks for the question;learned about xml indexes .
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 10:31 pm
Create an SP that takes the validation error input and prints the message;
that would make it cleaner.
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 10:28 pm
cast ((Result+1) as numeric)
If you use Int ,in this case BigInt , then you won't be seeing this error...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 12:43 pm
haiao2000 (8/5/2012)
I don't anticipate we keep every version of the data as it is very expensive to do so, but it is likely that user wants to have several versions...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 12:31 pm
declare @mysql varchar (1000)='create table #team1(a int); select * from #team1'
exec (@mysql)
I am not sure what you are looking for, but for # you don't need to do anything...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 6:34 am
case when @StartDate<@EndDate then
DATEDIFF(dd,@StartDate,@EndDate) + 1
when @StartDate>@EndDate then DATEDIFF(dd,@StartDate,@EndDate) - 1 end
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 2:03 am
if it's just one version , you can have the back end loader to dump the data in the new table and have front end configured to use new table...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 1:46 am
you can create an archive table that keeps only the previous version data, it's good to have the history information in other table. Also it depends how your business requirement...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 1:41 am
Jonathan Marshall (8/2/2012)
ScenarioThe filecount of the raw files checks for nulls in the file.
Marshall
I don't think counting a null would be an issue , It depends how are...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 5, 2012 at 1:34 am
I don't have 2012 yet , I went through msdn
http://msdn.microsoft.com/en-us/library/ff878091.aspx
I thought the answer would be min(bigint)+1 ; and that wasn't listed ; didn't understand the defaults ..
guess need to...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 3, 2012 at 5:46 am
great question, although I got it right, but I am glad i read the posts .Otherwise , I may have ended with wrong idea.
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 3, 2012 at 5:23 am
waqqas.zia (8/2/2012)
Hi Guys,My company has had redundancies and they have told me that i am now incharge of the DataWarehouse :w00t:
what company is that !! 😛
a better way to start-...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 2, 2012 at 3:03 am
Viewing 15 posts - 286 through 300 (of 326 total)