Comments by Bhushan Shah1988 (Top 47 by date)

I think its not possible.

you are welcome. Do vote.

do yo have any parameter which tells you which currency it is??

what you want to do?

Please describe in details.

welcome.

Yes distinct works with count.

please specify exception.

can't understand..!!

you can use above function in stored procedure.

try dis :

select IsValidEmail(bhushanshah21@gmail.com)

and

select IsValidEmail(bhushan shah21@gmail.com)

Thanks Maciej Los :D

it depends on your sql query which is used in stored procedure.
you need to optimize query to minimize process time.

try this :

CREATE TABLE #TEMP
(
ITEM VARCHAR(50),
AMOUNT INT,
INDATE DATETIME,
USERID INT
)

INSERT INTO #TEMP VALUES('WATCH',500,'02/13/2013',1)
INSERT INTO #TEMP VALUES('WATCH',500,'02/13/2013',1)
INSERT INTO #TEMP VALUES('BELT',300,'02/13/2013',1)
INSERT INTO #TEMP VALUES('WALLET',600,'02/13/2013',2)
INSERT INTO #TEMP VALUES('WALLET',700,'02/13/2013',2)
INSERT INTO #TEMP VALUES('TROUSERS',1600,'02/13/2013',2)
INSERT INTO #TEMP VALUES('TROUSERS',1300,'02/13/2013',2)

SELECT USERID,COUNT(*) AS NoofProducts
FROM #TEMP
GROUP BY USERID

DROP TABLE #TEMP

what is the error??

in your previous query, you used patient_progress_tracking_details table and now you are giving structure of progress_tacking_other_details.

please provide me script with some data.

mark as answer if it helps you.

you cannot use where with INSERT.

what is your issue??

put one more filter in the query of second page which will filter your records and give only one record.

Please explain clearly..

Please describe in briefly.

provide your full code.

give ur sample code here.

what is your problem?

you can use .Trim() method at the time of filling data in DataTable.

did u execute your query in sql server?

does it returns any rows??

what do you mean by reset?
you want to clear all data or something else??

select * will always give all fields from table.

did u bind datasource to drop-down list?

Please describe briefly what you want?

Please tell me in which table Dateto and Datefrom are??

Please brief properly.
Tell us what you want?

so what is your problem?

Please provide some sample data with script.

WHAT YOU WANT TO SET IN BACKGROUND?
ANY IMAGE OR SPECIFIC COLOR?

EXPLAIN YOUR PROBLEM PROPERLY.

than try to check it with converting in into UPPER Case.

provide your sample code..!!

so what is your problem?

what kind of validation you want in textbox of edititemtemplat of a gridview?

please provide your sample code...!!
so we can find problem in that..!!

Please provide some more information.

Please give some more details.