Fragen mit folgendem Schlagwort anzeigen: Alle Fragen anzeigen
  • Gesperrt

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… (Lesen Sie mehr)

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

Gefragt von 5978156 vor 1 Monat

  • Gelöst

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… (Lesen Sie mehr)

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

Gefragt von help4u vor 2 Monaten

Beantwortet von jscher2000 vor 2 Monaten

  • Gelöst

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… (Lesen Sie mehr)

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.

Gefragt von suquamish vor 2 Monaten

Beantwortet von FredMcD vor 2 Monaten

  • Gelöst
  • Archiviert

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… (Lesen Sie mehr)

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.

Gefragt von David vor 7 Monaten

Beantwortet von jscher2000 vor 7 Monaten

  • Gelöst
  • Archiviert

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… (Lesen Sie mehr)

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 ?

Gefragt von 65patriot vor 1 Jahr

Beantwortet von FredMcD vor 1 Jahr

  • Gelöst
  • Archiviert

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… (Lesen Sie mehr)

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

Gefragt von mohammad65 vor 2 Jahren

Beantwortet von cor-el vor 2 Jahren

  • Gelöst
  • Archiviert

Fire Fox does not appear when I click the FF shortcut on my desktop.

This morning when as soon as my FF browser came up my computer screen froze. Had to manually shut doe the computer via the off button. When I restarted the computer I cou… (Lesen Sie mehr)

This morning when as soon as my FF browser came up my computer screen froze. Had to manually shut doe the computer via the off button. When I restarted the computer I could never get my FF browser to come up after clicking the shortcut icon on my screen.

Gefragt von Douala vor 2 Jahren

Beantwortet von FredMcD vor 2 Jahren

  • Gelöst
  • Archiviert

Which process should I end to kill Firefox 57.0?

Occasionally, any piece of complex software will stop responding, and need to be forcibly shut down. I had such an event today when the right-click (context) menus and t… (Lesen Sie mehr)

Occasionally, any piece of complex software will stop responding, and need to be forcibly shut down. I had such an event today when the right-click (context) menus and title-bar menus wouldn't appear. However, since upgrading to FF 57, I now see about 6 Firefox tasks and 6 firefox.exe processes in the Task Manager (Windows 10).

I like the feature of being able to restart Firefox (after killing it) and have my previous session restored, but the processes aren't really distinguishable in Task Manager, so I don't know which one to end/kill. I had to kill a few of them today before I stumbled upon the "main" process and Firefox disappeared. Can you help me to identify the main process for next time?

Gefragt von azinyk vor 2 Jahren

Beantwortet von azinyk vor 2 Jahren

  • Gelöst
  • Archiviert

V5.7 is running painfully slow. Can't fix it. How do I download V5.6?

Firefox automatically upgraded to 5.7. It was running fine before that. Now it's very slow. Hangs up during scrolling, then will continue after about 6 Secs. Hovering th… (Lesen Sie mehr)

Firefox automatically upgraded to 5.7. It was running fine before that. Now it's very slow. Hangs up during scrolling, then will continue after about 6 Secs. Hovering the mouse over a command takes about 6 Sec to recognize the cursor is there. Please tell me how to revert back to 5.6

Bill Newland

Gefragt von BillNewl vor 2 Jahren

Beantwortet von philipp vor 2 Jahren

  • Gelöst
  • Archiviert

Why has Firefox slowed to the point of unusable?

Firefox slowed to the point where it is unusable. It also stalls, and even crashes. Other browsers work find, and my internet connection speeds are as good as I can exp… (Lesen Sie mehr)

Firefox slowed to the point where it is unusable. It also stalls, and even crashes. Other browsers work find, and my internet connection speeds are as good as I can expect.

I have uninstalled and reinstalled to no avail.

My machine is Intel QuadCore i5-3470 CPU @ 3.20GHz, 32 GB RAM, running MS Windows 10 Home on an MSI B75MA-P45 motherboard. It was assembled by Net Solution Computers of Morley, Western Australia, and has a SAMSUNG U28D590D VDU driven by an NVIDIA QUADRO K620 Video Card and RealTek High Definition Audio. I have Windows Defender and Malwarebytes as Anti-virus with Firefox and Skype running in the background.

Gefragt von Vagulus vor 2 Jahren

Beantwortet von FredMcD vor 2 Jahren

  • Gelöst
  • Archiviert

