Viewing 15 posts - 5,266 through 5,280 (of 11,676 total)
SQL Guy 1 (8/8/2013)
Aparently the topic starter meant a book called "SQL Cookbook" and how to install examples from it.
I thought the same thing. But the OP could be...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 10:27 am
ChrisM@Work (8/8/2013)
GilaMonster (8/8/2013)
ChrisM@Work (8/8/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 7:36 am
Sean Lange (8/8/2013)
Well I guess the joke is lost now as the topic has apparently been removed. :hehe:
It was hilarious. You had to be there.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 7:33 am
BIML also exists for 2008. It's included in BIDSHelper.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 7:32 am
You could try to create SSIS packages dynamically (for example with BIML), so that shortens the development time.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 7:19 am
OK, now that I see the data, I think you should have 2 fact tables, because indeed they are at two different grains.
Recovery is at the treaty level, while total...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 7:06 am
Probably because Oracle is a sucky DB engine who evaluates the expression row by row, while SQL Server evaluates them all at the same time, resulting in both rows being...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 6:46 am
You could create an SSIS package that uses .NET in a script task.
You can schedule SSIS with SQL Agent.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 6:41 am
Is there a particular reason you want to do this in TSQL?
.NET would seem much more fit for the task.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 6:32 am
karunakar2351 (8/8/2013)
update #InwardTransDetails set Branch='BP66' where Branch='NG26' and logindate='2013-08-07'is not working why?
Is there an error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 6:31 am
Who told you that? Any links?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 6:15 am
The total_recovered value in claim (100) is not the same as the sum of the recoveries in claim_recoveries (2 x 25). Is this normal?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 6:07 am
Where did you get the idea there is a cookbook?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 5:58 am
IT researcher (8/8/2013)
Does nested transactions only supported in Transaction Statements(Transact-SQL ) ? In coding i am using 'sqlconnection' object. But inner transaction gets comited even though outer transaction fails
Don't...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 5:46 am
Is it possible to post some sample data (this may be fake).
It would be easier to wrap my head around. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 8, 2013 at 5:27 am
Viewing 15 posts - 5,266 through 5,280 (of 11,676 total)