Search results for query: *

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...

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...

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...

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.

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...

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...

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...

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...

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...

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

...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...

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

...= @@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)...

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...

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=" &...

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...

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

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)

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...

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