Click here to Skip to main content
15,896,915 members
Home / Discussions / Database
   

Database

 
Questiondynamically change column name Pin
amit sahu2025-Mar-11 1:16
amit sahu2025-Mar-11 1:16 
AnswerRe: dynamically change column name Pin
Simon_Whale25-Mar-11 1:31
Simon_Whale25-Mar-11 1:31 
AnswerRe: dynamically change column name Pin
Eddy Vluggen25-Mar-11 1:32
professionalEddy Vluggen25-Mar-11 1:32 
GeneralRe: dynamically change column name Pin
PIEBALDconsult25-Mar-11 3:03
mvePIEBALDconsult25-Mar-11 3:03 
GeneralRe: dynamically change column name Pin
Eddy Vluggen25-Mar-11 5:22
professionalEddy Vluggen25-Mar-11 5:22 
GeneralRe: dynamically change column name Pin
PIEBALDconsult25-Mar-11 16:00
mvePIEBALDconsult25-Mar-11 16:00 
GeneralRe: dynamically change column name Pin
Eddy Vluggen26-Mar-11 1:52
professionalEddy Vluggen26-Mar-11 1:52 
GeneralRe: dynamically change column name Pin
jschell25-Mar-11 8:29
jschell25-Mar-11 8:29 
GeneralRe: dynamically change column name Pin
PIEBALDconsult25-Mar-11 16:16
mvePIEBALDconsult25-Mar-11 16:16 
GeneralRe: dynamically change column name Pin
Eddy Vluggen26-Mar-11 2:04
professionalEddy Vluggen26-Mar-11 2:04 
GeneralRe: dynamically change column name Pin
jschell26-Mar-11 6:08
jschell26-Mar-11 6:08 
GeneralRe: dynamically change column name Pin
Wendelius26-Mar-11 3:38
mentorWendelius26-Mar-11 3:38 
QuestionHow to calculate average of qty sold the last 6 months or less Pin
Joe Smith IX23-Mar-11 23:50
Joe Smith IX23-Mar-11 23:50 
AnswerRe: How to calculate average of qty sold the last 6 months or less [modified] Pin
Chris Meech24-Mar-11 2:52
Chris Meech24-Mar-11 2:52 
GeneralRe: How to calculate average of qty sold the last 6 months or less Pin
Joe Smith IX24-Mar-11 18:10
Joe Smith IX24-Mar-11 18:10 
GeneralRe: How to calculate average of qty sold the last 6 months or less Pin
Klaus-Werner Konrad25-Mar-11 7:11
Klaus-Werner Konrad25-Mar-11 7:11 
GeneralRe: How to calculate average of qty sold the last 6 months or less Pin
Chris Meech25-Mar-11 7:20
Chris Meech25-Mar-11 7:20 
GeneralRe: How to calculate average of qty sold the last 6 months or less Pin
Klaus-Werner Konrad25-Mar-11 14:50
Klaus-Werner Konrad25-Mar-11 14:50 
AnswerRe: How to calculate average of qty sold the last 6 months or less Pin
Mycroft Holmes24-Mar-11 12:59
professionalMycroft Holmes24-Mar-11 12:59 
GeneralRe: How to calculate average of qty sold the last 6 months or less Pin
Joe Smith IX24-Mar-11 18:10
Joe Smith IX24-Mar-11 18:10 
QuestionFInd Sundays only Pin
rakeshs31223-Mar-11 21:25
rakeshs31223-Mar-11 21:25 
AnswerRe: FInd Sundays only Pin
Wendelius23-Mar-11 22:51
mentorWendelius23-Mar-11 22:51 
One way to do this is to use a function which generates the dates between the range and then in where clause check if sunday is in date range using DATEPART function with weekday option. One example of generating the dates is mentioned in Using Table-Valued Functions in SQL Server[^], function DatesBetween. If yuo choose to use such approach the query could be something like:
SELECT ...
FROM DatesBetween(startdate, enddate) a
WHERE DATEPART(weekday, a.DateValue) = 1;

Note that the datepart result may be different in your environment depending on the SET DATEFIRST option.
The need to optimize rises from a bad design.My articles[^]

GeneralRe: FInd Sundays only Pin
J4amieC23-Mar-11 23:13
J4amieC23-Mar-11 23:13 
GeneralRe: FInd Sundays only Pin
Wendelius23-Mar-11 23:27
mentorWendelius23-Mar-11 23:27 
GeneralRe: FInd Sundays only [modified] Pin
J4amieC23-Mar-11 23:38
J4amieC23-Mar-11 23:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.