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
  • Archived

If I upgrade to most recent Firefox version will I loose Identity Safe w/ Norton?

the last time I tried to upgrade firefox I lost my Identity Safe w/Norton. Is this issue still ongoing? URL of affected sites http:// … (read more)

the last time I tried to upgrade firefox I lost my Identity Safe w/Norton. Is this issue still ongoing?

URL of affected sites

http://

Asked by AnonymousUser 9 years ago

Answered by Morbus 9 years ago

  • Solved
  • Archived

Suddenly can't view image content on a stock photography site.

Suddenly in the last few days, I can no longer view images on a stock photography site where I sell content. I can view the thumbnails of my and others' images, but when … (read more)

Suddenly in the last few days, I can no longer view images on a stock photography site where I sell content. I can view the thumbnails of my and others' images, but when I click to enlarge, I get only a white box the size the image would be. I can also no longer view images posted in the forums. I've logged out and back in, cleared cookies, run CCleaner, rebooted, updated Java, and nothing helps. I can view the content if I log on with a different browser so this is a Firefox issue.

URL of affected sites

http://www.submit.shutterstock.com

Asked by AnonymousUser 9 years ago

Answered by the-edmeister 9 years ago

  • Solved
  • Archived

How can I get 3.5 back?

I had 3.5 for online cci.edu it work just fine. I downloaded 3.6 and now I can't attend my classes. Above the web page it says: Firefox Security has redirected your pa… (read more)

I had 3.5 for online cci.edu it work just fine. I downloaded 3.6 and now I can't attend my classes. Above the web page it says: Firefox Security has redirected your page. I need to know what do I need to do so I can get into school. I'm getting behind in my classes. I didn't have this problem with all the other Firefox before now. I have deleted all my cookies etc. Please help!!!!!!! I would like to redownload 3.5 if I can or a lower version if I can't resolve this problem. Where can I get it? I've been looking for them.

Asked by AnonymousUser 9 years ago

Answered by rjohnson19 9 years ago

  • Solved
  • Archived

automatic log on does not work 3.6.8 windows 7

There are 2 forums that I visit every day. I've set preferences for automatic log on. However, I have to manually log on each visit. On one of the sites, my log on inf… (read more)

There are 2 forums that I visit every day. I've set preferences for automatic log on. However, I have to manually log on each visit. On one of the sites, my log on information is remember correctly. On the other the info isn't remembered. What can I do to restart the automatic log on? The problem isn't due to virus protection. I'm using Firefox 3.6.8, Windows 7.

URL of affected sites

http://www.cpaptalk.com/CPAP-Sleep-Apnea-Forum.html

Asked by AnonymousUser 9 years ago

Answered by cor-el 9 years ago

  • Solved
  • Archived

i can't access photobucket.com when try to acess its redirecting to http://m.photobucket.com/?src=www And i dnt whats went wrong with my firefox, but i can access the same with IE8 , can anyone help me out..??

i can't access www.photobucket.com when try to acess its redirecting to http://m.photobucket.com/?src=www And i dnt whats went wrong with my firefox, but i can access t… (read more)

i can't access www.photobucket.com when try to acess its redirecting to http://m.photobucket.com/?src=www And i dnt whats went wrong with my firefox, but i can access the same with IE8

URL of affected sites

http://www.photobucket.com

Asked by sharvinzlife 9 years ago

Answered by AnonymousUser 9 years ago

  • Solved
  • Archived

Can't see previews of threads on vBulletin 3 forums in 4b2

