I am already having this solution but now its performance issue on huge data.
Thanks for your inputs
Riyaz...
CoolRiyaz
Last Activity: Mar 29 '07, 01:23 PM
Joined: Mar 28 '07
Location:
-
Ya, this is fine...Leave a comment:
-
If you want to store the objects please read 'Object Serialization'.
But you can not store it in db, they will be stored on hard diskLeave a comment:
-
Hi
Try this:
Code:UPDATE CriticalDoctors SET CD.Percentage = TP.PercentTime FROM CriticalDoctors CD, tblPercent TP WHERE CD.Doctor = TP.DoctorID
Leave a comment:
-
Hi
Try this:
Code:SELECT ColumnList FROM YourTable WHERE COALESCE(Field1, Field2, Field3, Field4, Field5) = 'Search Criteria'
Leave a comment:
-
Hi
sorry,
I am using SQL Server 2000
Now tell me what to do.
Thanks...Leave a comment:
-
Suppose my query is :
SELECT FirstName, LastName, Address FROM EmpMaster
I want the output like :
SrNo FirstName LastName Address
1 asas dfddsf dfdsf
2 dsfdsfdsf dfdsfdsf dfdfsdf
3 .... and so on
I dont want to use temp table and IDENTITY...Leave a comment:
-
write this code on form load and it is for Datagrid control.Leave a comment:
-
your prime requirement was data entry in Datagrid.
This technique is suitable for you.Leave a comment:
-
Return Record Number with query
I want to return record number with my query output.
I dont' want to use IDENTITY function and temp table for this purpose as I am dealing with very huge data.
any suggestions...
Riyaz -
better can be:
Build the disconnected recordset with the column names of datagrid as its fields
and assign it as datasource.
while saving it to database use this recordsets value:
Suppose you want columns like
First Name Last Name Address
...Code:with rs.fields .append "[First Name]",adBSTR .append "[LastLeave a comment:
-
USE
UPPER function while inserting record:Leave a comment:
No activity results to display
Leave a comment: