Viewing 15 posts - 91 through 105 (of 134 total)
anthony.green (12/3/2012)
It hits the first true condition then terminates the case statement.
Thank you - I did feel this was the case but the data does not reflect the logic!?
Will now...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
December 3, 2012 at 3:43 am
Eugene Elutin (12/3/2012)
... does it do one condition and then drop to the CASE...END statement after satisfying one of the conditions?
That is correct.
Sorry;
My question is;
Do I understand...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
December 3, 2012 at 3:39 am
Hi Guys,
3 days to go ..... for the 2012 BI training ....
Is there any reference material ( Free PDF ) on BI basics for 2012 or reference sites that...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
October 31, 2012 at 6:01 am
Sorry - just read the article.
Will have a go at setting this up and testing the data retreival against expected.
Many Thanks
Steve
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
October 1, 2012 at 4:09 am
Thanks - I see what you are doing and agree. But unclear about the "Tally" table and how that would be derived ?
Regards
Steve
J Livingston SQL (9/29/2012)
--===...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
October 1, 2012 at 3:48 am
Unfortunately the tables are already defined in our ERP system -
we have - WIPMaster and WIPMaterials
The Master is the header and contains WOrksOrder, Parent and Qty2Make
The Materials contains the...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 27, 2012 at 1:56 am
Sorry - the question is ;
How can I create a view inserting repeated records based on the calculation of two fields;
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 27, 2012 at 1:39 am
Congratulations -
When you go to the mcp.microsoft.com site - you will see the Logo's that are relevant to your qualifications. You can build up Virtual Business Cards and...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 14, 2012 at 1:50 am
Brilliant - that is exactly what I was after.
Thank you for your assistance
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 12, 2012 at 1:17 am
Ok - sorry about this ....
data to be populated - Master table - InvSteve, link to BomSteve
drop table InvSteve
go
drop table BomSteve
go
create table InvSteve
(
StockCode [char] (30) NULL,
Rev ...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 11, 2012 at 9:26 am
.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 11, 2012 at 8:05 am
Thanks for your reply -
Just a couple of things ... Yes I totally agree that it will look good on the CV - but at the moment not looking...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 4, 2012 at 3:06 am
When you first install sql you specify the collation to use as the default.
you are able to create views and at that time specify the translated collation to use if...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 3, 2012 at 7:23 am
.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 20, 2012 at 7:12 am
Looks like this is the cause of it !
Message
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 20, 2012 at 3:48 am
Viewing 15 posts - 91 through 105 (of 134 total)