Search:
Type: Posts; User: yousufkhan73
Search:
Search took 0.02 seconds.
-
yes i tried that dose not solve it
-
yes i tried that dose not solve it
-
i could not explained the issue in my previous thread so i tried to explain in this
-
I have 2 tables in sql server db I wanted generate a report which will display
the following result
TotalNoofBeds, NoofDaysInMonth, Month, Year, TotalNoOfAdmissions
Table 1,
BedMaster
BedID...
-
Answers
1. Yes
2.this is unique table record id i have selected it just for a sample data (it cant be ignored)
3.yes it may have more than on inptnid it get changes every time when patient get...
-
160981
Sample data and expected result
-
I have already mentioned in first question i need unique record for a specific PtnID it is not like that for sql server to guess i thought you will understand by seeing the result its ok
i will try...
-
I have already mentioned in first question i need unique record for a specific PtnID it is not like that for sql server to guess i thought you will understand by seeing the result its ok
i will try...
-
i need all fields that's y i asked the question, grouping is simple but it is not solving my issue just have a look at picture i posted
i want to have all fields
-
i have this following table i need query unique records for a specific PtnID(field) from the table
select * from table where ptnid=201300025 and i should select unique records of PresNo(field)
...
-
declare @fdate as date
declare @edate as date
set @fdate='03/01/13'
set @edate='06/30/13'
;with Items(TotalNoItem ) as (select count(ItemCode ) from ItemMaster),
Months(TotSaleItem, Mnthyr) as...
-
sorry bro
database is SQL Server 2012,
1-ItemMaster
ItemCode - integer
ItemName - varchar
2-ItemSale
ItemCode - integer,
SaleDate- Date ,
-
sorry bro
database is SQL Server 2012,
1-ItemMaster
ItemCode - integer
ItemName - varchar
2-ItemSale
ItemCode - integer,
SaleDate- Date ,
-
sorry i missed some columns
it should be like this
TotalNoItem GivenMonthDays Totalsale Month-Year
20 31 90 Jan-2018
20 ...
-
query for multiple months report
I have 2 table
1-ItemMaster
ItemCode, ItemName
2-ItemSale
ItemCode, SaleDate,Amt
i wanted to have query as follows
user will select give date as...
-
this are my code for getting picture from xml to imagebox
Dim DOM As MSXML2.DOMDocument
Dim elemPht As MSXML2.IXMLDOMElement
With New MSXML2.DOMDocument...
-
I tried like this
kindlly correct where i am wrong
Dim strStream As ADODB.Stream
Set strStream = New ADODB.Stream
strStream.Type = adTypeBinary
strStream.Open
...
-
Can any body tell me how can I insert picture into sql server db through vb6
i have imagebox on form and this imagebox's picture i wanted to save in the database
-
I have string in which there are 3 to 4 words
i wanted to separate all 4 word in individual 4 string variables
-
thanks for your support
i wanted to put this picture in the either image object or Picrutebox on the form
instead of painting on form
so that i can store it in the database from image object
-
I have follwong xml file which as a iamge in Pht tag
how can i convert to image and place the it in the image box/picture box
<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<UidData...
-
I have xml string i wanted to get a specific node vale by node name
how can get it i tried this
Dim xmlDoc As DOMDocument
Dim objNodeList As IXMLDOMNodeList
Dim objNode As IXMLDOMNode
Dim...
-
I am getting some output in xml format from a url
now How to use xml parser in vb6 and
read the content of the data
-
you mean the whole message should be wrapped in like this {"Message": null }
-
Sorry for delay actually i got this url which generate the JSON output from other developer who gove this format as json to embed in my project
for fetching information, according to your inputs it...
-
I have follwing JSON format from i wanted to read elements from kycinfo i wanted have name, address etc I tried
Dim p As Object
Dim nm as string
Set p = JSON.parse(vOut)
nm =...
-
but if i create TVF then how can i generate crystal report is it possible
-
I would like use it in a view
-
with cte(RevDate, RevDesription,CashAmt,CardAmt,ChqAmt)
As
( select '10/01/17','MedServices' as MedServices,
( select SUM(op_dtl.net_amt) from op_dtl where rev_dt='10/01/17' and chrg_cd not in...
-
I have table in sql db with 10 lacs of record
i have added a new column in that as row no by default I set the value as 0
now i wanted ot update with row no or record no from 1....... to 1000000...
-
I am sorry if I couldn't explain it properly
but what u have understood is correct only the thing is that
I ll tell what format I am looking for
this is almost correct times:=Mor & "..." & Aft...
-
I have a table with 4 columns (Morning/Afternoon/Evening/Night)char(1) field data will Y/N in the column
with this table i am creating a crystal report
the output should be something like this
...
-
there will be a single table from which I need to fetch the last record as I mentioned
in this set @LastNo =('Select MAX('+@FldNm+') From '+@TblNm)
but I want use this function for any table...
-
I am working on following function I want to pass Field and Table name to the select query in the function
function
[CODE][/USE [Hospital]
GO
/****** Object: UserDefinedFunction...
-
I have working on following function I wanted to pass a filed name and table name to
a select query in the scalar function
ALTER FUNCTION [dbo].[GetYearWiseNo]
(
@FldNm as varchar(30),...
-
I am sorry I may be wrong in explaining you
I don't want distinct record I am very clear I want all those ItemCode which are more than one in a table but their MRP is
different ,
If the...
-
I am explaining what I want by the follwoing example
this is table ItemMaster which contails the follwing records
Itemcode ItemName MRP
3 AZEE 500 MG INJ 210.89
4 ...
|
Click Here to Expand Forum to Full Width
|