.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

i need to display a specific date on a condition

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :Sql Server
I am trying to display a specific date when a condition exists so i have this case statement but it does not work... ,CASE WHEN @ALTTYPE IN ('INCR','DECR','ADD','FLAG') THEN '09/09/99' ELSE END_DT END AS END_DT

View Complete Post

More Related Resource Links

Display date as mm/dd/yyyy instead of yyyy-mm-dd

This should be a fairly simple question. On my performancepoint reports, I would like to return the date as 08/20/2010 as opposed to 2010-08-20. I tried to follow this guide, http://wills-blog.com/?p=93 , but it is outdated and does not seem to work in this situation. Could someone point me in the right direction?

Display specific table from the start vs selecting from a list.

Hello all, I'm using VS2010, EF 4.0. I want to display a list view from a specific table from the start -instead of the standard default page that list all the tables. Any ideas are welcome. 

MVVM - race condition causing image to not display

Hi, We are using MVVM pattern at work for a window that fetches data from a web service and then displays the data. The data is displayed in tabs where each tab displays a title (string) and a chart (image). There are four tabs and whatever tab that is selected to be displayed first fails to display the image. The title gets displayed and this happens asyncrhonously so you will see no title and then when NotifyPropertyChanged fires you see the title but not the image. All the tabs that are not displayed by default work as expected and show the image. And you can change which tab is not displayed and the new tab that is displayed by default will also fail to show the image. Any help greatly appreciated. Code Getting Data The code as it is shown below works. However whenever I try and use the ThreadPool to GetNineMonthsOptionData the image for that tab doesn't display. Another interesting thing is that if I use the thread pool and then put a Thread.Sleep(2000) call right after it works. So there seems to be a race condition at work here. public void LoadOption(string symbol) { _symbol = symbol; // TODO: Team A - Change to use background thread for ninemonth data also and determine // if dispatching is necessary GetNineMonthsOptionData(); //ThreadPool.QueueUserWorkItem( // (o) => // { // GetNineMonthsOptionDa

Date Time for Display

Hi AllI want to display time on Y axis and days on  x axis.I want to dispaly 12:00 AM,11:00 AM...11:59 PM.  on Y axis.I want function to create sequence like thatand on X axis display week like 6-sep,7-sep,..11-sep.can you give me the function for this.how i can create these

Date Time Formatting to a specific dateformat

Hello All,I have been struggling with this for a long time. I have a form in which there is a textbox using an ajax calender extender. Now, the problem is that, I want to take the Date value which is string format and format it to a specific date format before inserting it into the database. The following is the core problem:Dim MDate as string=txtMeetingDate.Textdim d as new Datetime' I want to convert the d to a datetime using the Mdate/// The problem is that I don't know what's the date format in the TextBox because users can use any time format they want, it is based on their windows settings!!!So, I am struggling to change my String (MDate) into a DateTime in the same format the user have and then convert it into my format:"dd/MM/yyyy" and after I have the date in the correct format, I want to change it back to string and save it in the database.I am doing this so that I have the same dateformat saved in my database.Any Ideas? ThanksAMB

How to display the date only till current date in ajax calendar extender .

Hi,1) How can i display the date only till current date in ajax calendar extender ?2)How to validate the date in one TextBox with the Date in another TextBox ?    Please Help me ...

I want to display date field in y-axis of stacked bar, how?

select date   from   employee   now i want to show this date field in y-axis of stacked bar please tell me whats the procedure of doing this?

SQL Management Studio 2008, does not display tables with specific permissions


Prev Reference Question: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/a6166b82-1e1a-4771-952d-a7b54e0b0f23?prof=required

I see the same problem with SQL 2008 Management Studio. I have different schema defined in my database, all the schema permissions work just fine in SQL 2005 but when viewed from SQL 2008. I cannot see tables for which i have given inidividual permissions. I have given SELECT permissions for those tables.

for example.

schema: dbo, schema1, schema2 ....

