sanndeb
Last Activity: Jul 12 '12, 05:53 AM
Joined: May 18 '10
Location:
-
Thanks for the clarrification mate.... -
Thanks for the clarrification mate.... The first two are clear now.
But for the last one I need a little bit more clearence
The bold subquery runs fine individually, i.e. 'AA' has all the rows where there's no varchar value at all, then I'm putting a...Code:Select AA.Value from ([B]select Convert(numeric(10,2), Value) as Value from Table1 where isnumeric(Value)=1[/B]) AA where Value between 110.00 and 115.00
Leave a comment:
-
Order of execution in queries
I have a table with one column that contains blank(''), null, numeric & varchar data. So when I wanted to find values which are numeric & between a range I wrote something like
which works fine. But when I change the order of the 'where' it fails, i.e. the following SQL fails giving a conversion error...Code:select Value from Table1 where isnumeric(Value)=1 and Convert(numeric(10,2), Value) between 110.00 and 115.00
...Code:select
-
Not really :( It gives error saying you can't use aggregate function inside another :(Leave a comment:
-
I want to highlight only the max value, in this case the last value, not the total row.......Leave a comment:
-
Highlight max value in a subtotal row of a crosstab
Hi guys hope you all are fine....
I'm totally new to SSRS 2008 & stuck in a problem. So please help. :)
I have a crosstab report from northwind & I'm able to heighlight max value for each row with the expression below :
where "Year2" is my row group against year. There...Code:=iif(Fields!SalesAmount.Value = Max(Fields!SalesAmount.Value, "Year2"),"LightBlue","Transparent")
-
LayoutTransform error in silverlight TabPage
Hi guys,
I have a user control in Silverlight 4 as
...Code:<UserControl x:Class="FamilySolutionsPlanner.Win.Agreement" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:sdk="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls" -
COM DLL caching problem
Hi guys hope you all are fine :)
I have built a com visible dll in .Net 3.5. As i wanted to call it from classic asp & I registered it in the following way.
and my asp code is likeCode:gacutil /i COMCallFromASP.dll regasm /tlb COMCallFromASP.dll
...Code:<% Dim obj Set obj = Server.CreateObject("COMCallFromASP.HelloWorld") -
But I was talking about restart of a client machine without using the proper logout, then what's the way to log the user out forcefully, i.e change a tag in DB that the user is logged out?Leave a comment:
-
Does Session_End event catch machine restart or power off?Leave a comment:
-
Session + Client Machine Restart Issue
Hi All, Hope You Are Fine :), I Got A situation Here....
When a user log's with his login id on my web application i set a tag in the DB to "1" so that no other user with the same id can login from any other machine with the same login id, when he logs out i reset the tag to "0".
But the problem here occurs is that if a user gets logged in & then his machine suddenly restarts the tag in DB remains... -
Ok I Got It Done...
or byCode:foreach (var cmbi in cmbYears.Items.Cast<ComboBoxItem>().Where(cmbi => (string) cmbi.Tag == Datetime.Today.AddYears(1).Year.ToString())) cmbi.IsSelected = true;
...Code:cmbYears.Items.Cast<ComboBoxItem>().Where(cmbi => (string) cmbi.Tag == Datetime.Today.AddYears(1).Year.ToString()).Select(a => a).Single().IsSelected
Leave a comment:
-
Set Combobox SelectedValue from Code Behind In WPF
I have a combobox like
...Code:<ComboBox Height="23" HorizontalAlignment="Left" Margin="88,13,0,0" Name="cmbYears" VerticalAlignment="Top" Width="112" SelectionChanged="cmbYears_SelectionChanged" Canvas.Left="13" Canvas.Top="0"> <ComboBox.Items> <ComboBoxItem Tag="2010" Content="2010" /> -
Yes thats it mate... getting the results perfectly... thanks a lot :)Leave a comment:
-
But your query is returning only the first day of year 2010 i.e '03/01/2010', but the output should be of two days...'03/01/2010' & '03/02/2010'Leave a comment:
-
Thats ok to get the values using date.Attributes ("day").First() .Value inside the foreach loop... but what i wanted is to extract the dates directly using linq not inside another foreach loop.... i.e like at the end of the linq query i'll add a toList() method so that all day's will be listed in a list of string.Leave a comment:
-
Regarding a query in LINQ to XML
Hi, Hope everybody is file here....
I have an xml like this
...Code:<?xml version="1.0" encoding="utf-8" ?> <Holidays> <year year="2010"> <holiday day="03/01/2010" /> <holiday day="03/02/2010" /> </year> <year year="2011"> <holiday -
Access VBA From In C# Code
I have an excel file with a customized command button, named "Credit Matrix", the click of the button shows a VBA from like the picture below. What i need is to populate the textfields and comboboxes of the VBA from and click on the "ok" button. I tried the following to access the VBA from, but i failed..... :(
...Code:Excel.Application xlApp; Excel.Workbook xlBook; Excel.Worksheet -
Yep got the concept, will try it on my db and let you know. thanks for your effort. :)...Leave a comment:
-
That Was Perfect :)
Many Many Thanks... But Can It Be Done Without The Temp Table....Leave a comment:
No activity results to display
Leave a comment: