Welsh Corgi

Forum Replies Created

Viewing 15 posts - 2,176 through 2,190 (of 3,738 total)

RE: How can I improve this query? Need to Create Aggregates in One Step - Currently Create a Query and Subsequently Use a #Temp Table to Perform Summing and Grouping

Good question.
I'm just trying to find a way to get it done.
It seems that I have two options, create an Inline View or CTE to get it done in T-SQL...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 4, 2011 at 2:46 pm

#1403511
RE: How can I improve this query? Need to Create Aggregates in One Step - Currently Create a Query and Subsequently Use a #Temp Table to Perform Summing and Grouping

I squeeze in some of the columns and abbreviated the column names to make this readable but this is what the result looks like from the output of the Temp...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 4, 2011 at 2:11 pm

#1403499
RE: How can I improve this query? Need to Create Aggregates in One Step - Currently Create a Query and Subsequently Use a #Temp Table to Perform Summing and Grouping

J Livingston SQL (11/4/2011)
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
I can understand why you want...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 4, 2011 at 1:48 pm

#1403487
RE: Calculate First & Last Day of for 2 Months from current date & First & Last Day of the Weeks going back 4 Weeks

Lynn Pettis (11/2/2011)
First, I'll look at the date manipulations a bit later. Looks like the date manipulation code in my blog on ssc is just what you need with...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 3, 2011 at 12:31 pm

#1402867
RE: Using a Stored Procedure as A Data Source

Thanks Kramaswamy! 😎
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 3, 2011 at 12:29 pm

#1402865
RE: Using a Stored Procedure as A Data Source

kramaswamy (11/3/2011)
As far as I know, if you try to make column headings dynamic, you're going to get inconsistent metadata. The only way to effectively pull it off is to...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 3, 2011 at 9:46 am

#1402731
RE: Using a Stored Procedure as A Data Source

As a workaround could I remove a generic static heading and insert the dynamic column headings (Previous Year, Previous Month, Previous Weeks) based on the current Date using a Script...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 3:43 pm

#1402450
RE: Calculate First & Last Day of for 2 Months from current date & First & Last Day of the Weeks going back 4 Weeks

OK, I agree on the Date range.
In the past I would concatenate the Date with the Time '23:59:59.123' and use the Between Operator because of the large number of records.
I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 3:35 pm

#1402446
RE: Calculate First & Last Day of for 2 Months from current date & First & Last Day of the Weeks going back 4 Weeks

Drew,
I do not want to miss any records.
I have already calculated the First Dates of the Current, Previous and Next Months but I thought that the BETWEEN OPERATOR would...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 2:38 pm

#1402423
RE: Calculate First & Last Day of for 2 Months from current date & First & Last Day of the Weeks going back 4 Weeks

Lynn Pettis (11/2/2011)
I think I'm still a little lost. Given date 'x' what are you expecting regarding start date and end date for 2 months? Same for the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 2:25 pm

#1402421
RE: Calculate First & Last Day of for 2 Months from current date & First & Last Day of the Weeks going back 4 Weeks

Sample Output.
Ran before End of Month (Oct).
Column has a 1 in each record that the lead generated into a sale.
Account Affinity20102011 YTD OCT 2011 MTDSEP 2011 AUG 2011 WK...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 1:39 pm

#1402402
RE: Calculate First & Last Day of for 2 Months from current date & First & Last Day of the Weeks going back 4 Weeks

Lynn Pettis (11/2/2011)
I find it easier if you show me what you are looking for, I figure things out better when I have a picture of what is needed. ...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 1:31 pm

#1402397
RE: Export to Excel Sheets Column not on the First Row

I thought that after I posted the question.
Makes sense.
Thanks for your help!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 10:23 am

#1402257
RE: Subquery With Aggregates and Pivot

The boss does not want to go with the Excel MAcros.
Back to using SSIS.
The following generates the column headers for the first two aggregates:
SELECT DATEPART(YEAR,DATEADD(year,-1,GETDATE())) AS Year,
CAST(DATEPART(YEAR,DATEADD(year,0,GETDATE())) AS VARCHAR(35)) +...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 9:51 am

#1402236
RE: Export to Excel Sheets Column not on the First Row

kramaswamy (11/1/2011)
Why do you need to know the column names? If you deselect the option "Column Names in First Row" for the excel output, then you're just left with "F1",...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 2, 2011 at 8:44 am

#1402179

Viewing 15 posts - 2,176 through 2,190 (of 3,738 total)