I tried looking for assistance but I cant get my formatting to work. I was pretty sure yyyy=2007 and yy=07 but its not working right.
What I am doing is using Business Intelligence to read the previous days IIS logs. The logs are labeled as ex070602.log (exyymmdd.log) The code I use to get the previous day is dateadd("d",-1,getdate())
now I want to format the yy/mm/dd but I am getting single digits for the month and day and 4 digits for the year. Can someone tell me the expression I would need to use for this. Thank you kindly guys.
Could someone please tell me how I could format my output to look something like this:
What I have:
Code:
customer street city telnum ---------- ---------- ---------- ---------- Ann 12 bpem there 34215 Ben 2 blim here 344365 Carl 512 crom there 34725 Dean 62 blon here 2132345 El 142 brom there 657345 Frank 71 clom here 6345215
What I would like: NOTE: I edited this myself incase you are confused about how I got these results, not that Im calling anyone stupid, just to make clear up any possible misunderstandings
Code:
customer contact details ---------- ----------------- Ann 12 bpem there 34215 Ben 2 blim here 344365 Carl 512 crom here 34725 ...... etc
Thanks for taking the time with this. Your help is always appreciated.
I have a table as follows: A NO Balance [decimal (16,5)] ---------------- -------------------------------------------------- ------------------ 18.00 001000000000000 -37.982 19.00 002000000000000 -17.656
In the Query analyzer when I try: SELECT * FROM TABLE1
A NO Balance [decimal (16,5)] ---------------- -------------------------------------------------- ------------------ 18.00 001000000000000 -37.98 19.00 002000000000000 -17.66
I need the query analyzer to format them as they are in the tables. Help please.
Hello all, I am trying to import an excel spreadsheet that has a specific date column. The column is saved as military time. For example, one of the records is: 04-12-2007 09:30 But, when i import the data into sql 2005, the above date is displayed as: 2007-04-12 09:30 I need it to display like the same way that it's being displayed in the excel spreadsheet. My field in sql is nvarchar(100) and it still doesn't work.
Brand new to this, so please bear with me.I'm using the following code fragment to update a datetime field on a SQL Server 2005 database table:cmd.CommandText = "Update Projects Set EntryDate = " & Convert.ToDateTime(txtEntryDate.Text)cmd.ExecuteNonQuery()The result of the update operation is the the database field contains the value "1900-01-01 00:00:00:000". This probably means that I passed nulls to SQL; however, I see a valid date in the txtEntryDate field on my web form (i.e., "06/18/2007"). I also did a "Response.write" to display the txtEntryDate and it looks Okay.Can someone tell me what I'm doing wrong?Thanks!Using Visual Web Developer 2005 Express.
I am trying to get my query to give me the results I want by date in a list. I want in one column to get the date and the next column to show me the minutes of use (as reported in my database). I tried a Group by statement and asked it to group by the CallDate column. It gives me the date, but the minute totals in the next column are not right. Please help.
I have the following query and I am wanting to get the results by date. Please advise. SELECT COUNT(UniqueCallID), VoiceCallDetailRecord.[Type], SUM(PaidBalCost), SUM(BonusBalCost), SUM(FreeMsgCost), SUM(ceiling((Cast(DurationSeconds as Decimal)/60))) as Minutes FROM VoiceCallDetailRecord WHERE VoiceCallDetailRecord.[Type] IN ('MOSMS','FreeMTSMS') AND CallDate Between '01/01/2007' and '02/01/2007' GROUP BY VoiceCallDetailRecord.[Type] and GROUP BY dateadd(day, datediff(day, 0, CallDate), 0)
UNION SELECT COUNT(UniqueCallID), ZeroChargeVCDRecord.[Type], SUM(PaidBalCost), SUM(BonusBalCost), SUM(FreeMsgCost), SUM(ceiling((Cast(DurationSeconds as Decimal)/60))) as Minutes FROM ZeroChargeVCDRecord WHERE ZeroChargeVCDRecord.[Type] IN ('MOSMS','FreeMTSMS') AND CallDate Between '01/01/2007' and '02/01/2007' GROUP BY ZeroChargeVCDRecord.[Type]
hi. i'm trying to order my results ascending by date except i'm getting some really weird output. my ouput resembles something like this:
oct 2 oct 3 sep 13 sep 21 sep 22 sep 30 aug 3 aug 5 aug 16
the data is stored in a date field. i use getdate when inserting the date to the database. is there a reason why the dates are showing up weird and not ordering appropriately? thanks for your help.
also, can you not search here any more? i keep getting timeout errors.
I really hope that someone can help me or at least point me in the right direction. I am selecting a set of data and using the date values across the X axis. However the needs exists to group these by week, but these weeks are not the normal weeks, for - they exist as follows the month starts on the first Monday of a month, for example December 2007 starts on Monday the 3rd and the week ends on the 6th of December a so on till the fact that the last week of the month December 2007 starts on Monday the 31st and ends on January the 6th is there any way that I can create a group that could group the datetime values together in this way,
This is not best achieved in SSRS where should I be creating these groups. Any help would really be appreciated.
how to hard code mention date range in my SP to get expected results in my query 01/01/2012 to 12/31/2012
DECLARE @ACCOUNT AS INT DECLARE @POSTING_DATE AS DATETIME DECLARE @FIRST_POSTING_DATE AS DATETIME SET @POSTING_DATE = {?POSTING_DATE} SET @ACCOUNT = {?ACCOUNT}
I am trying to query a calendar table that has the [start] datetime of an event and then a [title] of the event. I am trying to display them as;* 8:00 AM Get to work* Independance daysome of the events have a start time and some only have a date. the ones that do not have a start time have a start time of 12:00:00 How do I query the two fields and only show the start time & title of the events that have a start time and just the title for the ones that do not have a start time.. I've tried this...select Event = (CONVERT(CHAR(8),start,8) +' ' + title) from Calendar where CONVERT(CHAR(8),start,8) <> '12:00:00'It does display the start and event title but only for the ones that have a start time. And how do I get the 8:00 AM format for the time? Thanks for any help.Mark
i have this: \FILInternalBuisnessArea*.* \FILInternalBuisnessArea \FILInternalBuisnessArea*.qvw \FILInternalBuisnessArea empfileDB.mdb \FILInternalPublic Area*.* \FILInternalPublic Area \FILInternalPublic Area*.xls \FILInternalPublic Areaacro*.doc \FILInternalPublic Areaeconomi*.xls \FILInternalPublic AreaeconomiGroup01FileToSave*.xls \FILInternalPublic AreaeconomiGroup01Unit01FileToSave*.xls
And i want to strip away whatever is after the last '' so the output should look like this \FILInternalBuisnessArea \FILInternalBuisnessArea \FILInternalBuisnessArea \FILInternalBuisnessArea \FILInternalPublic Area \FILInternalPublic Area \FILInternalPublic Area \FILInternalPublic Area \FILInternalPublic Areaeconomi \FILInternalPublic AreaeconomiGroup01 \FILInternalPublic AreaeconomiGroup01unit01
Hi all, i am using sql server 2005. let me explain the scenario. I have to built a report where I have to find out no of call made by an executive to a perticular customer during a year
Ok so here is an explanation of what i need. I have a table that has emails in it. I need to get those emails to show up as verticle line of names. these will then be sent out via email so i have the following line of code to put them into a string:
I'm using xp_sendmail in the sp and in @query I do select * from table1. The result also page,s The formate is not at all readable and even if @attach_results = 'TRUE' In the text file its not formatted as it sends mail to my manager I want it to be formatted and looks good. Can anyone help me or Is there any way to get the results in readable format.
I wanted to knoe if it is possible to remove the leading and trailing spaces by using the RTrim and LTrim?
Currently I have the table Below is it possible to format all the data i.e. remove all leading and trailing spaces in the table from every record?
select *
from ( select 'Rivet' as [Name], '01' as PartNo, '1999' as Year union all select 'panel', '041', '1999' union all select ' side panel', '021', '1999' union all select 'thread ', '042', '1999'
I am pulling several numbers from a SQL table, adding them and doingvarious calculaitons. The numbers do not display a comma to separatethousands. What is a way to format this?
I have the following problem, i want the number format to appear depending on the language that the IE is on once you are using the reports on the web.
The thing is that my reports have language = default.
Format of the numbers are N0 or ###,###,###
The result is
123,234,456 with pt language ou en-us language, and i would like to be 123.234.456 in pt and 123,234,456 on en.
i have create a Report withe a table. In this Table i have History-data of a tabel from my database. When a value in a field was change between the actual row and the row before, i want to change the color of the chaged value.
For Example: Server Customer Serial # Location DC1 Company 123 123abc RZ9 / AB12 DC1 Company 123 456abc RZ9 / AB12 DC1 Company abc 456abc RZ9 / AB12
