Search results for query: *

fair enough. I appreciate the help either way. "Adults are just obsolete children and the hell with them." - Dr. Seuss

We recently found some files on my companies network that need to be accessed, but they are password protected. They are windows 2000, but the employee no longer works here to give us the password. Without buying software does anyone know how to use a hex-editor to find the password? I...

What is happening is that in the newly created [level] field, it is just changing the actual level from 2, 3, 4 to 1. SO it is pulling them all, but it is actually pulling the wrong data. I tried SELECT TOP 100 PERCENT dbo.SubSection.[Level], dbo.Section.sectionID...

SELECT TOP 100 PERCENT dbo.Section.sectionID, dbo.SubSection.SubSectionID, dbo.Qustn.QustnOrder, dbo.Qustn.QustnText, dbo.Qustn.QustnType, dbo.Section.sectionDesc, dbo.SubSection.SubSectionText, dbo.TargetSection.targetId, case when dbo.subsection.sectionid in(...

except it is not an update statement, simply a select "Adults are just obsolete children and the hell with them." - Dr. Seuss

SELECT TOP 100 PERCENT dbo.Section.sectionID, dbo.SubSection.SubSectionID, dbo.Qustn.QustnOrder, dbo.Qustn.QustnText, dbo.Qustn.QustnType, dbo.Section.sectionDesc, dbo.SubSection.SubSectionText, dbo.TargetSection.targetId, dbo.SubSection.Level, CASE when...

how do I fix the above case? "Adults are just obsolete children and the hell with them." - Dr. Seuss

Update Customer Set x = Left(Contact_Point, CharIndex(',', Contact_Point) - 1), y = LTrim(Right(Contact_Point, Len(Contact_Point)) - CharIndex(',', Contact_Point)) oops, two small mistakes, had a mistake after the comma in quotes, and the go is not needed. If I read it right, the...

Update Customer Set x = Left(Contact_Point, CharIndex(', ', Contact_Point) - 1), y = LTrim(Right(Contact_Point, Len(Contact_Point)) - CharIndex(', ', Contact_Point)) GO "Adults are just obsolete children and the hell with them." - Dr. Seuss

I know about cases, I tried SELECT TOP 100 PERCENT dbo.Section.sectionID, dbo.SubSection.SubSectionID, dbo.Qustn.QustnOrder, dbo.Qustn.QustnText, dbo.Qustn.QustnType, dbo.Section.sectionDesc, dbo.SubSection.SubSectionText, dbo.TargetSection.targetId CASE 'cc' when...

I have a query pSELECT TOP 100 PERCENT dbo.Section.sectionID, dbo.SubSection.SubSectionID, dbo.Qustn.QustnOrder, dbo.Qustn.QustnText, dbo.Qustn.QustnType, dbo.Section.sectionDesc, dbo.SubSection.SubSectionText, dbo.TargetSection.targetId FROM dbo.SubSection INNER JOIN...

I was just reading and thinking the same thing. "Adults are just obsolete children and the hell with them." - Dr. Seuss

Thanks guys! "Adults are just obsolete children and the hell with them." - Dr. Seuss

Ok, I want to run a query that pulls the 'userpwrd' from the 'users' and the 'users_bak' table where em_id is the same in both. So I see what the PW is in both tables, then update the 'users' table with the value of the 'userpwrd' in the 'users_bak'. I have tried a few queries for the select...

A user of mine is getting that error on files, some that are 13mb, others that are 33mb. She has 2gb of RAM with virtual memory set at 4096 so AutoCAD 2005 works. Any ideas? "Adults are just obsolete children and the hell with them." - Dr. Seuss

you know, I had tried that on a backup of the table and it did not work. I backedup the db and ran it, worked fine. Thanks "Adults are just obsolete children and the hell with them." - Dr. Seuss

you can buy software for like $9 [link = http://www.amleth.com/dbhelper/]http://www.amleth.com/dbhelper/[/url] "Adults are just obsolete children and the hell with them." - Dr. Seuss

to be specific for the update statement, I just need to delete the 1 character. Is there an easy way to do this? Maybe a delete statement or something? "Adults are just obsolete children and the hell with them." - Dr. Seuss

in databases there is a lot of "white space", or empty space. If you look at a char field, select the data and look at how much extra spaces there are. Those spaces take up just as much space as any letter or number. Take a 500mb .MDF file, zip it and watch it become like 250kb or 1mb...

You can try to attach the files and shrink it from there "Adults are just obsolete children and the hell with them." - Dr. Seuss