Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. despierto

    Need Sharp AR-168D ip address

    I inherited an old sharp AR-168D MFP in our lab, and I need to set it up for network printing. Unfortunately I can't seem to find any information in the manuals as to tell how the IP address is configured. They all say "Go to a browser and type in the IP Address..." Great. What IS the IP...
  2. despierto

    public folder vs shared email for website contact

    We just recently set up a new website, and there is the ability for users to send an email about issues they are having with the website. More than one employee will review and respond to these emails, but only one employee should respond to any single email. The question I have (and I should...
  3. despierto

    sbs fax server hiccups

    I have an SBS with the fax configured. We have two fax lines, #1 being the primary, #2 being the secondary rollover line. The faxes are routed to a printer on the network, and we don't copy or email the faxes anywhere. Every once in a while, the fax service hiccups and doesn't print a fax...
  4. despierto

    Removing former employees from Global Address list

    Thanks to both! The GAL Hider will come in handy when I get to the point of scripting my new and removed users, but in the meantime, that checkbox was exactly what I was looking for, but just couldn't find.
  5. despierto

    Removing former employees from Global Address list

    We have several former employees of my company, and currently the policy has been to keep their login account on the system, but change the password and disable the login. The problem with this is that the terminated employee shows up in the GAL when you are using outlook. I tried making a...
  6. despierto

    Multiple group policies for different departments

    Hello, I was wondering if anyone knows how/if I can set up a different group policy for different departments. For example, I have a data entry department where the manager does not want them to be able to do anything except data entry... So no internet, no email, no hope for a better...
  7. despierto

    Keep old (ex-employee) user login

    Can anyone think of any reason (besides oversight) why a company might keep logins for former employees on a database? I'm wondering if, say JimJones is the owner of sp_Acme, and you remove JimJones, what happens to sp_Acme? Any other scenarios, generally vague is fine, that you can think of...
  8. despierto

    WAITFOR DELAY in query analyzer

    No, I have it in text mode.... Unfortunately, it still waits until it's done with the loop. Seperate linear selects will show up as the script executes. Strange, I know...
  9. despierto

    WAITFOR DELAY in query analyzer

    Hiya. I am working on a script to be run in query analyzer in which I want to test for a specific instance every x seconds. When I get one of the results I want, (Status is successful, failed, totally failed), I want to kick out of my loop. BUT - I want to see that it is still doing something...
  10. despierto

    if statements in queries?

    Use SQL Query Analyzer to write and test your query, then use the "create view" SQL to create the view.
  11. despierto

    SET for a local var

    ...INTO @NewKey SET @KeyFetchStatus = @@FETCH_STATUS END DEALLOCATE Fields_Cursor DEALLOCATE NewKey_Cursor SET NOCOUNT OFF select * from @TableVariable And the UNION query, followed by the MIN query. SELECT pk, 'EL1A' as FieldName, EL1A AS dtDate into #temp FROM Table2 UNION SELECT...
  12. despierto

    Index counter

    Look into identity fields, with INCREMENT(1,1). Same thing as autonumber.
  13. despierto

    SET for a local var

    ...= @@FETCH_STATUS WHILE @FieldFetchStatus = 0 BEGIN IF (COLUMNS_UPDATED() & POWER(2, @ColumnID-1) = POWER(2, @ColumnID-1)) BEGIN SELECT * INTO ##ins FROM inserted WHERE JobCode = @NewKey SELECT * INTO ##del FROM deleted WHERE JobCode = @OldKey SET @Param = N'@Val nvarchar(250)...
  14. despierto

    SET for a local var

    This is a solution, an ugly one, but a solution nonetheless. select Earliest = CASE when EL1A < EL2A AND EL1A < EL3A THEN EL1A when EL2A < EL1A AND EL2A < EL3A THEN EL2A when EL3A < EL1A AND EL3A < EL2A THEN EL3A END FROM table Your best bet would probably be to normalize the table...
  15. despierto

    Storing Image Filenames and Paths

    That approach sounds fine to me... There are other ways you can accomplish it, such as using an Image or binary field type, and storing a copy of the image inside the database, but then you have to take into account displaying the image in a web page gets a lot trickier than <img src=" &...
  16. despierto

    where null &lt;&gt; 'string' not retrieving, why?

    Never imagined this would go this far, but here we go: pk Field1 Field2 1 1 <null> 2 <null> 1 3 <null> <null> 4 1 1 SELECT pk FROM Table1 WHERE (Field1=Field2) returns: 4 SELECT pk FROM Table1 WHERE NOT (Field1=Field2) returns: no records as thedrider said, null...
  17. despierto

    Use SQL to generate a message box?

    Are you looking for PL/SQL answers in oracle? SQL Server doesn't use ';'... Try an Oracle forum if that's the case.
  18. despierto

    Update Field

    That depends... Which method do you want to use above? Are you putting the data into the same table? Is the data in FieldXYZ the source and destination? Or is the destination field different? A quick example update statement would be: UPDATE table SET field=(functions described above)
  19. despierto

    Need SQL to derive DATETIME as 1st Day of Last Month

    Whoops. Missed the part about <i>last month</i>. Even though SQLBill already got it, I modified mine to work the way you want: CAST(CAST((CASE MONTH('Aug 12 2004') WHEN 1 THEN 12 ELSE MONTH('AUG 12 2004')-1 END) AS VARCHAR(2)) + '/01/' + CAST((CASE MONTH('Aug 12 2004') WHEN 1 THEN YEAR('Aug 12...
  20. despierto

    Need SQL to derive DATETIME as 1st Day of Last Month

    CAST(CAST(MONTH('Aug 12 2004') as varchar(2)) + '/01/' + CAST(YEAR('Aug 12 2004') AS varchar(4)) as datetime)

Part and Inventory Search

Back
Top