Recent content by lsmyth1717

Hi I have a spreadsheet containing addresses. Some of the addresses are in the format "123 Main Street", while others are "123, Main Street" and some may be "Apt 1, 123 Main Street". I am trying to separate the number part of the address from the rest of the street name so that I am able to...

I changed my query as follows and got the following error: - Server: Msg 156, Level 15, State 1, Line 17 Incorrect syntax near the keyword 'select'. Server: Msg 170, Level 15, State 1, Line 17 Line 17: Incorrect syntax near ')'. Any ideas. Also is it possible to do the if not exists based on...

Thats great cheers. Wondered if you could show me one more thing. How do I change it slightly so as if a row with the same details already exists in FavouriteSportMain then don't insert it. Basically what I mean is if someone runs the cursor query a second time which inserts another 3 rows...

I have been asked to produce an example of a cursor and then to point out why it isn't required to use on. I am having difficulty creating my example and I was wondering if someone could help me with the syntax to write one. Basically I want to select the FavouriteSport table (below) into a...

Yeah that work ok for part of the problem, however there are so many variables in place which I need to work through before I decide whether to insert or update a record that i've been told a cursor is better to use. Your code worked but when it came to things like if a row in the merge table...

I have a query about writing code to use a sql server to loop through a record set in one table and then depending on the record insert a row into a new table. Each night I will receive a merge table file with new values in it. Depending on these values I will want to insert a record across to...

Not sure exactly what you meant by add an alias (a) to the MyTable after you plug the code in. So far I have the following can you show me what you mean. Cheers INSERT INTO MOVE (MOVEFROMURN, MOVETOURN, MOVEDATEMERGED, RecNo) SELECT MergeFromURN, MergeToURN, MIN(MergeDateMerged), Min(RecNo)...

I am trying to write some sql without using a cursor which looks at a row in a table and if the value exists in a row with a previous record no then i don't want to insert the record. In the example below I would like to put another where clause into my insert statement which doesn't allow...

I want to ask everyone about this to see if anyone knows a work-around. My environment is win2003, vs.net 2003, Java 2 runtime environment SE 1.4.2_08 (or jvm1.4 for short). I have a java applet that I want to include in an asp.net page. I can open it in IE6 in a html page and it runs happily...

Yeah basically thats what i'd like to do. Can you help

I've got a real brain teaser which I'm trying to work out. Basically I recieve a merge table in every night which supplies a list of urns which have been merged into other urns. I'm using a .net application to search on urns and return results but when a user input a urn my stored procedures...

Unfortunately it isn't up to me - its my manager who likes the pretty pictures. Having Saturdays and Sundays as working days may work in this case - I'll give it a go. Cheers..

Does anyone know if there is a way to hide non-working days (e.g. Saturday, Sunday and overnight) in a Gantt chart? I am trying to compare how long different tasks will take in terms of working hours, not actual time, and the non-working hours make some tasks look as if they are taking much...

Ok, but i've used this before and got this working fine so still can't understand it. My function that returns the date seems fine to me and should return a valid date and has done in the past. Any ideas what i've done wrong?

Can someone help me. I'm trying to use the following validator control and compare a date to a date defined in the code-behind page. My code is below along with my error message I get when the page is rendering in the browser. Has anyone any idea what I've done wrong? <asp:CompareValidator...