user: user1 (schema1 owner), user2 (schema2 owner), user3 ...

now i have given SELECT on schema1.table1 to user2

this works fine and i m able to see the schema1.table1 when login as user2 in SQL2005. I have tried your solution for giving "View Definition" permission as well. But this doesnt work in my case.

Seems to be some default permission settings with SQL 2008 ??

Any help/Suggestion will be appreciated

Fetch specific information(string) from another website and display the same in my website


I am beginner and need help.

I want design a page where the end user enters information on my page and related information is fetched from the another website on my web page.

For example: Capturing City and state name from USPS.com

End user Task : Enter zipcode and click button 'Fetch' 

My page perform few task

1. opens usps site backend

2. Enters the zipcode

3. Captures city name and state as temporary value from the usps

4. Displays the same in labels present in my home page.

I need help and designing the same.

how to display a row-specific owner-drawn tooltip in a datagridview?

I have an unbound datagridview and an owner-drawn tooltip in C# 2008. I want the draw event to be called on the tooltip. it does not get called. how can i make it get called, or otherwise display an owner-drawn tooltip, row specific? the popup event does get called and resizes the tooltip, but it stops there.

Display latest date in GridView



           I m getting data from database using SQL

string mysql = "SELECT [ID],[FirstName],[LastName],,[MiddleInit],[DateLastModified] FROM [Databse] WHERE ([ID] = '54321') ORDER BY [DateLastModified]";

I have 4 rows for this sql and I m displaying in GridView. I want the latest modified date as my first row but it is displaying in a reverse order. How can I display rows using Latestmodified date without sorting.


how to refresh display label.text under for loop condition


Dear All,

I have a for loop condition as below coding for looping to change word on label.text, but as a result, it just only display the last value.

pls help me how can I do to display each value for a looping.

i want the result is the label1.text to show 1 then 2, then 3, then 4.......finally is 10.

for i as integer = 0 to 10

   label1.text = i


thx all



incorect date value and formating on display form


On the list display form i have start date field which shows date in the folloving format : 2010-07-06T22:00:00Z

First it shows the wrong date since in edit from i see 7/7/2001

secondly the format is wrong since i choosen date only field so i don't want to see time and zone.

Does anybody knows why this happens and how to fix it?

Display date headers in SSRS reports


Hi All,

I have a report to display sales figure for the last 3 days including current date. That means whenever the report is generated it should start the date column with the current date and the previous 3 days data. I have the query ready to pull the data. But I am not able to generate the column headers in date format. Below is my report format for your reference...

  10/4/2010 10/3/2010 10/2/2010 10/1/2010
Product A

DataFormwebpart to display specific folder data of a List.



I am having one requirement where the DataFormwebpart should display specific folder data of a List. For an exxample I have one list which has three folders Level 1 , Level2 and Level3 . I want that when webpart is added on SharePoint page it should display data of Level1 and not the root level data of list. 

Basically the webpart needs to be drilled to Level1 folder by default rather than root folder of List.


display only the date (not time) from a sqlserver date field in dynamic data


I have some Date fields defined in my sqlserver database but these display with a time part as well (00:00:00).

how do i esnure that only the date part is displayed and not this redundant time?


want to display 24 hours time and date with datatype Datetime (Not String) in SSRS


Hi All,

I want to display 24 hours time and date in SSRS & for that I am using Format(now,"MM/dd/yyyy HH:mm:ss") but I am using this expression in Parameter, where I need to define datatype of that parameter as DateTime, not string. For Expression Format(now,"MM/dd/yyyy HH:mm:ss"), If I use DateTime datatype, It is showing error but working with String datatype.

For example:

I have parameter To Date  and value of this parameter should be 10/11/2010 13:09:16 (To Date: 10/11/2010 23:09:16) , not in AP or PM format and datatype of this parameter, want to keep DateTime that I can select value from Calender.

Please suggest me how I can achieve this?. I don't want to do it in stored Procedure side, want to do it in report side.

Thanks Shiven:)
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend