Viewing 15 posts - 5,266 through 5,280 (of 11,678 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...
August 8, 2013 at 10:27 am
ChrisM@Work (8/8/2013)
GilaMonster (8/8/2013)
ChrisM@Work (8/8/2013)
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.
August 8, 2013 at 7:33 am
BIML also exists for 2008. It's included in BIDSHelper.
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.
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...
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...
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.
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.
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?
August 8, 2013 at 6:31 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?
August 8, 2013 at 6:07 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...
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. 🙂
August 8, 2013 at 5:27 am
Viewing 15 posts - 5,266 through 5,280 (of 11,678 total)