Viser spørgsmål med mærket: Vis alle spørgsmål
  • Låst

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… (læs mere)

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 for 2 måneder siden

  • Arkiveret

Fire fox wont' come up at all today. I'm having to use a different search engine.

I've been trying to bring up Firefox off and on for over an hour now, and it won't come up. I was forced to use a different search engine in fact just to post this probl… (læs mere)

I've been trying to bring up Firefox off and on for over an hour now, and it won't come up. I was forced to use a different search engine in fact just to post this problem. I recently upgraded to Windows 10, but that has been about 2 weeks or so ago. I even tried installing and reinstalling the program and allowed an upgrade just now. Still no luck. I'm not a "computer person" so I don't know any computer jargon. Can any one help me, or is it a FF problem?

Asked by MartaEB66 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

When at Amazon.com, Daily Deals, images and text do not display in Firefox (but will in Explorer). Latest versions, settings seem ok, javascript enabled

Windows 10, Firefox and Javascript up to date. When in Amazon.com. opening "Daily Deals", there are no images or text. This page shows correctly when using Internet Exp… (læs mere)

Windows 10, Firefox and Javascript up to date. When in Amazon.com. opening "Daily Deals", there are no images or text. This page shows correctly when using Internet Explorer (Windows 10).

Asked by CaptQ 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

Firefox can't load a website properly. Troubleshooting doesn't help.

