Could anyone help me with a little problem i'm having in SQL.
What I'd like to be able to do is to extract the name of the month from any
date so that I can group figures in a report by the name of the month. I've
tried using both the MONTH and DATEPART functions but all i've succeeding in
doing so far is getting the month number e.g. '6' rather than the month name
'JUNE'. I thought that if I specified "mmmm" in the date part function
instead of "m" then it would return the name of the month, but instead all
it gave me was an error.
If anyone can tell me a way of doing this then i'd be very grateful
Re: Missing Daigrams ... post named "VB6 SP6 problem with SQL 2000 Enterprise ... Manager" in the newsgroup microsoft.public.vb.bugs. ... (You might need winzip to extract files/cabs) ... (microsoft.public.sqlserver.tools)
Re: Epicor - Vantage product ... PICK system...do you know anything about this...I am trying to extract the data into SQL so we can qry the old records. ... Depending on the release of UV that you're running, you should have a perfectly good SQL engine available in UV. ...consulting help can be provided to get the data flattened and extracted. ...Systems Theory internet music project links: soundclick garageband "Soundtracks For Imaginary Movies" CD released Dec 2004 "Codetalkers" CD coming end of 2005 NP: nothing. ... (comp.databases.pick)
Optimising Database Calls ... I have an ASP page that makes a vml/svg graph out of data. ...Dim command As New SqlClient.SqlCommand ... 'Code here to extract data and plot one section of the graph ... there a way to keep the same command object and keep changing the SQL?... (microsoft.public.dotnet.framework.aspnet)
Re: Searching/Estracting numerical data ...Extract Number from Fields - SQL... The function you would use to find where a three digit sequence in ...varchar data is located is ... (comp.databases.ms-sqlserver)
Date Sensitive Extraction ... I am pretty much a novice on DTS, I have used it on very simple extractions ... I am wanting to set an extract from an Oracle Table ... "DTS Import/Export Wizard" on the screen which show me the SQL.... reason on Monday and it had to run on Tuesday, it would Extract Sun - Mon and ... (microsoft.public.sqlserver.dts)
