padmaneha
Last Activity: Nov 7 '08, 10:55 AM
Joined: Sep 17 '08
Location:
-
can u please write a code for example?... -
Regex.Replace(s tr1, m.Result("$2"), sRep);
str1 is the htm file where the string is to get modified and srep is the string that replaces ..Leave a comment:
-
How to omit replacement in somepart of text using regular expression?
How to omit replacement in somepart of text using regular expression?
For ex:
If i want to replace mumbai with mumbai/aaa.com but if i have an anchor tag
<a href="/mumbai/bbb.com>mumbai</a>
then in the anchor tag too the replacement takes place which should not be done..
How to solve this problem? -
Thank you for your reply. I will try the queryLeave a comment:
-
Checking for mismatch entries in two tables (Urgent Please)
There are two tables in our database Businessmaster and locationmaster
Businessmaster has the following fields like contentid, businessname, businesstype, location, city, state, country, zipcode, citylocid, statelocid and the locationmaster has the fields like contentid, location, city, state, country and I need to fetch all those mismatch records inner joining Businessmaster table and locationmaster table in which city and state are not the... -
Sql query for sorting the output in the descending order
Select distinct b.contributor, blogaddress,cou nt(b.contentid) RecipeCount,isn ull(c.cnt,0) Other
from weblogs.dbo.blo gentries b left outer join (select contributor , count(*) cnt from weblogs.dbo.blo gentries where category='food' and subcategory = 'others' group by contributor) c
on b.contributor = c.contributor
where category='food' and subcategory<>'o thers' and destid>0
group by b.contributor,b logaddress,cnt... -
Sub Query for fetching records - Urgent Please
I executed the below query for getting the details of dishes which are tagged to the festival 'Durga Pooja'
select fg.tagname, fg.foodid, f.dishes, f.dishtype
from foodtag fg inner join food f
on fg.foodid = f.contentid
where tagname='Navrat ri / Durga Puja' and isapproved=1
order by foodid
Result is displayed as fetching some 167 records approximately
Festival tagname ... -
Query to display Count as zero if no records exists - Urgent please
Count should be displayed as zero if there is are no recipes posted
select f.dishes,f.cont entid,f.titleur l,count(f.dishe s) as Recipescount from food f inner join foodmemberpref fmp
on f.contentid=fmp .foodid where isapproved=1 and blogcid>0
and f.contentid in(1,30,68,73,8 3)
group by f.dishes, f.contentid,f.t itleurl
When I execute the above query I get the result displayed as given below
... -
Select query to know the Count of two columns in different tables
I need to fetch the count of Recipes posted on each day. For example if the following data is given
CrDate Dishes
2008-09-01 00:05:04.483 1
2008-09-01 00:06:31.653 1
2008-09-01 04:35:44.983 1
2008-09-09 08:51:20.857 1
2008-09-09... -
Hi
Thanks a lot for your response the query worked out...Leave a comment:
-
SQL Query to display count of two columns from different tables
Hi
Thank you for your response. Query doesnt give the expected result.
Here is the sample data :
Foodid blogcid
3 12356
3 12357
3 12358
9 15265
15 18963
15 18964
19 ... -
Hi
Thank you for your response. Query doesnt give the expected result.
Here is the sample data :
Food id blog cid
3 12356
3 12357
3 12358
9 15265
15 18963
15 18964
19 0
...Leave a comment:
-
SQL Select Query to fetch Count of two columns from two different tables
Hi
Thanks for your response but the query which you gave in my previous post doesnt work. It displays the same cnt for movie reviews and videoreviews
Let me explain you in detail
As I said I have got two tables like one is 'Food table' and the other one is the 'Videos' table
Columns which I have created in 'Food' table are 'foodid' and 'blogcid'
colcumns which I have created in... -
Hi
Thanks for your response but the query which you gave doesnt work. It displays the same cnt for movie reviews and videoreviews
Let me explain you in detail
As I said I have got two tables like one is 'Food table' and the other one is the 'Videos' table
Columns which I have created in 'Food' table are 'foodid' and 'blogcid'
colcumns which I have created in Videos table are 'videoid,...Leave a comment:
-
Select query for fetching records from two tables
Hi
I have created two tables which are movies table and videos table
Columns of movies table are movie id, movietitle, moviereviewid and the select statement which I have written to fetch count of reviews is as follows
select movieid, count(movierevi ewid) as Moviereviewscnt from movies
where moviereviewid >0
columns of videos table are videoid, videoname and movievideoid and... -
Hi Thanks for your help....Leave a comment:
-
Procedure for deleting records
Hi
I have created two tables 'TrainsMaster' & 'TransArrvlDepi nfo'
Columns which I have created in 'TrainsMaster' are 'trainName,Trai nNo, StartStaionId, & EndstationId'
Columns which I have created in ''TransArrvlDep info' are 'Stationcode, TrainNo, Arrvaltime,Dept time'
I have to delete few trains from 'TrainsMaster' for which the Startstationid or Endstationid are nulls which...
No activity results to display
Leave a comment: