Search:
Type: Posts; User: yousufkhan
Search:
Search took 0.07 seconds.
-
my question is very simple i have itemcode and mrp column in the table it can have multiple records with same itemcode with same and different mrp
I wand to query only those records which are...
-
I have table ItemMaster (ItemCode, Mrp) I wanted to query only those records
having different mrp with same ItemCode if there is a single record i dont want that
only multiple record with...
-
I have created following procedure for sending SMS
earlier it was working fine suddenly it has stop working
what is the problem can any body guide me urgently it has hamper my work
CREATE...
-
Oh thanks our are right funky i should be using a full outer join to get the result from a atleast single table my inner join is wrong
thanks a lot
-
I have written the following CTE
for monthly analysis but
there are 4 table from where i am fetching the data for the given months
if the given month is not present all table it skipping the...
-
This procedure suddenly has stop working it was working very fine earlier
where would be the problem
ALTER procedure [dbo].[SendSmsSQL]
@MobileNo varchar(12),
@smstext...
-
I have written the follwoing sp for sending sms
i wanted send sms in other language how to pas the text in other language
to a declared variable @smstext
for example i have like set @smstext...
-
I am not getting the accurate sum by joining
select sum(d.depamt ),sum(a.apamt ),sum(r.rfndamt)
from deposits d,apply a ,refund r
where d.custid=123969 and d.custid =a.custid and d.custid =...
-
I Have three table
Table 1 Name Deposit(CustID, DepAmt)
Table 2 Name Refund(CustID, RfndAmt)
Table 3 Name Apply(CustID, ApplyAmt)
I want have query so than i can...
-
I am creating internet explorer object
and navigating it and always getting this error "System shutdown has already been scheduled
can help me where I am wrong in the following codes
Private...
-
I am opening internet explorer from vb6 program in the following manner
it is getting open but in minimize mode i wanted to open in maximize make it active
Set ie =...
-
Yes it is windows forms and I am using DataGridView / ListView on both i am having same problem
this one sample where i am putting data into datagridview
so i tried DateTime.Parse while putting...
-
my .net application is developed on win 7 where it work fine
i am using datagrid i have date column in it on double click of datagrid i handover the grid data to text boxes
while handing date type...
-
select case with and operator
I have 2 parameters for which i wanted to wirte select case i tried something like this
Select case cmbo1.value and combo2.values
case 1 and 2
mycode
case 1 and...
-
i have datagridview for displaying and records and to remove the rows the dgv is having a checkbox for selecting the rows to remove
i did in the following way
For Each row As DataGridViewRow...
-
-
I have a Datetimepicker on form and sql table having Time Field
datetimepicker is set to customformat as "hh:mm:tt"
i wanted to set sql table's time to datetimepicker
i queried the table got...
-
i tried byval also
if i remove listview from function its working fine but when i am declaring Lv as listview and calling the function it giving error
-
it is highlighting
Call lsthlpbatch(StrTxt, lvhlp)
-
space is their in the code by mistake i written here
-
I have private procedure like this
Private Sub lsthlpbatch(ByVal StrHlp As String, Lv As ListView)
Lv.Refresh
Lv.ColumnHeaders.Clear
Lv.Visible = True
...
-
I have student data in xml file
i wanted to generate and download a pdf file from xml file for a specific record
-
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txt1"...
-
I want to create a page for the student to download the hall ticket by putting their rool no and date of birth in the textbox and aurthenticating it
I am planning to use xml file for student data...
-
select unit,count(*) from (select unit from table where
date between '03/01/14' and '04/31/14'
union all
select unit from table2
where date between '03/01/14' and '04/31/14'
group by unit
...
-
-
select code,unit from talbe1
union all
select code, unit from table2
but how query the list and get total units
-
I have 2 sql tables table1 and table2 both table are having same fields - Code, unit, amt,date
i want to write a query to have total count(unit) from both table in a single query
but its not...
-
I wanted use a foot pedal in my application
and perform some action on the click of the pedal
how can I capture that event of foot pedal
-
I am working one image management project now i wanted to write printing for the same
I have images into folder and text in the sql table
i wanted club the images and text from the sql table...
-
yes you are right its not fixed there can be more trntypeid's
-
Database is SQL server 2008 R2 instead of coumn descripton we can use TrnTypeID which is fixed
-
I have table AmtDtls in which i have columns
CustID, TrnTypeID, TrnDesc , Amt,
1 1 SrvCharges 500
1 1 SrvCharges 200
1 2 ...
-
I have done some big projects in c#.net created exe
and i tried to decode the exe my exe's are easily getting decode by some decoding softwares
lite .net reflector etc...
What shall I do so...
-
I have 2 tables I SQL DB
1.BedMaster - fiels(WardNo,BedNo,BedSts)
Data(G2,G1,A)
2.Admissions fileds(AdmNo,PatientNo,BedNo,AdmissionDate,DischargeDate)
...
-
Yes I wanted the output in text file in a formatted way I fixed width columns for the printing
-
How can I declare a fixed length string
fixed mean if I declare a length size of 30 it should always be of 30
even if the data is of less then 30 it should take space of 30
if should not reduce...
-
Thanks Funky
its working
if i have age 400 days it shuld select agegroupid 2 - this was wrong by mistake i have writtern 400 it would have 6570
thanks
-
are you using db connection to retreiw data if so please check the connection
-
I have table Called AgeGroup and fields are
AgeGroupID, AgeGroupName, MinAgeDays , MaxAgeDays
I wanted a query to select the AgegroupID & AgegroupName by pass AgeIndays
to query whose...
|
Click Here to Expand Forum to Full Width
|