Viewing 15 posts - 2,131 through 2,145 (of 2,452 total)
@RDBMS
have you now got a solution?
regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 5, 2011 at 10:45 am
@RDBMS (11/5/2011)
Data is not possible for me, but I am attaching output that I am getting when below given query is used:
it doesn't have to be real data...just some sample...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 5, 2011 at 7:29 am
please prvode some set up scripts, sample data that demonstrates your problem and the results that you require.....am sure you will then get a tried and tested answer.
regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 5, 2011 at 6:25 am
Hi Welsh
sorry, probably being stupid (as usual) ,,,but is your issue the TSQL or SSIS populating Excel ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 4, 2011 at 2:40 pm
what do you believe to be the problem.?.....assume there is one hence your post?
have you any set up scripts and sample data?
regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 4, 2011 at 1:29 pm
...........
I'm afraid as I'm so green with this forum you'll have to tell me the best way to attach the execution plans and sample data you wanted.
Here's a test rig...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 4, 2011 at 12:15 pm
search this site (and others) for "FOR XML PATH"....this may be a quick fix for you....else as previously suggested you need to research dynamic cross tabs / dynamic pivots
you also...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 1, 2011 at 2:09 pm
Derek...given the following results (from AW2008)...what results are you expecting?
SalesOrderIDSalesOrderDetailIDOrder Quantity TotalAverage Unit PriceLine Total
43659 1 26 1193.6426 20565.62
43659 2 26 1193.6426 20565.62 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 1, 2011 at 1:33 pm
have you any sample data and DDL scripts...along with expected results?
it would help us to help you in providing some tested answers.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2011 at 1:00 pm
forgot to mention...seems its only 2008 R2 at the moment.
more info here http://www.sqltreeo.com/wp/dowload-free-ssms-add-in-to-create-own-folder-for-database-objects/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2011 at 8:36 am
Sean Lange (10/31/2011)
J Livingston SQL (10/31/2011)
take a look here:it may do what you are looking for
That looks pretty slick. Have you used it?
use it on a dev machine... use different...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2011 at 8:32 am
take a look here:
it may do what you are looking for
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2011 at 8:19 am
have you considered the following....takes a few seconds to run.
USE tempdb
GO
--===== Conditionally drop the tables
IF Object_id('TEST_METER', 'U') IS NOT NULL
DROP TABLE dbo.TEST_METER;
SELECT TOP 1000000 ---- NOTE 1...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2011 at 7:15 am
sanujss (10/30/2011)
Thanks a lot brother. Let me experiment with this. This was great help 🙂
can you show us what you got brother?
my revised version here:
USE [tempdb]
GO
IF EXISTS (SELECT *...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 30, 2011 at 2:27 pm
In the absence of any set up scripts, data and expected results. ...pls see code below...pure guess and certainly not optimised. It is not a full solution, but maybe...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 30, 2011 at 9:41 am
Viewing 15 posts - 2,131 through 2,145 (of 2,452 total)