• Locked

www.epfo.india.gov.in

Pdf file&picture post problem duplicate. continue at https://support.mozilla.org/en-US/questions/1290304 … (மேலும் படிக்க)

Pdf file&picture post problem

duplicate. continue at https://support.mozilla.org/en-US/questions/1290304

Asked by SHAILA SONAWANe 1 மாதத்திற்கு முன்பு

Last reply by SHAILA SONAWANe 1 மாதத்திற்கு முன்பு

  • தீர்வுற்றது
  • Locked

Firefox log out me of my Google account

Hello, When I open Firefox browser, I am logged out of my Google account, when I connect to this one, I close Firefox browser and I reopen Firefox, I am logged out. So I… (மேலும் படிக்க)

Hello, When I open Firefox browser, I am logged out of my Google account, when I connect to this one, I close Firefox browser and I reopen Firefox, I am logged out. So I would like to know how stay connected to my Google account even after closing and reopenning Firefox browser. I got this problem from I changed my computer, it's maybe a setting that I don't change. I hope you can help me. Thanks.

Asked by kylian.chapon 5 மாதங்களுக்கு முன்பு

Answered by Wesley Branton 5 மாதங்களுக்கு முன்பு

  • 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… (மேலும் படிக்க)

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 மாதங்களுக்கு முன்பு

  • Locked

How can I attach my Swimming pool website to Mozila Fire Fox?

Hi, community, I want to attach my swimming website with Mozilla Firefox. It means I only want to open my website in Mozilla, not any other browser. Please guide me How c… (மேலும் படிக்க)

Hi, community, I want to attach my swimming website with Mozilla Firefox. It means I only want to open my website in Mozilla, not any other browser. Please guide me How can I do that.

Hi, pals right here will proportion some essential things about your Personal computer. How you can make your Computer PC more cozy, secure and useful from different computers. https://support.mozilla.org/en-US/products/firefox/sync-and-save

Use FIREFOX Instead of Internet Explorer for internet surfing: Many net surfers have now shifted to FIREFOX as their first preference for internet browsing due to its many blessings over the internet explorer.

Security: FIREFOX offers greater security for your laptop. There are [website] that install secret agent ware and lots of other mall ware. Other browsers don't have the electricity to stop that. It will be secure to your computer to use Firefox instead of any other browsers for surfing any website even it's miles porn.

Popup Blocking: You have noticed some times when you open browsers some different small home windows open routinely. This is known as Popup. These windows may have suitable as well as terrible things that can affect your computer systems. Some times those Popup home windows additionally show porn hyperlinks additionally that may be a trouble in case of your kid's.

Advanced Quality and Features: FIREFOX has many enhance functions and features that don't have in other browsers like many taps in on the window. It saves some time from commencing and closing separate home windows. It saves pc memory from being west.

Clean and simple: FIREFOX is smooth and simple to use. Its view is so cleaned and person finely. You will get experience running on Firefox. You will a new browsing experience at the same time as running on FIREFOX.

Thanks

Asked by Smith Roger 3 மாதங்களுக்கு முன்பு

Last reply by jscher2000 3 மாதங்களுக்கு முன்பு

  • Locked
  • Archived

Can't log in another Google account on Firefox

Hello, Recently, I can't log in to another Google account on my Firefox browser. On google.com site, when trying to log in on another account by Account button at top rig… (மேலும் படிக்க)

Hello,

Recently, I can't log in to another Google account on my Firefox browser. On google.com site, when trying to log in on another account by Account button at top right corner, it doesn't effect when clicking even though bottom left corner show detail link. It happens with Apps button next to Account button as well. I'm using Firefox version 70.0.1 (64-bit). It make annoying on me quite much cause I often work on more than one Google account.

I has IDM Integration Module, uBlock Origin and Ace Script add on. I realize IDM and uBlock add on but I don't know what is Ace Script. I tried to remove it but it can't (only disable it). I also tried to disable uBlock Origin but problem can't be fixed.

Asked by Nguyễn Văn Nghị 7 மாதங்களுக்கு முன்பு

Last reply by Nguyễn Văn Nghị 7 மாதங்களுக்கு முன்பு

  • தீர்வுற்றது
  • Locked
  • Archived

malware

http://search.tapufind.com/?st=hp&q=

HOW can eliminate this initial page that appear always ??

Asked by Tana 10 மாதங்களுக்கு முன்பு

Answered by McCoy 10 மாதங்களுக்கு முன்பு

  • தீர்வுற்றது
  • Locked
  • Archived

Why some sites works ONLY at "private window" mode

Why at some sites I CAN'T LOG IN at normal mode and need ONLY PRIVATE WINDOW MODE so i can log in and use the site normally. Sites like this "http://my.xe.gr" … (மேலும் படிக்க)

Why at some sites I CAN'T LOG IN at normal mode and need ONLY PRIVATE WINDOW MODE so i can log in and use the site normally. Sites like this "http://my.xe.gr"

Asked by grecory13 11 மாதங்களுக்கு முன்பு

Answered by cor-el 11 மாதங்களுக்கு முன்பு

  • Locked
  • Archived

How to stop white website infomation boxes

How do you stop these white boxes that give a description of the website from showing up on websites ?

Asked by cozman 10 மாதங்களுக்கு முன்பு

Last reply by McCoy 10 மாதங்களுக்கு முன்பு

  • தீர்வுற்றது
  • Locked
  • Archived

Firefox 66 still auto-plays videos

I'm on Linux, and updated to Firefox 66 yesterday. I was looking forward to the new feature that disallows websites auto-playing videos. But I found that it's not the cas… (மேலும் படிக்க)

I'm on Linux, and updated to Firefox 66 yesterday. I was looking forward to the new feature that disallows websites auto-playing videos. But I found that it's not the case. For example, https://www.bloomberg.com/news/articles/2019-03-19/how-an-extra-man-in-cockpit-saved-a-737-max-that-later-crashed still starts playing the video automatically. This is just one of the many I've tried so far.

Am I missing any settings? There was none I could find having done a quick search on the preference page.

Asked by Jeenu 1 வருடத்திற்கு முன்பு

Answered by cor-el 1 வருடத்திற்கு முன்பு