Viewing 15 posts - 19,636 through 19,650 (of 26,490 total)
Why are you explicitly calling that particular column? Also, you really should explicitly define the columns you want returned even if you want all of them returned.
July 22, 2009 at 12:26 pm
Tried something similiar in a Sandbox database. Under compatibility mode 80, query would work. Under compatibility mode 90, I got the error you did.
Something is different, you just...
July 22, 2009 at 12:20 pm
What versions of SQL Server? What compatibility mode on the databases?
July 22, 2009 at 12:15 pm
I see the problem:
select INSPTYPE,* -- right here. You are specifying INSPTYPE explicitly and it is also included in the *, so it is here twice.
from APINSP
where insptype...
July 22, 2009 at 12:13 pm
What are the table definitions between the two environments? Also, are there any differences between how the two systems are set up? Different collations, something?
July 22, 2009 at 12:06 pm
Two things. First, what have you written so far to solve this problem. Second, based on the data in your original post, what whould be the expected output.
A...
July 22, 2009 at 12:02 pm
Looks like you should be able to accomplish this task. Right click on the server in the Object Explorer, go to the Advanced Page. You should be able...
July 22, 2009 at 11:37 am
fizzleme (7/22/2009)
Pardon my lack of knowledge. Is it possible to backup a 64 bit 2005 database and restore it on 32 bit sql2005?
Now this is doable. We do...
July 22, 2009 at 11:33 am
. (7/22/2009)
If you're going to tell them they're not posting right then it would be a good idea if you could give them the link to the information about the...
July 22, 2009 at 11:07 am
No, and No. The x64 version needs the x64 verions of the OS, which requires that it be installed on x64 hardware.
July 22, 2009 at 11:05 am
?? Okay, did you have a problem you wanted help with, or did you just want to know what type of lock the code represented?
July 22, 2009 at 10:25 am
I'd like to see the solution also. I'd also like the OP to post the code he has tried writing to solve his problem as well, though, before you...
July 22, 2009 at 10:20 am
peter.nguyen (7/22/2009)
Attachments for more sample data. ignore the first sample data I sent earlier.
Here is a pic of the output that is required:

Thanks again so much for wanting to help...
July 22, 2009 at 9:27 am
Your data still doesn't match your ariginal picture. Is there a query that is run against this data that produces the data as seen in your original post?
Nevermind, STILL...
July 22, 2009 at 9:09 am
Viewing 15 posts - 19,636 through 19,650 (of 26,490 total)