With forum sites that run using vBulletin, when you mouse over the subject line of a thread in the forum, you get the first sentence or so of the post (about 80 or so cha… (read more)

With forum sites that run using vBulletin, when you mouse over the subject line of a thread in the forum, you get the first sentence or so of the post (about 80 or so characters). When browsing Forums that are running on vBulletin, prior to the installation of Firefox 4 Beta 2, this works. However, after I upgraded from Firefox 4 Beta 1 to Beta 2, this no longer worked. Does anyone know a fix for this, or is this a bug in Beta 2? I've checked other sites that use vBulletin, and they have the same problem.

URL of affected sites

http://forum.rpg.net

Asked by CountZero 9 years ago

Answered by CountZero 9 years ago

  • Solved
  • Archived

I can not locate other new vehicles with Firefox on GM Dealerworld but I can on Explorer

I am not able to locate other new vehicles with Firefox on GM dealerworld but I am able to with Explorer URL of affected sites http://gmdealerconnect … (read more)

I am not able to locate other new vehicles with Firefox on GM dealerworld but I am able to with Explorer

URL of affected sites

http://gmdealerconnect

Asked by AnonymousUser 9 years ago

Answered by silkphoenix 9 years ago

  • Solved
  • Archived

I'm no longer able to use hotmail. I'm on windows 98 and use firefox 2.0.0.20

Just today, about an hour ago, I can no longer work the hotmail site. I can't upgrade my system, it's windows 98. I use firefox 2.0.0.20 URL of affected sites http://ww… (read more)

Just today, about an hour ago, I can no longer work the hotmail site. I can't upgrade my system, it's windows 98. I use firefox 2.0.0.20

URL of affected sites

http://www.hotmail.com

Asked by AnonymousUser 9 years ago

Answered by AnonymousUser 9 years ago

  • Solved
  • Archived

Firefox use much memory (over 300MB) when i go to vuionline.com

When i go tho this page, processes in window task manager show that firefox usage 250.000K and my system is so slow. URL of affected sites http://vuionline.com … (read more)

When i go tho this page, processes in window task manager show that firefox usage 250.000K and my system is so slow.

URL of affected sites

http://vuionline.com

Asked by AnonymousUser 9 years ago

Answered by Morbus 9 years ago

  • Solved
  • Archived

Why can't I play games like Sudoku on the NY Times site using Firefox?

There doesn't seem to be anything I can do to get the puzzle to load. URL of affected sites http://www.nytimes.com/ref/crosswords/sudoku/medium.html … (read more)

There doesn't seem to be anything I can do to get the puzzle to load.

URL of affected sites

http://www.nytimes.com/ref/crosswords/sudoku/medium.html

Asked by AnonymousUser 9 years ago

Answered by cor-el 9 years ago

  • Solved
  • Archived

impossible d'afficher correctement cette page web http://www.mini-iac.com/TrainingLibrary/tabid/121/Default.aspx

Issue Firefox is having problems with certain web sites Description Cette page web refuse de s'afficher correctement URL of affected sites http://www.mini-iac.com/Train… (read more)

Issue

Firefox is having problems with certain web sites

Description

Cette page web refuse de s'afficher correctement

URL of affected sites

http://www.mini-iac.com/TrainingLibrary/tabid/121/Default.aspx http://www.mini-iac.com/portals/0/Education/PPT/Basic_2010.htm

Troubleshooting information

La page n'est pas afficher correctement

Firefox version

3.6.6

Operating system

Windows 7

User Agent

Mozilla/5.0 (Windows; U; Windows NT 6.1; fr; rv:1.9.2.6) Gecko/20100625 Firefox/3.6.6 (.NET CLR 3.5.30729)

Plugins installed

  • -NPRuntime Script Plug-in Library for Java(TM) Deploy
  • Adobe PDF Plug-In For Firefox and Netscape "9.3.3"
  • Default Plug-in
  • The QuickTime Plugin allows you to view a wide variety of multimedia content in Web pages. For more information, visit the QuickTime Web site.
  • Shockwave Flash 10.1 r53
  • GEPlugin
  • 4.0.50524.0
  • Google Update
  • Next Generation Java Plug-in 1.6.0_20 for Mozilla browsers

Asked by AnonymousUser 9 years ago

Answered by cor-el 9 years ago

  • Solved
  • Archived

receiving the following error code when searching a piece of music that I've done many times without a problem music but have recently updated Firefax: Fatal error: Call to undefined function AmazonData() in /home/boss/public_html/mc on line 13

I am in web page http://www.songarea.com/ and after searching for a piece of music I get the following error mesage: "Fatal error: Call to undefined function AmazonData()… (read more)

I am in web page http://www.songarea.com/ and after searching for a piece of music I get the following error mesage: "Fatal error: Call to undefined function AmazonData() in /home/boss/public_html/mc on line 13" I have done this many time before without a problem but have recently updated Firefox with the Skype add-on and wonder if the two things are connected.

URL of affected sites

http://www.songarea.com/

Asked by AnonymousUser 9 years ago

Answered by rjohnson19 9 years ago

  • Solved
  • Archived

FIREFOX DOESNOT OPEN WHEN I VISIT VIKATAN.COM BY USING 3.6.6 VERSION

PREVIOUSLY I WAS USED OLD VERSION 3.0.6 OF FIREFOX AT THAT TIME WHEN I BROWSED THE SITE http;//www.vikatan.com .NOW I WAS UP DATED NEW VERSION OF FIREFOX 3.6.6 NOW I CAN… (read more)

PREVIOUSLY I WAS USED OLD VERSION 3.0.6 OF FIREFOX AT THAT TIME WHEN I BROWSED THE SITE http;//www.vikatan.com .NOW I WAS UP DATED NEW VERSION OF FIREFOX 3.6.6 NOW I CAN NOT OPEN THE ABOVE SITE,KINDLY SOLVE THE PROBLEM.

URL of affected sites

http://www.vikatan.com

Asked by AnonymousUser 9 years ago

Answered by cor-el 9 years ago

  • Solved
  • Archived

If I access my website as http://www.spainforyou.net, I get the OLD pages, using http://spainforyou.net, (no www), brings up lates updates. My server support said this was a problem with cache, but I have cleared ALL including network.

If I access my website as http://www.spainforyou.net, I get the OLD pages. Using http://spainforyou.net, (no www), brings up latest updates. My server support said this… (read more)

If I access my website as http://www.spainforyou.net, I get the OLD pages. Using http://spainforyou.net, (no www), brings up latest updates. My server support said this was a problem with cache, but I have cleared ALL including network, and it still doesn't work.

URL of affected sites

http://www.spainforyou.net

Asked by AnonymousUser 9 years ago

Answered by AnonymousUser 9 years ago