Showing questions tagged: Show all questions
  • Locked

i have problem whith google keep site

i have one note from google keep site, which work very very slowly, but google chrome no problem... Замена товаров в операциях UPDATE Operations SET GoodID=292 WHERE Good… (read more)

i have one note from google keep site, which work very very slowly, but google chrome no problem...

Замена товаров в операциях UPDATE Operations SET GoodID=292 WHERE GoodID=251

дубли товаров по алкокоду (каталог 2) SELECT * FROM Goods WHERE Catalog2 In (SELECT Catalog2 FROM Goods WHERE Catalog2 <> AND ID > 1 GROUP BY Catalog2 HAVING COUNT(Catalog2) > 1) ORDER BY Catalog2

дубли партнеров по ФСРАР id (карта) SELECT * FROM partners WHERE CardNumber In (SELECT CardNumber FROM Partners WHERE CardNumber <> AND ID > 1 GROUP BY CardNumber HAVING COUNT(CardNumber) > 1) ORDER BY CardNumber

дубли считанных марок (mssql) SELECT * FROM InternalLog WHERE Message In (SELECT Message FROM InternalLog WHERE Message like '%UTM_%' GROUP BY Message HAVING COUNT(Message ) > 1)

дубли считанных марок (access) SELECT * FROM InternalLog WHERE CStr(Message) LIKE '%UTM_%' AND CStr(Message) In (SELECT CStr(Message) FROM InternalLog WHERE CStr(Message) <> GROUP BY CStr(Message) HAVING COUNT(CStr(Message)) > 1)

Замена товаров в операциях UPDATE Operations SET GoodID='ИД товара который нужно оставить' WHERE GoodID='ИД товара который убираем'

выбор только пивной продукции Select * From goods where Ltrim(Rtrim(substring(goods.catalog3, 178, 15))) in (261,262,263,500,510,520)

select * from goodsgroups where code like 'aab%'

SELECT * FROM Goods WHERE Catalog2 In (SELECT Catalog2 FROM Goods WHERE Catalog2 <> AND ID > 1 GROUP BY Catalog2 HAVING COUNT(Catalog2) > 1) ORDER BY Catalog2

SELECT * FROM Goods WHERE IsNumeric(Barcode1)=0 AND Barcode1<> SELECT * FROM Goods WHERE IsNumeric(Code)=0 AND Code<>

update operations set userrealtime = userrealtime -1 WHERE...

update operations set userrealtime = date + convert(nvarchar(8),userrealtime,114) WHERE ...

А что может быть проще? Insert [ИМЯ НОВОЙ БАЗЫ].[dbo].[partners] ([Code],[Company],[Company2],[MOL],[MOL2],[City],[City2],[Address],[Address2],[Phone],[Phone2],[Fax],[eMail],[TaxNo],[Bulstat],[BankName],[BankCode],[BankAcct],[BankVATName],[BankVATCode],[BankVATAcct],[PriceGroup],[Discount],[Type],[IsVeryUsed],[UserID],[GroupID],[UserRealTime],[Deleted],[CardNumber],[Note1],[Note2],[PaymentDays]) (Select [Code],[Company],[Company2],[MOL],[MOL2],[City],[City2],[Address],[Address2],[Phone],[Phone2],[Fax],[eMail],[TaxNo],[Bulstat],[BankName],[BankCode],[BankAcct],[BankVATName],[BankVATCode],[BankVATAcct],[PriceGroup],[Discount],[Type],[IsVeryUsed],[UserID],[GroupID],[UserRealTime],[Deleted],[CardNumber],[Note1],[Note2],[PaymentDays] from [ИМЯ СТАРОЙ БАЗЫ].[dbo].[Partners])

Server1 - 1000-2499.99 => 4% UPDATE p SET Discount = 4 FROM partners AS p INNER JOIN

   (
       SELECT PartnerID, SUM(Qtty*Sign) AS TurnoverSum
       FROM payments
       WHERE [Mode] = 1
       GROUP BY PartnerID
   ) paym
   ON p.ID = paym.PartnerID

