|
What do you expect? You've specified that put quotes around your @appdate entries turning them from variables into constants. Remove them.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Two errors in your code
1. only string constants to be enclosed in quotations. Not variables.
Remove quotations ( this is for Syntax Error)
2. Dates should be enclosed within quotation. (this is for logical error. other wise it takes as 01/01/1900)
Regards
KP
|
|
|
|
|
Ok i need o/p...,
Give me some solution to solve that probs...,
Regards,
Magi
|
|
|
|
|
If i remove the quotes...,
It will give year 1900 and month always 1
Regards,
Magi
|
|
|
|
|
Magi,
you want to send date as a input parameter from your application to stored procedure right!
all you got to do when you create the stored procedure mention the parameter datatype as datetime and when in your code when creating parameter mention the sqldbtype as datetime.
This would solve your problem you need not put any quotes when using the name of the parameter you can directly give @param_name wherever you like in your stored procedure
gauthee
|
|
|
|
|
Hello,
VS 2005
I have find myself getting all my code in a mess about having data populated into control and then having to modify the data in the controls.
I always use typed dataset, binding source.
But I have some questions. I have read that you should always perform operations on the binding source
rather than the control it is bound to.
i.e.
If I have a datagridview and I want loop through some rows based on a certain condition, then I should loop through the rows in the binding source and filter for those rows, rather than looping through the dgv rows. Is this a correct assumption.
I have also read that you should set the datasource property of the control only once.
This is what I have done in the past, and please correct if I am wrong.
If I have a child parent relationship then I sent the child binding source to the parents binding source
in the designer, so that if a user click on a combo box then child data is correctly dislayed in the
datagridview, without writing any code.
In the form event I would have sub routines that would call for the controls to be populated.
<br />
Private Sub FillDataGrid()<br />
Try<br />
Me.OrderDetailsTableAdapter.Fill(Me.DataSet1.OrderDetails) <br />
Me.DataGridView1.DataSource = Me.bsOrderDetails<br />
Catch ex As Exception<br />
MsgBox(ex.Message)<br />
End Try<br />
<br />
End Sub
<br />
Private Sub FillCombo()<br />
Try<br />
Me.ComboBox1.DisplayMember = "OrderID"<br />
Me.ComboBox1.ValueMember = "OrderID"<br />
Me.ComboBox1.DataSource = Me.bsOrders<br />
Catch ex As Exception<br />
MsgBox(ex.Message)<br />
End Try<br />
End Sub
Normally, if was to add a new order details i would call the FillDataGrid() to load the data again, i
normally do this when I delete and modify.
<br />
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles <br />
<br />
btnSave.Click<br />
Try<br />
Me.bsOrderDetails.EndEdit()<br />
Me.OrderDetailsTableAdapter.Update(Me.DataSet1.OrderDetails)<br />
<br />
Me.FillDataGrid()<br />
Catch ex As Exception<br />
MsgBox(ex.Message)<br />
End Try<br />
End Sub
This is just a small example, my applications are always much bigger and contain a lot of modifications
to the data and have a lot of controls to update. However, this means that I am always calling re-filling the setting the datasource each time a add, update, or delete has happend to the data.
Any feedback would be most helpful.
Steve
|
|
|
|
|
SELECT EM.empId, TC.carddate,SD.Whrs,
MHD.Appwhours as AppHours,MHD.AppOtHours as AppOtHours
FROM dbo.tblEmployeeMaster EM INNER JOIN dbo.tblTimeCardmain TC
ON EM.empId = TC.empid INNER JOIN dbo.tblSalaryDetails SD
ON EM.empId = SD.EmpID left outer join dbo.tblMonthHourdetails MHD
ON TC.empid=MHD.empid and TC.Carddate=MHD.Sdate
WHERE TC.carddate = '8/1/2007' AND TC.app1 = 1 AND TC.projectid = 100
order by EM.Empid
Hi this is my query:
For this i am getting o/p like:
Empid carddate whrs AppHours AppOtHours
100 8/1/2007 11 11 3
101 8/1/2007 8 8 6
102 8/1/2007 11 11 3
103 8/1/2007 11 11 3
103 8/1/2007 11 11 3
See that empid=103 have 2 entries in tblsalarydetails...,
So its givng in o/p also 2 values...,
But there i need one o/p that want to be based on the date...,
In my tblsalarydetails i have date column...,
So How to display the whrs based on the date for that employee?,
Plz hlp me...,
Tblsalarydetails table design:
empid whrs edate
100 11 8/1/2007
101 8 7/1/2007
102 11 8/1/2007
103 11 8/1/2007
103 10 2/21/2007
Regards,
Magi
|
|
|
|
|
Use SELECT DISTINCT instead.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi Magi
Try:
SELECT EM.EmpId, TC.CardDate, SD.Whrs,
MHD.Appwhours as AppHours, MHD.AppOtHours as AppOtHours
FROM dbo.tblEmployeeMaster EM
INNER JOIN dbo.tblTimeCardmain TC
ON EM.EmpId = TC.EmpId
INNER JOIN dbo.tblSalaryDetails SD
ON EM.EmpId= SD.EmpId
AND SD.EffectiveDate = (
SELECT Min(A.EffectiveDate)
FROM dbo.tblSalaryDetails A
WHERE A.EmpId = EM.EmpId
AND A.EffectiveDate <= TC.CardDate)
LEFT OUTER JOIN dbo.tblMonthHourdetails MHD
ON TC.EmpId = MHD.EmpId
AND TC.CardDate = MHD.Sdate
WHERE TC.CardDate = '8/1/2007'
AND TC.app1 = 1
AND TC.projectid = 100
ORDER BY EM.EmpIdIt uses a correlated sub-query to find the effective salary record (assuming your date column is named "EffectiveDate").
Regards
Andy
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
Hi,
Please send me how to get last 10 records in a table( There is no index on table)
|
|
|
|
|
select top 10 * from tablename order by [id] desc
I Love SQL
|
|
|
|
|
Hi I mean to say newly inserted records.
i.e Suppose a table have 1000 records.I need to retrieve 991 to 1000 records.
|
|
|
|
|
If you have column named ID which is autonumber then my query which i posted before works
I Love SQL
|
|
|
|
|
Hello all
I am writing the query to select values between two dates. My query is
Select * from Table1 where date_sent between '25-Jul-07 12:00:00' and '01-aug-07 12:00:00' this is not retrieving me any data as there are some entries between those dates in the table.
i had tried using >=25-Jul-07 and <=02-aug-07 ' but this is fetching me 25th and 26th july data which is not supposed to be happened.
did i miss something which is very important in the query.
thanks in advance.
Bharath.S Ron
|
|
|
|
|
Select * from Table1 where date_sent >= convert(varchar, (convert(datetime,'25-Jul-07 12:00:00')),102) and date_sent <= convert(varchar, (convert(datetime,'01-aug-07 12:00:00')),102)<br />
<br />
I Love SQL
|
|
|
|
|
Hi all
i am new to sql,s o plz could any body help me to to write the query to display the duplicate record in sql server.
|
|
|
|
|
If you want to display how many times is displayed col1 the use query down below
select col1,count(col1) from TableName group by Col1
Hope this helps you
I Love SQL
|
|
|
|
|
Hi,
I have two tables in which i could not find any unique relationship. Can anyone help help me, how to view metadata of oracle table. can metadata help in solving table dependency problems.......
Regards
Manish
|
|
|
|
|
This is the last piece of a very long puzzle. I have searched and searched for the answer to this problem, but I have not uncovered anything that shows me how to do this.
I need to run the below sql inside of a stored procedure. There can only ever be one AccountID that has the Col2 value of 1. How do I get the AccountID into a parameter that I can use in serveral other statements being run inside of the same stored paramater.
Select AccountID FROM Table where Col2 = 1;
|
|
|
|
|
declare @accountId int
select @accountID = AccountId from table where col2 = 1
You may want to put a 'top 1' in there, and an if exists (select blah, to make sure that there is at least one, and that you only grab one. I know you're saying it will always work, but better to be sure.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I am having a difficult time importing a file to either MS Access or SQL Server 2000. The following is a sample of the file I am trying to import. I am using a SQL script that can be use with the DTS wizard.
Thank you for your assistance.
Sample 1
Patient Name Patient SS# DOS CPT Code Charge Amount Diagnosis 1 Diagnosis 2 Diagnosis 3 Diagnosis 4
Sarnio, Jim R 111-11-1111 Aug 7 2003 99242 154.00 717.7
Aug 7 2003 73564 139.00 717.7
Aaron, Peter E 222-22-2222 Feb 14 2006 99274 220.00 722.0
Feb 14 2006 95903 226.04 722.0
Feb 14 2006 95904 185.36 722.0
Feb 14 2006 72050 190.00 722.0
Smith, John A 333-33-3333 Oct 3 2006 99205 224.00 735.0 735.4
Oct 3 2006 73630 117.00 735.0 735.4
Oct 3 2006 73630 117.00 735.0 735.4
Oct 18 2006 99215 163.00 735.0 735.4
Arode, Tammie E 455-44-1111 Jun 30 2003 99203 112.00 724.2 722.10
Jul 23 2003 99212 52.00 724.2
Sep 27 2004 72110 197.00 737.30 722.10 722.52 724.2
Sep 27 2004 99214 104.00 737.30 722.10 722.52 724.2
Jack Fleet
|
|
|
|
|
What is happening exactly? "difficulty importing" doesn't help us much!;P
_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!
|
|
|
|
|
I should have been more specific. What I need is the first line of each record to be associated to the detail lines below it. What I am getting is a straight import with many blank fields and no way to related the details to the person. Here is an example of my desired result from an import.
Aaron, Peter E 222-22-2222 Feb 14 2006 99274 220.00 722.0
Aaron, Peter E 222-22-2222 Feb 14 2006 95903 226.04 722.0
Aaron, Peter E 222-22-2222 Feb 14 2006 95904 185.36 722.0
Aaron, Peter E 222-22-2222 Feb 14 2006 72050 190.00 722.0
Thanks for the reply.
Jack Fleet
|
|
|
|
|
You need to think of some way of distinguishing the patient records from the diagnosis records programatically. Then you could write a routine that would find a patient record, load it, identify any associated diagnosis records and load them as well before moving on to the next patient record.
Paul
|
|
|
|
|
Paul,
Thanks. I wrote a routine that adds a recordid to each line, incrementing only when the next line the inscarrier is not null. Once this was accomplished it was pretty easy a query to separate and rename the fields and another to put is all back together nice and neat.
Thanks again,
Jack Fleet
Jack Fleet
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
