Right I've had a look at the code you've written Frank and it all makes sense. The problem is I want to take data from a database that I can only...
Thanks Frank, I shall have a go with this. Unfortunately the database I am not allowed to touch/modify/look at was badly designed with varchar...
quote:Originally posted by FrankKalis Could you post your table structure along with some non-confidental sample data? I think we're getting closer...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
quote:Originally posted by FrankKalis May I jump right in? Am I right, that you want this to find out all events that have CallLog.CallStatus...
The join was done drag and drop from query analyzer (I am a serious newb to SQL). So you suggest I change CROSS to INNER? Is this what you...
tdong I have executed both of the above statements and for some strange reason they are returning ALL rows in the database, even where...
Ah yes, I see! Thanks for that. So how do I go about setting GETDATE to return the correct date/format?
Running this code: SELECT heat.CallLog.CallID, heat.CallLog.RecvdDate, heat.CallLog.CallSummary, heat.Profile.EMailID, GETDATE(), ClosedDate FROM...
That shorter statement would be much better! However both statements return incorrect results I.E: the short stament returned this row in its...
Thats what I want to do but with what ever the current date is on the system so that i can get it to automatically pull data out every day. Can you...
tdong It has all been tested, the date clauses are the latest addition. I would like the statement to compare the dateparts of the current date to...
Not really, it is pulling out all of the data in the database and changing all of the call date fields to the current date.<br /><br />E.G: <br /><br...
quote:Originally posted by Fndr70 this part SELECT (convert(DATETIME,ClosedDate)) FROM heat.CallLog))) = @month (and the subsequent parts for day...
Hi all, I'm new to this whole SQL lark and struggling a fari bit. I wonder if anyone can help me. I want to populate a VB.Net Datagrid with data...
Separate names with a comma.
