Viewing 15 posts - 16 through 30 (of 34 total)
Sorry, feel free to delete the redundant posts.
June 21, 2013 at 9:05 am
As far as I know, there are no nulls in the Serial Number column. You do bring up a good point though. I took another look at my...
June 21, 2013 at 8:59 am
As far as I know, there are no nulls in the Serial Number column. You do bring up a good point though. I took another look at my...
June 21, 2013 at 8:58 am
As far as I know, there are no null Serial Numbers. However, your reply made me take another look at the query and I should have typed:
Where VehiclesToUpdate.SerialNumber Is...
June 21, 2013 at 8:33 am
There shouldn't be any null records in the serial number column. But you made a good point. The join was wrong. It should have been:
Where VehiclesToUpdate.SerialNumber is...
June 21, 2013 at 7:48 am
I'm trying not to bother you any more but you did ask me to give you a progress update. I am stumped. I have working on this the...
June 20, 2013 at 2:58 pm
I am SO close. I have a question for you. Before I ask it, I will show you the SQL Code and it is now.
with Vehicles as
(
...
June 20, 2013 at 9:16 am
I so appreciate your help and you have already gone way above and beyond the call of duty. I'll try the left joins and guy more experienced in SQL...
June 19, 2013 at 9:43 am
OK, I am set up now with rights on the database which is 2008. I run the following code and get 0 records. Notice the "select COUNT(*)...
June 19, 2013 at 9:18 am
Oh and by the way, this line has to be what replaced the top clause correct?
where v.RowNum <= r.UnitCount
June 18, 2013 at 2:08 pm
I will test it as you specified and get back with you. I will also try adding the "ReturnDate is null" and the SerialNumber to the Order By.
As for...
June 18, 2013 at 2:05 pm
I have some good news and some more good news and then some bad news. First, we found a 2008 database that we can use. Second, the query...
June 18, 2013 at 1:39 pm
I meant to say non-risk on the IMPALAs. Sorry.
June 18, 2013 at 11:45 am
I'm on version 2000 which is probably why I generated these errors when I tried to run your code. The good news is that SQL admin people are trying...
June 18, 2013 at 11:43 am
All I can say is "wow"! You did this without variables, dynamic SQL or a top clause. That is amazing to me. I messed up on the...
June 18, 2013 at 9:48 am
Viewing 15 posts - 16 through 30 (of 34 total)