Search results for query: *

Yeah, I know. Problem is the front end doesn't allow formatting like it should, so I'm stuck with SQL. For anybody coming along who is interested doing something like this, this really nasty query seems to work. select BookType, min(book) as BegBook, max(book) as EndBook from ( select...

This seems like it should be simple, but I can't come up with a simple solution. I want to turn this Book Type |Book Deed Record 1 Deed Record 2 Deed Record 3 Deed Record 5 Mortgage Record 1 Into Book Type |Book Deed Record 1 - 3 Deed Record 5 Mortgage Record 1 Any ideas?

Got a paren in the wrong place I think. RETURN 'C' + right('0000' + CONVERT(varchar(10), @id)) Should be RETURN 'C' + right('0000' + CONVERT(varchar(10), @id),4) Is that right?

I'm really really young in the workforce. So what I'm saying is probably worthless, but I ran into a situation where I stepped back and evaluated the leadership in my company, and tried to figure out why I didn't like it. I came to the conclusion that it boils down the priorities of a manager...

I'm totally new to foxpro...been playing with it over the weekend. I got an image control on my form, and I'm wondering how to zoom, pan, rotate, ect. Are these functions in the image control somewhere, & I'm just missing them...or is there a better image control out there I should be using?

Uh...no. Preferably in a way that nobody will know I did anything. Afraid a hammer would be a bit obvious. Maybe I should hook it up to 240 volts, I wonder if that'd do it?

Another dev turned in an external HD as bad. He tried copying data to it, & when he hit 100GB it gave him errors and refused to write any more data to the HD. I suspect it is going out, and don't think it's a good idea to use it. If it goes out, it's going to cost us at LEAST $80, which is...

Our company works with lots of images. We have about 3-5TB of images on our production server at any one time. When we are finished with the images, we back them up to DVD's and delete them off the server. A while back, our HW dept was re-building the array, and we were supposed to be able to...

Is there some type of tool out there I can use to read the master file table? Also, is there any possible way to retrieve old versions of the MFT...does the system restore point store the file? Would it store the file for just the OS drive, or all drives?

I don't think that's going to work...the result has to be based on the priority, the man hours it's going to take, and who else might be working on it... IE Build a doghouse 24 John 1 Should be 3 days, not one... Build a doghouse 20 John 1 Feed the Dog...

Um...I don't understand what you're wanting? Do you have to columns, 2007 & 2008, and you want to combine both columns? select [2007]+[2008] from mytable Are you wanting to update your table with a third column that combines the two columns? ALTER TABLE mytable ADD [20072008] VARCHAR(104)...

I'm working on a mini-scheduler, and I'm not sure how to do what I want to do with SQL. I think it'll be easiest to show the data I've got and what I want... Task ManHours Person Pri Clean up the room 16 Bob 2 Clean up the room 16 Lucy...

If I have these three tables, how can I quickly get a list of missing pages, pages that are in the testbook table, but not in the Pages table, and that are less than the maxpage for that book? Pages -------------------------- Book Page 000001 0001 000001 0003 000002 0001 000002 0005...

OMG! Thanks a million SQLDennis...*beats head against desk*

I've got a sql question. If I have a table that has two columns, book and page, what is the best way to get a count of all the missing pages for each book? So, if I have this table... Book Page 0001 0001 0001 0002 0001 0005 0001 0006 0002 0001 0002 0005 0002 0006 0002 0009...

I'm using a program that plugs into existing sql tables, and needs some header columns, and so I can't just modify my queries...

Well, that's kinda a pain. Oh well, thank you, that's what I'll do!

How can I use sql to insert columns into a table, and control the order at which they go in the table? I want to insert columns at the beginning of a table, and by default, sql puts them at the end of the table...

I am attempting to figure out if images I have stored in a SQL table are .tif or .jpg. Looking at the data, it is easy to tell that all of the .jpg images begin with a certain pattern (0xFFD8FF). Is there any way I can cast the image as another data type, and compare it? I've tried this...

Sweet! Thanks!