For some reason the website 'Tumblr' (http://tumblr.com) won't display correctly in Firefox no matter what I do. It displays as it should in other browsers and other comp… (læs mere)

For some reason the website 'Tumblr' (http://tumblr.com) won't display correctly in Firefox no matter what I do. It displays as it should in other browsers and other computers with Firefox.

Here is what I've tried: - Followed all steps on Mozilla's troubleshooting page -Deleted browsing history/cleared cache -Removed all add-ons -Disabled plug-ins -Opened in safe mode -Deleted and reinstalled the program -Disabled hardware acceleration -Updated Windows

Nothing seems to fix the issue.

Asked by Alex989 4 år siden

Last reply by Alex989 4 år siden

  • Løst
  • Arkiveret

firefox does not load properly

my firefox browser does not load properly. i have updated browser and followed trouble shooting steps to reinstall again . The trouble first started with Yahoo not loadii… (læs mere)

my firefox browser does not load properly. i have updated browser and followed trouble shooting steps to reinstall again . The trouble first started with Yahoo not loadiing and not showing images and email not loading properly. When i try to open addon pages or any other pages in firefox help they do not load properly .Also i cannot install any add ons for example print edit. I have checked that javascript is enabled and it shows it is enabled as true. I have included screen shots of this problem.

Asked by Paul15 4 år siden

Answered by FredMcD 4 år siden

  • Arkiveret

Firefox will not start. I fresh installed. Tried opening with adminstrative status.

Yesterday I added Kaspersky antivirus. Now I can't start Firefox or Chrome. I'm having to use Microsoft Edge. I uninstalled Firefox and fresh installed. I disabled Kasper… (læs mere)

Yesterday I added Kaspersky antivirus. Now I can't start Firefox or Chrome. I'm having to use Microsoft Edge. I uninstalled Firefox and fresh installed. I disabled Kaspersky and tried to start Firefox. I am running Windows 10 on a new Asus laptop. My daughter has a new laptop running Windows 10 and Kaspersky and she's not having a problem. I can't click on the "Automatically add" link because I'm in Edge. I can't start Firefox.

Asked by fortworthsandi 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

Since Windows 10 upgrade Firefox won't open, I'm able to execute it but the window won't maximize (I can see the small image when hovering over the taskbar)

Since Windows 10 upgrade Firefox won't open, I'm able to execute it but the window won't maximize (I can see the small image when hovering over the taskbar). I also remem… (læs mere)

Since Windows 10 upgrade Firefox won't open, I'm able to execute it but the window won't maximize (I can see the small image when hovering over the taskbar). I also remember that Firefox worked shortly after the upgrade for like a month but started to get slower. Also the last times it worked, it started to crash after startup and I had to kill the default startup page.

Asked by Daisy135 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

I have Win 10 on my laptop,can not get my email or use mozilla or thunderbird

my desk top has Win 10 and I have been using Mozilla and Thunderbird with out any problems when I put Win 10 on my laptop Mozilla will not run nor will Thunderbird I get … (læs mere)

my desk top has Win 10 and I have been using Mozilla and Thunderbird with out any problems when I put Win 10 on my laptop Mozilla will not run nor will Thunderbird I get a message that says Mozilla is a unsecure program how can I fix this?

Asked by countynu 4 år siden

Last reply by guigs 4 år siden

  • Arkiveret

Firefox doesn't work in Windows 10, but I don't have Trusteer Rapport as suggested in Forum.

When I click on Firefox icon, it opens. When I attempt to enter a url, it presents "Well, this is embarrassing" error message and becomes nonresponsive. I have attempted … (læs mere)

When I click on Firefox icon, it opens. When I attempt to enter a url, it presents "Well, this is embarrassing" error message and becomes nonresponsive. I have attempted both "restore" and "close" but get the same frozen screen on reopening. Your forum suggests that the problem is Trusteer Rapport. To my knowledge, I do not have Rapport (have never heard of it and it does not show up on my list of apps). I also tried downloading latest version but also got the same result. Firefox used to be my default browser (Win 8.1 and earlier).

Following advice on forum, I looked at crash reports and found this single ID in the period after I upgraded to Win10: bp-9f2cbb58-8637-4cce-b84c-4e2322150826

Asked by MKWin 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

Firefox crashes

al abrir el navegador después de 5 segundo este se cierra pasa lo mismo en modo seguro, ya se desinstalo se instalo, se volvió a desinstalar se hizo limpieza con el cclea… (læs mere)

al abrir el navegador después de 5 segundo este se cierra pasa lo mismo en modo seguro, ya se desinstalo se instalo, se volvió a desinstalar se hizo limpieza con el ccleaner se raparo el registro y el fallo persiste después de volver a instalar

ID del fallo: bp-7b03df05-ecd7-473c-bf48-fcaa52151222

Asked by irosbe 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

How to unistall Firefox 40.0.3 from Windows 10. Nothing worked so far.

Mozilla Firefox is like virus to me. I did try all possible advices I found on Internet and nothing did help. Is there any real support from creators of this stubborn bro… (læs mere)

Mozilla Firefox is like virus to me. I did try all possible advices I found on Internet and nothing did help. Is there any real support from creators of this stubborn browser?

Asked by snowcon 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

Everytime I log-in to Firefox, I get a address incomplete page, when I have MSN as my homepage?

Ever since I accepted Windows 10, I cannot log directly to my home page(MSN) with Firefox. A mostly blank page appears that says a portion of the web address is missing. … (læs mere)

Ever since I accepted Windows 10, I cannot log directly to my home page(MSN) with Firefox. A mostly blank page appears that says a portion of the web address is missing. I have tried uninstalling and installing Firefox several times with no success. I've checked my homepage choice and it reflects MSN and the" MSN as my home page" is in the program list. In fact, if I go directly to the list after start-up and open the MSN as my home page program, I am taken directly to MSN within Firefox. With Windows 8.1, I clicked on the Mozilla Icon, in my task bar and was taken right to MSN.

Asked by trainpain 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

Firefox crashes

Beginning just today, when I try to open Firefox, I get the message: Firefox is already running, but is not responding. The old Firefox process must be closed to open a n… (læs mere)

Beginning just today, when I try to open Firefox, I get the message: Firefox is already running, but is not responding. The old Firefox process must be closed to open a new window. with the option to Close Firefox or cancel. When I click close firefox, I get a message: Your Firefox profile cannot be loaded. It may be missing or inaccessible. I have tried uninstalling and reinstalling, restarting my machine. I'm at a loss. I have no idea why this is happening and can't seem to fix it! Help!!!

Asked by kmileski 4 år siden

Last reply by cor-el 4 år siden

  • Arkiveret

how do i delete a picture that shows up on my screen after it is not used for a few minutes

A picture showed up on my computer and asked if I like it, (as background or screensaver) I know better than to click on things like that, but I thought I would have a ch… (læs mere)

A picture showed up on my computer and asked if I like it, (as background or screensaver) I know better than to click on things like that, but I thought I would have a chance to delete it. I said yes I like it, and now it is always there when I come back to my computer. I have to click on it and sign in, (never had to sign in before) I can't find any way to get rid of it.

Asked by ruthmorgan1 4 år siden

Last reply by FredMcD 4 år siden

  • Løst
  • Arkiveret

Download is taking unbelieveably long and then stops, then starts all over again

The "firefox setup" page with the green bar is taking way too long INFINITE -- Not only does this not work on this new this laptop I bought yesterday, but it also wont do… (læs mere)

The "firefox setup" page with the green bar is taking way too long INFINITE -- Not only does this not work on this new this laptop I bought yesterday, but it also wont download on my other laptop - 2 years old (same exact situation). So I can say there is something seriously wrong with your link or software.

This computer is running on all new hardware and software. Also, it doesn't work on my other laptop. Furthermore, this never happened with any other program or computer or browser ever in the past.

I am downloading Firefox for a masters program in analytics.

Asked by AdamLaframboise 4 år siden

Answered by cor-el 4 år siden

  • Arkiveret

How to remove yahoo from the configuration

I have used firefox as webbrowser ever since it exists. Always in combination with google as search engine. I have also installed this combination at several friends. No… (læs mere)

I have used firefox as webbrowser ever since it exists. Always in combination with google as search engine. I have also installed this combination at several friends. Now I am faced with the fact, that my configuration is permanently overridden with the Yahoo-engine. I know how to overide this again by using the about:config file. It works for me for some time, than I am switched back to Yahoo again. I dislike the feature, that configurations are overridden by somebody elses will, because I cannot be sure, why this is: ist it by intent or is it a virus or a another malware. I have learned, that this is by intent. But not mine. Can you please advice me how to make sure that my config-file can be kept persistently in the status I have defined it.

Would be great to hear from you.

Kind regards

A customer

Asked by fwoerndle 4 år siden

Last reply by FredMcD 4 år siden

  • Arkiveret

Email attachments are automaticly downloaded

I'm using windows 10 and i have several emailaccounts like gmail, gmx and outlook. Everytime when i open an attachment the system automaticly saves it in my download dire… (læs mere)

I'm using windows 10 and i have several emailaccounts like gmail, gmx and outlook. Everytime when i open an attachment the system automaticly saves it in my download directory. I don't want my attachments saved on my computer, can i change this setting? Thank you.

Asked by Karinnas78 4 år siden

Last reply by Swarnava Sengupta 4 år siden

  • Arkiveret

Firefox crashes after I start up and try to do anything.

Firefox keeps crashing after I start it up and try to do anything like opening a new window or doing a search. It will freeze and then crash everytime. It will give me th… (læs mere)

Firefox keeps crashing after I start it up and try to do anything like opening a new window or doing a search. It will freeze and then crash everytime. It will give me the following detail that is says it is sending to you also. I have tried to uninstall and reinstall several times and doesn't help. Please help me fix this. Thanks

AdapterDeviceID: 0x1618 AdapterDriverVersion: 10.18.13.5384 AdapterSubsysID: 1ced1043 AdapterVendorID: 0x10de Add-ons: %7B972ce4c6-7e08-4474-a285-3208198ce6fd%7D:44.0 AvailablePageFile: 14228115456 AvailablePhysicalMemory: 11042631680 AvailableVirtualMemory: 208179200 BIOS_Manufacturer: American Megatrends Inc. BlockedDllList: BreakpadReserveAddress: 50659328 BreakpadReserveSize: 67108864 BuildID: 20160123151951 CrashTime: 1454092050 EMCheckCompatibility: true FramePoisonBase: 00000000f0de0000 FramePoisonSize: 65536 InstallTime: 1454062029 MozCrashReason: MOZ_CRASH()

Asked by Shane.Hanson 4 år siden

Last reply by the-edmeister 4 år siden