Blogs RSS Blogs RSS Forums RSS Forums RSS
•
•
•
•
Showing results 1 to 17 of 17
Search took 0.01 seconds; generated 1 minute(s) ago. Posts Made By: newMeg
Save these search results for 24 hours
Forum: MS SQL Aug 24th, 2008
Replies: 4
Views: 571
Posted By newMeg
Re: SQL Query Help needed!

Hi, Thanks for the reply. I did an inner join and i'm still not getting the result. Nothing is queried out because of the c.CreatedBy = '2418' which doesnt exist for the identifier...
Forum: MS SQL Aug 24th, 2008
Replies: 4
Views: 571
Posted By newMeg
SQL Query Help needed!

Hi,
I need help on this sql. I have a table a and b and i need to select where a.id=b.id and b.mid=1 and few hardcoded a.id which does't exist in table b. i used left outer join but its still...
Forum: MS SQL Feb 21st, 2008
Replies: 2
Views: 405
Posted By newMeg
Help Help onGetting subcategoryname that share the same category but tied to another table

Hi I have 3 tables in my database.
1) photo
2) category
3) subcategory

in my photo table i save my subcategoryid which is tied to the category table.

What i need to do is get the all the...
Forum: MS SQL Apr 23rd, 2007
Replies: 7
Views: 3,625
Posted By newMeg
Help Re: query for creating report group by weeks (with start date and end date of the week)

Hi David,

Thanks for the reply. But I was wondering why do we use date part as datepart function is to get the date different either in weeks or days or months right?

From the sql u just...
Forum: MS SQL Apr 23rd, 2007
Replies: 7
Views: 3,625
Posted By newMeg
Re: query for creating report group by weeks (with start date and end date of the wee

Hi David,

Still Stuck on the SQl. Let me explain, I have table fields called doctor d,clinic c,pmr pmr,patient p,course cor
Patient contains patientID,which is a primary key and it appears as...
Forum: MS SQL Apr 13th, 2007
Replies: 7
Views: 3,625
Posted By newMeg
Re: query for creating report group by weeks (with start date and end date of the wee

Hi David,

Im not sure if i got the last part right. For my report Could u explain how i can do it ..i mean creating the new table. Based on wat i see, do i have to create two fields in the new...
Forum: MS SQL Apr 11th, 2007
Replies: 7
Views: 3,625
Posted By newMeg
Help query for creating report group by weeks (with start date and end date of the week)

Hi,
I'm a bit stuck. I've been breaking my head quite long figuring how to do this.
I need to generate areport that is grouped by week.

i need to display total number of patients who are enrolled...
Forum: MS SQL Apr 11th, 2007
Replies: 3
Views: 3,189
Posted By newMeg
Re: need help on replacing a value in a field (MSSQL)

Hi hollystyles ,

you are always a great help. sorry for the late reply.the query example u said works great and solved my problem.

thanks again and sorry for th elate response.
Forum: MS SQL Apr 3rd, 2007
Replies: 3
Views: 3,189
Posted By newMeg
Help need help on replacing a value in a field (MSSQL)

Hi,

I have a table in which there is a field for mobile no. Currently the data in the field has been entered with a dash(-) after the code.

eg-

MobileNo (this is the field...
Forum: MySQL Jan 20th, 2007
Replies: 2
Views: 1,851
Posted By newMeg
Re: Hi, need advice on sql statement and table structure

Hi, thanks a lot for the reply. But i dont actually get wat u mean. I really need to solve this if by at least changing the sql and not changing the table structure as i will need to change my codes...
Forum: MySQL Jan 19th, 2007
Replies: 2
Views: 1,851
Posted By newMeg
Help Hi, need advice on sql statement and table structure

Hi,

I have two tables that stores product details which is carinfo and products.I did it in 2 separate tables as the products are by diffrent category and therefore the fields are different. I'm...
Forum: ASP.NET Sep 4th, 2006
Replies: 2
Views: 15,303
Posted By newMeg
Help Need help on export asp.net table to excel

Hi im developing an asp.net report using vb language. I created the report previously using datagrid,which works well when i click the export button. It downloads the datagrid to excel format. But...
Forum: MS SQL Jul 18th, 2006
Replies: 6
Views: 6,006
Posted By newMeg
Re: Hi,Need help on sql select statement structure

Hi Hollystyles,

You have been a great help. Thanx alot. I'll sign up to the forum you suggested. Can u explain about the example you gave in the last post. I dont really understand the example you...
Forum: MS SQL Jul 17th, 2006
Replies: 6
Views: 6,006
Posted By newMeg
Re: Hi,Need help on sql select statement structure

Hi hollystyles (http://www.daniweb.com/techtalkforums/member29709.html),

Thanx for the reply.it works great.But I have some columns in the table where the values are unpredictable,which means that...
Forum: MS SQL Jul 17th, 2006
Replies: 6
Views: 6,006
Posted By newMeg
Help Hi,Need help on sql select statement structure

Hi,

I am not sure if my question sounds silly. I have a table that has a few columns like date,source,race and state. I need to generate a report. The table stores the details of callers including...
Forum: MS SQL Jul 9th, 2006
Replies: 2
Views: 2,260
Posted By newMeg
Re: Need Help on SQL Query for select statement

Hi hollystyles,

thanx for the great help.It works.
Forum: MS SQL Jul 7th, 2006
Replies: 2
Views: 2,260
Posted By newMeg
Help Need Help on SQL Query for select statement

Hi,I'm new to daniweb forum. I hope someone could help.

I have a table called Caller which has a field called Area. I need to select the value of the record in this field that repeats the most. For...
Showing results 1 to 17 of 17

 
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 10:45 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC