Viewing 15 posts - 106 through 120 (of 134 total)
Not sure what the output is going to be at the end of your project ;
But you could use the MONTH/YEAR to determine the top level and then using the...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 18, 2012 at 10:20 am
Unfortunately I dont think this would be possible - due to "Applications" using a generic "SQL Login" for transactions.
The user level security is handled by the application interface and therefore...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 18, 2012 at 6:11 am
Just an update -
Because I am using one column from the input table - I have changed to use delimited file as output, which now does the job.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 15, 2012 at 5:44 am
If you are checking for the existance of data in one table comared to another and acting on the result.
You could try using the "MERGE" statement
IF MATCHED in SOURCE
IF MATCHED...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 15, 2012 at 1:46 am
Both 2008 and 2008R2 are contained in the certification ( 70-432 / 70-450 )
You will see a lot of topics on the course work lending itself to the new features...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 15, 2012 at 1:44 am
k.subramanyam1017 (6/12/2012)
I have alredy installed sqlserver in 'c' drive but i want to change the 'd' drive. is it possible or not pls...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 13, 2012 at 4:41 am
Brilliant - a fine example.
Many Thanks
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 12, 2012 at 10:27 am
Jared,
That is exactly what I am saying .....
Regards
Steve
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 12, 2012 at 9:42 am
OKay - I understand the logic of creating the multiple lines up front, which I can do - combining the fields to string lengths and having the "temp table" with...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 11, 2012 at 8:09 am
Sorry - Yes that is correct.... BUT if there are only 2 lines of description, then I would miss that line out from the output.
I am looking at maybe an...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
June 11, 2012 at 7:18 am
sorry - having an off day.
Thank you for your help - will read and experiment.
Thanks again
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 31, 2012 at 6:36 am
is there a simple "how to guide" that I could follow ?
Regards
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 31, 2012 at 6:14 am
Ok sorry for being unclear -
I have the data stored in a simple single table, to which I need to create a text file that gets imported into "IBM...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 30, 2012 at 3:29 am
Not sure the state of the database when the "cancel" was requested and how it "cancelled" - the best advice would be to do a restore prior to the aborted...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 23, 2012 at 3:54 am
Thanks for your help -
I have set this up from the express sql - and works fine, so this is a problem with going to the express server from...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 22, 2012 at 7:44 am
Viewing 15 posts - 106 through 120 (of 134 total)