WHERE paym.TurnoverSum >= 1000 AND paym.TurnoverSum < 2500

Server2 - 2500+ => 5% UPDATE p SET Discount = 5 FROM partners AS p INNER JOIN

   (
       SELECT PartnerID, SUM(Qtty*Sign) AS TurnoverSum
       FROM payments
       WHERE [Mode] = 1
       GROUP BY PartnerID
   ) paym
   ON p.ID = paym.PartnerID

WHERE paym.TurnoverSum >= 2500


разные цены

Select * from operations o2 where goodid in (select distinct goodid from operations o left join goods g2 on g2.id = o.goodid where o.Priceout <> g2.priceout2) SELECT * FROM partners WHERE TaxNo = AND CardNumber not like '%050000%' AND CardNumber <>


Александр, вот триггер: USE [vd3] GO /***** Object: Trigger [dbo].[PaymentTypesByUsers] Script Date: 08/14/2017 07:36:40 *****/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create Trigger [dbo].[PaymentTypesByUsers] ON [dbo].[Payments] AFTER INSERT

AS

IF (SELECT OperType from inserted) = 2 and (SELECT Type from inserted) = 6 and not (select pg.code from inserted left join partners p on inserted.PartnerID=p.id left join PartnersGroups pg on p.groupid=pg.id) like 'AAA%' begin raiserror 100001 'ЗапрещПродажа_Lesop' ROLLBACK TRANSACTION RETURN end IF (SELECT OperType from inserted) = 2 and (SELECT Type from inserted) in (1,2,3,4,5) and (select pg.code from inserted left join partners p on inserted.PartnerID=p.id left join PartnersGroups pg on p.groupid=pg.id) like 'AAA%' begin raiserror 100001 'ЗапрещПродажа_Lesop' ROLLBACK TRANSACTION RETURN end

триггер в Payments на запрет видов оплаты в зависимости от партнера


DELETE FROM ApplicationLog DELETE FROM CashBook DELETE FROM CurrenciesHistory DELETE FROM Documents DELETE FROM ECRReceipts DELETE FROM InternalLog DELETE FROM Lots where id > 1 DELETE FROM Network DELETE FROM NextAcct DELETE FROM Operations Where OperType NOT IN (20,21) DELETE FROM Payments DELETE FROM Transformations DELETE FROM Store

Эту выполнять после всех. DELETE FROM Goods WHERE ID NOT IN (SELECT DISTINCT GoodID FROM Operations)

UPDATE Partners SET Phone2=Phone WHERE NOT Phone=Phone2 AND ID>1 В шедулер

операции без товара: select goodid from operations where goodid > 0 and goodid not in (select distinct id from goods)

DECLARE @CashbookID as int DECLARE @ObjectID as int DECLARE @Acct as int DECLARE Acct_Cursor CURSOR local FOR SELECT ID FROM cashbook where SUBSTRING([Desc],13,10) IN (SELECT DISTINCT Acct FROM payments where opertype = 2) OPEN Acct_Cursor

FETCH NEXT FROM Acct_Cursor into @CashbookID
WHILE @@FETCH_STATUS = 0 
IF @@FETCH_STATUS = 0 
BEGIN
 SET @Acct = (SELECT SUBSTRING([Desc],13,10) FROM cashbook WHERE ID = @CashbookID)
 SET @ObjectID = (SELECT TOP(1) ObjectID FROM payments WHERE acct = @Acct)
 UPDATE cashbook SET ObjectID = @ObjectID WHERE ID = @CashbookID
 FETCH NEXT FROM Acct_Cursor into @CashbookID;
END
ELSE 
 CLOSE Acct_Cursor
 DEALLOCATE Acct_Cursor

Привет! Подскажите пожалуйста, как поправить таблицу CashBook, поле ObjectID? Нужно привести в соответствии с таблицей Operations или Payments. БД MSSQL 2012



