Recent content by MichaelF81

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