Search:

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 ...