дата из примечания

обновит все строки, где в примечании есть слово ЕГАИС

MSSQL:

update operations set date = cast(convert(datetime, SUBSTRING(Note, 7, 10), 104) as date) where note like 'ЕГАИС%' and opertype = 1

ACCESS:

________________

it isn't all

v.s. -->

Asked by 5978156 2 months ago

  • Solved

Windows10 Won't Boot & Won't Restore - Need To Recover My Mozilla Profile VIA Command Line

After following a support document on editing system registry (the document suggested a full registry export in opposition to the chosen registry key export which does no… (read more)

After following a support document on editing system registry (the document suggested a full registry export in opposition to the chosen registry key export which does no good when in my situation using Windows 'reg import' can not be done using the full registry backup) to restore functionality of my Seagate USB Backup Plus Windows10 will not boot and I fear that I am going to have to start from scratch and so I wanted to ask this question in preparation for the worst possible scenario.

I am chronically reliant upon being able to close Mozilla having faith that it will always restore my last session(s) of all open tabs and their locations successfully EVERY TIME ... now that I may have to start from scratch with my OS, I am desperate to recover my Mozilla profile and I am in great hopes, that recovering the profile will likewise have my last session data to be restored once I get Windows10 running again, because I will really be in a pickle if I lose my open tabs!

So my questions are:

1: Is it possible to recover the profile including the very important "Restore Last Session" where all open tabs of the last session exists?

2: I will be retrieving the files VIA Command Line. I would like to be certain that I am retrieving the correct file(s) from the correct file location(s). Can someone provide the Mozilla profile folder locations and names.


Thanking you in advance for your time and knowledge

Best Regards

Asked by help4u 3 months ago

Answered by jscher2000 3 months ago

  • Solved

Today’s Firefox windows update broke windows 10 connection to the internet.

This has happened to 5 individual computers updated at different times today. As each one updates it goes off line. LAN works fine but Firefox seems to have altered somet… (read more)

This has happened to 5 individual computers updated at different times today. As each one updates it goes off line. LAN works fine but Firefox seems to have altered something in windows 10 OS that kills that individual computers connection to the internet.

Asked by suquamish 3 months ago

Answered by FredMcD 3 months ago

  • Archived

Adobe Flash runs better on MacOS than Windows, why?

So let me give some details, I am running Firefox 71.0 (64-bit) on my Mac and Windows10 PC ... however the Windows OS is running on BootCamp off the Mac. The Mac App of F… (read more)

So let me give some details, I am running Firefox 71.0 (64-bit) on my Mac and Windows10 PC ... however the Windows OS is running on BootCamp off the Mac. The Mac App of Firefox seems to give a much more pleasant experience playing flash games like Alpha Penguin but the Windows Program is extremely laggy. Is there any reason why? Both OSes are using the same hardware to it's max capabilities.

I'd also like to mention that I have an older version of Firefox on my daily solo Windows 8.1 machine and it's lower specked and Flash games like Alpha Penguin play pretty well(there are some lag areas but not as much as my BootCamp situation) but when using a newer version of Firefox on that Win8.1 machine Flash seems to be as equally as bad as the BootCamp Windows10.

Then I have a Windows10 gaming laptop and Flash sometimes struggle there.

All computers have Chrome and play flash equally "okay".

Why am I having such an issue with Firefox, so many different results? Is there something I can do for my BootCamp Windows10's Firefox to play as smooth as Firefox on the MacOS side??

Asked by Windowstv 6 months ago

Last reply by cor-el 6 months ago

  • Solved
  • Archived

Using a Hyperlink to open a newsletter in Firefox browser, Will not open, Times out. same problem w/ different browsers, & different sources. Huh???

Checked Info icon on the link info. shows connection is not secure. I've been opening these hyperlinks for years with no problem/ I am on Firefox release 69.0.3. Talke… (read more)

Checked Info icon on the link info. shows connection is not secure. I've been opening these hyperlinks for years with no problem/ I am on Firefox release 69.0.3. Talked to my ISP support, he was able to open a link in Google!!?? (He blames Thunderbird for the problem). HP support was also unable to resolve the issue.

Asked by David 8 months ago

Answered by jscher2000 8 months ago

  • Archived

Firefox 68.0 totally unresponsive - opens will not load websites, cannot access options menu

After w10 upgrade to build 1903 firefox totally unresponsive. Other browsers work fine as does tbird, Version 67 also did not work. Tried uninstalling and reinstalling an… (read more)

After w10 upgrade to build 1903 firefox totally unresponsive. Other browsers work fine as does tbird, Version 67 also did not work. Tried uninstalling and reinstalling and safe mode and no addons and refresh - nothing is working. please help.

Asked by dvdsom23 12 months ago

Last reply by jscher2000 12 months ago

  • Archived

Can anyone provide a convertor formula for the elemhide css 12 digit dummy that I need to turn into a date and time stamp, it doesn’t seem to work with epoch.

I’m getting on an old file elemhidehit? 414456482821#dummy on each domain line, can anyone assist in a formula to convert the hit number to a date and time please. Many t… (read more)

I’m getting on an old file elemhidehit? 414456482821#dummy on each domain line, can anyone assist in a formula to convert the hit number to a date and time please. Many thanks

Asked by glennisclark 1 year ago

Last reply by cor-el 1 year ago

  • Archived

A virus attached to fire fox login and malwarebyts could not remove it.when i try to reload firefox it is blocked because it trys to reload the same vertion

Malwarebytes quarantined some viruses but could not delete from their site and asked me to try with their instructions: I could not do it so I uninstalled Firefox. When I… (read more)

Malwarebytes quarantined some viruses but could not delete from their site and asked me to try with their instructions: I could not do it so I uninstalled Firefox. When I tried to reinstall Malwarebytes Blocked the install. When I try to install a pop up states we see you had fire fox before we will reload for you. No other options. It fails

Asked by dmpapp 1 year ago

Last reply by FredMcD 1 year ago

  • Archived

Logging in authorization code email

I received an authorization code sent to my email address when I was trying to log into my Firefox thing on my browser ( windows 10 ) I copy pasted the authorization numb… (read more)

I received an authorization code sent to my email address when I was trying to log into my Firefox thing on my browser ( windows 10 ) I copy pasted the authorization number and it did not work, it rejected the authorization number as "wrong authorization info" - I tried again by pressing resend code and i entered the code myself manually one letter/digit at a time ensuring capital letters were capital and making sure it matched exactly what I received in the email as my auth code, it rejected it again and said it was incorrect

i’ve tried this three different times now and every time the auth code is sent to my email immediately but it is rejected when I enter it on the browser after logging in

when I put in my email address/password it allows it and then goes to the authorization page where it asks me to get the authorization code sent to my email and enter it there when I hit send I get the email and as soon as I receive the email I enter the authorization code and it is not accepted I do not understand for the life of me how I am getting a message telling me the authorization code is incorrect when I am 110% positive is accurate

there is no way what Im entering is inaccurate, I even tried copy pasting, and making sure there were no extra spaces before and after the auth code before I pasted it into the webpage please help

Asked by Sam3gs 1 year ago

Last reply by christ1 1 year ago

  • Solved
  • Archived

Trying to re-install Firefox - get message that Profile cannot be loaded - install will not complete

I had a power cut whilst loading firefox. Tried to load when power restored, but get the message about the Profile missing or inaccessible. Thought that deleting the co… (read more)

I had a power cut whilst loading firefox. Tried to load when power restored, but get the message about the Profile missing or inaccessible. Thought that deleting the copy on C drive and loading a fresh copy of Firefox would solve the problem, so deleted it - didn't help - same message when I try to load a new copy. How can I install a totally new copy of the program ? I have another copy of Firefox on a laptop - can the profile from this help ?

Asked by 65patriot 1 year ago

Answered by FredMcD 1 year ago

  • Archived

The instructions for adding folders to bookmarks is not correct. I can't find the "Show all Bookmarks" at the bottom of the list. Where is that item?

In the old Outlook Express, I could set up folders to sort bookmarks. The instructions in support do not appear to be correct. How do I add folders to the Bookmarks and… (read more)

In the old Outlook Express, I could set up folders to sort bookmarks. The instructions in support do not appear to be correct. How do I add folders to the Bookmarks and then move bookmarks into the folders so that I can more easily find the one I am looking for? The bookmarks are not even sorted alphabetically, which would be helpful if folders cannot be set up. Again, in the old Outlook Express, I could move bookmarks in the list so that I could alphabetize them, even within folders. Can someone please let me know how to do this in Thunderbird?

Asked by Stujake 2 years ago

Last reply by Matt 2 years ago

  • Archived

does latest version of firefox support microsoft silverlight

i am using windows 10 latest firefox version doesn't support silverlight (as mozilla stopped in their latest version) is there any plugin available for running silver… (read more)

i am using windows 10 latest firefox version doesn't support silverlight (as mozilla stopped in their latest version) is there any plugin available for running silverlight on firefox?

expecting valuable reply from MOZILLA TEAM.

thanks & regards v/shanmugam, trichy

Asked by shan45262 2 years ago

Last reply by James 2 years ago

  • Archived

Firefox is refusing to connect to DVLA vehicle tax, claims site insecure, why?

Suddenly I cannot log into the yougov site for DVLA vehicle taxing (www.gov.uk/vehicle-tax). I am getting your insecure site message on this - seems unlikely for a gover… (read more)

Suddenly I cannot log into the yougov site for DVLA vehicle taxing (www.gov.uk/vehicle-tax). I am getting your insecure site message on this - seems unlikely for a government site. No other browsing has come up with this so far, what is wrong?

Asked by bhallatt 2 years ago

Last reply by Kobratuko 2 years ago

  • Archived

Firefox virus

Hi my computer does not have fire fox installed but evertime I start the computer up firefox pops up and starts going to different url's anytime I click on it it closes. … (read more)

Hi my computer does not have fire fox installed but evertime I start the computer up firefox pops up and starts going to different url's anytime I click on it it closes. Any help would be appreciated

Asked by Bmomo91 2 years ago

Last reply by WestEnd 2 years ago

  • Archived

Firefox crashes

Crashing on a regular basis. Particularly in FB. Tried safe mode. Crashed right away. https://screenshots.firefox.com/OQXzkEu1qKJ6Qp74/crash-stats.mozilla.com This has b… (read more)

Crashing on a regular basis. Particularly in FB. Tried safe mode. Crashed right away.

https://screenshots.firefox.com/OQXzkEu1qKJ6Qp74/crash-stats.mozilla.com

This has been going on for at least a month and it is getting a little under my skin at this point

Please help

Asked by Patty58 2 years ago

Last reply by FredMcD 2 years ago

  • Solved
  • Archived

Firefox crashes

Crash ID: bp-1d7e3c12-901d-4529-9950-1e1991171229 Crash ID: bp-240d534c-9600-4050-8309-5ab831171229 Crash ID: bp-0bae0284-41fd-4fc9-815c-7fce61171229 it keep crashing eve… (read more)

Crash ID: bp-1d7e3c12-901d-4529-9950-1e1991171229

Crash ID: bp-240d534c-9600-4050-8309-5ab831171229

Crash ID: bp-0bae0284-41fd-4fc9-815c-7fce61171229

it keep crashing even at start just after the page open it close fast

i dont have any problematic software this is a fresh win 10 (i do have IDM extension but i had it before without any problem) i did restart, reinstall and even deleted the folders none worked

Asked by mohammad65 2 years ago

Answered by cor-el 2 years ago