Firefox freezes if I have more than 4 or 5 tabs open

For the past few months (it's October 2017) after starting the browser I can open 3 tabs tops before the browser slows down incredibly, things load slower, videos stop an… (Lesen Sie mehr)

For the past few months (it's October 2017) after starting the browser I can open 3 tabs tops before the browser slows down incredibly, things load slower, videos stop and start, ads don't close quickly. Eventually, 3 tabs or more tabs, the whole thing comes to a halt and freezes and I have to restart. I've cleared my history. Doesn't help. I don't know what to do. Thanks for any help.

Gefragt von JenniferOcious vor 2 Jahren

Beantwortet von FredMcD vor 2 Jahren

  • Gelöst
  • Archiviert

Firefox crashes on startup

Crash ID: bp-d33ccc56-4b5b-483b-9f2f-1b66d1171011 Firefox crashes on startup. The crash still happens in Safe Mode and after Reinstallation of Firefox. Please help. … (Lesen Sie mehr)

Crash ID: bp-d33ccc56-4b5b-483b-9f2f-1b66d1171011

Firefox crashes on startup. The crash still happens in Safe Mode and after Reinstallation of Firefox. Please help.

Gefragt von kumamonmon vor 2 Jahren

Beantwortet von FredMcD vor 2 Jahren

  • Gelöst
  • Archiviert

How do I fix SEC_ERROR_LIBRARY_FAILURE?

I'm using Firefox Quantum and the day I installed it, everything was working great. But every since I've rebooted my PC, now I often get the error code SEC_ERROR_LIBRARY… (Lesen Sie mehr)

I'm using Firefox Quantum and the day I installed it, everything was working great. But every since I've rebooted my PC, now I often get the error code SEC_ERROR_LIBRARY_FAILURE when I try to load pages, like Google. Please advise.

Gefragt von rb8888 vor 2 Jahren

Beantwortet von jscher2000 vor 2 Jahren

  • Gelöst
  • Archiviert

Every Firefox update fails, and now Firefox will not even start.

For days, every time I have started Firefox, it asked whether I wanted an update. Every time I clicked Yes to update Firefox, the update failed. So I found the Mozilla … (Lesen Sie mehr)

For days, every time I have started Firefox, it asked whether I wanted an update. Every time I clicked Yes to update Firefox, the update failed. So I found the Mozilla site for installing the latest version of Firefox. The installation seemed to go fine, but Windows 10 now gives the following message:

"Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item."

I see nothing unusual in the Properties for what seems to be the Firefox executable. Of course, I can switch to GoogleChrome, but I prefer Firefox; in addition, all of my Firefox bookmarks are now gone.

Solution to these problems?

Gefragt von Wallet vor 3 Jahren

Beantwortet von Wallet vor 3 Jahren

  • Gelöst
  • Archiviert

Firefox will not install on any of my Windows 10 computers. It just continuously has a moving bar, saying 'Now installing.'

Over the last month or so, I've had trouble installing Firefox version 55 (latest version) on any new Windows 10 laptops. It just continuously has a moving bar, saying 'N… (Lesen Sie mehr)

Over the last month or so, I've had trouble installing Firefox version 55 (latest version) on any new Windows 10 laptops. It just continuously has a moving bar, saying 'Now installing.' This is on Windows 10 ver 10.0.15063, which is the latest version of Windows 10, to my knowledge. This happens on all my new computers, right out of the box after installing a fresh copy of Windows 10. Does anyone have any ideas on how to get it to install? I've tried disabling Windows Defender, which didn't help.

Gefragt von jodobr vor 2 Jahren

Beantwortet von FredMcD vor 2 Jahren

  • Gelöst
  • Archiviert

Firefox crashes

Suddenly while working within my Firefox browser, it crashed. When I went to re-launch Firefox the crash report window (pictured should be attached) popped up and when I … (Lesen Sie mehr)

Suddenly while working within my Firefox browser, it crashed. When I went to re-launch Firefox the crash report window (pictured should be attached) popped up and when I go to restart by clicking restart another window of the same pops up. It's a repeated cycle and I cannot even launch Firefox in safe mode. Please help!!


Crash ID: bp-049c94df-65a9-431b-acac-279821170912

Gefragt von Peachette128 vor 2 Jahren

Beantwortet von FredMcD vor 2 Jahren