Viewing 15 posts - 1 through 15 (of 134 total)
Thanks for your advise.
I will return back to them - I thought I had missed a trick somewhere - but glad I was covered.
Regards
Steve
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
February 22, 2016 at 9:05 am
Hi Orlando,
You mentioned that I have some options missing - however, the options that you have mentioned are for screen width ( -w, -y )
The extract using SQLCMD and...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
February 22, 2016 at 8:16 am
John Mitchell-245523 (9/3/2015)
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 3, 2015 at 3:19 am
Lynn Pettis (9/1/2015)
Best thing, store date and datetime values using the proper date or date/time data type, then you don't have the conversion issues.
Yes I do agree, however, with legacy...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 1, 2015 at 11:24 am
Ahh right - stumbling block number 2..
You cannot use SET LANGUAGE British within a view !
Looks like the database needs to be set as dmy ?
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 1, 2015 at 2:28 am
Hi Thanks for the reply -
The simple answer is -
SET LANGUAGE British
GO
Thanks
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
September 1, 2015 at 2:08 am
Thanks for your help.
Unfortunately the data is from old data - so this is the cleansing routines.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 28, 2015 at 6:45 am
Apologies -
Command line;
Create format file;
bcp [SysproCompanyS].[dbo].[View_SLG_FinanceForecast_StockCodes] format nul -n -f C:\XMLExport\StockCodeFormat.xml -x -T
Create data file;
bcp [SysproCompanyS].[dbo].[View_SLG_FinanceForecast_StockCodes] out c:\xmlexport\StockCodes.xml -f C:\XMLExport\StockCodeFormat.xml -T
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
March 31, 2015 at 7:21 am
I think I am getting there - having figured out the bcp command line now.
So I have created an xml format file and specified that when creating the data file....
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
March 31, 2015 at 7:19 am
Sorry - have answered this one now.
I am struggling getting the output to work within "BCP" - keeps asking for a format file !?
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
March 31, 2015 at 6:24 am
That will be what I am after - I think I have that bit all sorted now.
Just one more question -
With Regard to the XML format, Is it possible...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
March 31, 2015 at 2:28 am
Thanks for the help.
The views now work a treat -
What would be the best solution for generating an XML file in a specific folder, calling a stored procedure to...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
March 30, 2015 at 8:20 am
cracked it ....
With myCTE as
(
SELECT
ROW_NUMBER() OVER ( ORDER BY TrnYear DESC, TrnMonth DESC ) as Row, TrnYear, right('00'+ rtrim(TrnMonth), 2) as TrnMonth, Count( Invoice ) as InvoiceCount
FROM ApInvoicePay
Where...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
August 15, 2014 at 2:29 am
Think I have solved it ...using Row_NUMBER()
SELECT
ROW_NUMBER() OVER ( ORDER BY TrnYear DESC, TrnMonth DESC ) as Row,TrnYear, right('00'+ rtrim(TrnMonth), 2) as TrnMonth, Count( Invoice ) as InvoiceCount
FROM ApInvoicePay
Where...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
August 15, 2014 at 2:26 am
Both TrnYear, TrnMonth are decimal.
2014/09 will return NULL, I agree..... although I think finance want to put the forecast in there.... another topic !
Thanks
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
August 15, 2014 at 2:15 am
Viewing 15 posts - 1 through 15 (of 134 total)