|
|
-
Pavan Question Asked 1 Months ago through ASK
Hi
How to Convert this date format YYYYY-MM-DD HH:MM:SS.MMM(2012-04-02 02:04:36.443) to MM/DD/YYYY HH:MM:SS(04/02/2012 02:04:36) this date format?
Thanks
Pavan...
|
-
Pavan Question Asked 1 Months ago through ASK
Hi
How to Convert this date format YYYYY-MM-DD HH:MM:SS.MMM(2012-04-02 02:04:36.443) to MM/DD/YYYY HH:MM:SS(04/02/2012 02:04:36) this date format?
Thanks
Pavan...
|
-
Pavan Question Asked 1 Months ago through ASK
Hi
How to Convert this date format YYYYY-MM-DD HH:MM:SS.MMM(2012-04-02 02:04:36.443) to MM/DD/YYYY HH:MM:SS(04/02/2012 02:04:36) this date format?
Thanks
Pavan...
|
-
Pavan liked 2 Months ago through Interview Questions
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|
-
Pavan Question Asked 2 Years ago through ASK
<p>Hi ,</p>
<p>i have following table and i want to update this tabe</p>
<p> </p>
<p>
<table width="276" cellpadding="0" cellspacing="0" border="0">
<colgroup><col width="64" span="3"></col><col width="84"></col></colgroup>
<tbody>
<tr height="...
|
ask
92
·
2% ·
491
|
|
-
Pavan Question Asked 2 Years ago through ASK
<p> </p>
<p>Hi ,</p>
<p>I am writing query for folloing logic but i could't do it so can any one help me on this ?</p>
<p>Logic: I need a out put of people whoever pass or fail.so firstly if any person have contain "fail" word in Exam(e.g mat...
|
|
ask
92
·
2% ·
491
|
|
-
Pavan Question Asked 2 Years ago through ASK
<p style="padding-left: 30px;">I have one issue with reporting services.here is example.</p>
<p style="padding-left: 30px;">When you set a row's hidden property to true, RS writes a white row. Is there a way to keep the background color the sa...
|
|
ask
92
·
2% ·
491
|
|
-
Pavan Question Asked 2 Years ago through ASK
<p>i am calulating a BMI(Body mass index) .I have problem in getting output.</p>
<p>BMI equation : <img src="http://upload.wikimedia.org/math/0/5/f/05f9469f7e1e8c14860b3e7d8dfe3672.png" alt="Wikipedia Formula USA" class="tex" /></p>
<p> </p>
<p>i a...
|
|
ask
92
·
2% ·
491
|
|
-
Pavan Question Asked 2 Years ago through ASK
Hi friends
I am stuck in logic and i need your help.
i want distinct count bansed on fname,lname,dob for 2008 and 2009 and aslo count of distinct people who have mached in both year.
here is scenario
<table width="312" cellpadding="0" cell...
|
|
ask
92
·
2% ·
491
|
|
-
Pavan Question Asked 2 Years ago through ASK
<div>
<p>Hi ,</p>
<p>I have problem in following scenario.</p>
<p>I have one dataset that are matching people by firstname,lastname,DOB..i would like to give them uniqueID as following example.</p>
<p> </p>
<table width="335" cell...
|
|
ask
92
·
2% ·
491
|
|