Search Results

Search found 5 results on 1 pages for 'user293249'.

Page 1/1 | 1 

• How to code Microsoft Excel "Shift Cells Up" feature in SQL

  - by user293249

  Take a simple table like below: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Home Base Row 2: Jeff || 7:00 AM || Virtual Base Row 3: Ryan || 6:30 PM || Test Base Now lets say that a single cell is deleted so the table now looks like this: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Row 2: Jeff || 7:00 AM || Virtual Base Row 3: Ryan || 6:30 PM || Test Base Notice that "Home Base" is missing. Now in excel you can delete the cell and shift the rest so the finished product looks like below: Column Headings: || Agent's Name || Time Logged In || Center || Row 1: Andrew || 12:30 PM || Virtual Base Row 2: Jeff || 7:00 AM || Test Base Row 3: Ryan || 6:30 PM || And you can see we are left with a blank cell last row. How do I code this procedure of shifting the cells up in SQL? I've been struggling on this problem for weeks! Thank you!

  Read the article

• How do I convert an INT into HH:mm:ss using SSRS 2005

  - by user293249

  Ok I need to display total talk time of an agent that is coming into SRSS 2005 from SQL 2005 as an INT. For the life of me I cannot figure out what combination of expression editing or format editing I need to use. For the detail portion I can use: =DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")) And it will return: 1/1/0001 12:00:14 AM Now I can use =LEFT(DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")),8) Which will return: 12:00:14 But really what I need is: 00:00:14 Please help!

  Read the article

• Convert Unix Epoch Time to format HH:MM:SS without the date

  - by user293249

  I'm using SSRS 2005 and I need to convert time from a serial unix time like 3412.254263 to a duration like 166:12:35 where the second format is HH:MM:SS. All .NET code should work, but I can't find any function that does not include the date or does not treat the result as a duration. Any help would be appreciated!

  Read the article

• HTML CSS Header image has an black stripe above hearder image that I can't seem to remove

  - by user293249

  Please check out http://rainsongmanchesters.net/news.htm and notice the black strip above the header image. Now click here http://rainsongmanchesters.net/breedinfo.htm and notice how there is no strip. Such a simple problem? It has defeated me for months! Using firebug, and just staring at the code for months has not produced any solutions. Please help!

  Read the article

• Convert Unix Epoch Time to Seconds in SQL or .NET

  - by user293249

  First let me thank you all for your help. What I need is a function that takes in a EPOCH time stamp, like 1452.235687 and converts it to a readable timestamp like '01-01-1970 00:00:00'. More specifically I only need the time not the date. If at all possible I would prefer a .NET function instead of a SQL stored procedure. However an SQL stored procedure would work fine as well. Thank you again,

  Read the article

1