Date: 11/12/09     Keywords: software

Epicor Software Corporation (NASDAQ: EPIC), a leading provider of enterprise business software solutions for the midmarket and divisions of Global 1000 companies, today announced that Epicor 9, the Company's next-generation enterprise resource planning (ERP) solution continues to gain momentum with more than 30,000 user seats shipped worldwide to date.

Both new and existing customers globally and across industries are realizing the benefits of Epicor's award-winning real-time business management solution, launched last year at the Company's annual global user conference.

"We are extremely pleased with the success Epicor 9 has achieved since its launch, both in terms of new customer wins, and existing customer implementations and migrations," said George Klaus, chairman, president and CEO for Epicor. "We are committed to delivering world class solutions, services and support to our customers -- to see them attain the benefits of improved business processes, productivity gains and overall success with Epicor 9 is gratifying. We expect the adoption of Epicor 9 to continue trending up, as we move toward availability of Epicor 9 in more than 50 countries and 30 languages by the end of next year."
EPIC next generation ERP-system

Source: http://sqlserver.livejournal.com/71676.html

Date: 11/12/09     Keywords: software

Epicor Software Corporation (NASDAQ: EPIC), a leading provider of enterprise business software solutions for the midmarket and divisions of Global 1000 companies, today announced that Epicor 9, the Company's next-generation enterprise resource planning (ERP) solution continues to gain momentum with more than 30,000 user seats shipped worldwide to date.

Both new and existing customers globally and across industries are realizing the benefits of Epicor's award-winning real-time business management solution, launched last year at the Company's annual global user conference.

"We are extremely pleased with the success Epicor 9 has achieved since its launch, both in terms of new customer wins, and existing customer implementations and migrations," said George Klaus, chairman, president and CEO for Epicor. "We are committed to delivering world class solutions, services and support to our customers -- to see them attain the benefits of improved business processes, productivity gains and overall success with Epicor 9 is gratifying. We expect the adoption of Epicor 9 to continue trending up, as we move toward availability of Epicor 9 in more than 50 countries and 30 languages by the end of next year."
EPIC next generation ERP-system

Source: https://sqlserver.livejournal.com/71676.html

Date: 10/26/09     Keywords: software

iQ4bis Software Partners with Tectura to Offer Business Intelligence to Tectura`s Customers

Source: http://sqlserver.livejournal.com/71331.html

Date: 10/26/09     Keywords: software

iQ4bis Software Partners with Tectura to Offer Business Intelligence to Tectura`s Customers

Source: https://sqlserver.livejournal.com/71331.html

Date: 10/26/09     Keywords: no keywords

Fujitsu Unveils glovia G2 ERP System for Production Management

Source: http://sqlserver.livejournal.com/71068.html

Date: 10/26/09     Keywords: no keywords

Fujitsu Unveils glovia G2 ERP System for Production Management

Source: https://sqlserver.livejournal.com/71068.html

Date: 05/11/09     Keywords: no keywords

SELECT CAST(CAST(getdate() as int) as datetime)

Avoids messing about with strings :)

And then, to get the start of the current month...

SELECT CAST(CAST(DATEADD(DAY,DATEPART(DAY,getdate())*-1, getdate()) as int) as datetime);

This I am using for daily Month-To-Date reporting. Comparison is much faster this way than checking DatePart(Month,getdate()) and DatePart(Year,getdate()) against the column.

Source: http://sqlserver.livejournal.com/70837.html

Date: 05/11/09     Keywords: no keywords

SELECT CAST(CAST(getdate() as int) as datetime)

Avoids messing about with strings :)

And then, to get the start of the current month...

SELECT CAST(CAST(DATEADD(DAY,DATEPART(DAY,getdate())*-1, getdate()) as int) as datetime);

This I am using for daily Month-To-Date reporting. Comparison is much faster this way than checking DatePart(Month,getdate()) and DatePart(Year,getdate()) against the column.

Source: https://sqlserver.livejournal.com/70837.html

Date: 02/25/09     Keywords: sql

Коллеги, ищется очень хороший DB(A) MSSQL для компании Innova Systems, Москва.

Задачи, которые будут ставиться перед вами - амбициозны и технически сложны. Вы будете работать в игровой индустрии, где требования к проектам меняются очень быстро, а нагрузки на системы очень высоки.
Процесс разработки построен по методологии Agile - Scrum. У вас будет возможность изучить новейшие методы работы команды и стать Scrum-мастером, если захотите.

Если вы получаете удовольствие от разработки и настройки баз данных и , если вы ищете драйв в работе и если хотите работать в команде лучших специалистов - мы ищем именно вас.

З/П определяется по результатам собеседования. Предлагайте ваши варианты.
Мы рассматриваем кандидатов из других городов и оказываем помощь при переезде.

Кратко о компании:
Мы занимаемся топовыми MMORPG (Lineage2, RF, R2 etc)
Даем - работу в компании, которая растет даже в кризис.
Официальное оформление, офис на м. Павелецкой


Должностные обязанности:
* Проектирование баз данных
* Участие в проектах разработки программного обеспечения в качестве эксперта БД
* Разработка и поддержка различных скриптов, хранимых процедур, триггеров и других объектов баз данных
* Оптимизация производительности баз данных
* Разработка, планирование и реализация ‘housekeeping’ задач на всех поддерживаемых серверах баз данных

Требования:
* Глубокие знания проектирования, внедрения и поддержки баз данных для приложений
* Опыт работы с MS SQL 2000,2005 от 3-х лет
* Опыт поддержки систем с высокой доступностью (7x24x365)
* Опыт разработки бекап/рековери стратегий, безопасности, мониторинга и оптимизации производительности
* Глубокое понимание концепций проектирования БД
* Высшее техническое образование
* Умение работать в команде
* Знание английского языка

Желательно:
* Опыт администирирования и работы с высоконагруженными OLTP базами данных
* Опыт работы с ETL (Extraction, Transformation, and Loading)
* Опыт работы с OLAP (On-line Analytical Processing) - плюс
* Знание администирирования серверов, администрирования безопасности и администирирования сети желателен
* Опыт работы c SAN


email: suren@innovasystems.ru
skype: surensv

Source: http://community.livejournal.com/sqlserver/70294.html

Date: 02/17/09     Keywords: sql

SSRS.
Bank in Pleasanton, CA.
Now.
Must pass a 30-minute SQL test.
Must be willing to put up with me for a boss.
No sponsorship.
Details on request.

Source: http://community.livejournal.com/sqlserver/70105.html

Date: 02/09/09     Keywords: no keywords

Neybe's opinion ;)
About fucking dynamics AX

Source: http://community.livejournal.com/sqlserver/69794.html

Date: 01/22/09     Keywords: no keywords

You can kill your own long running jobs in SAP by doing this steps

Source: http://community.livejournal.com/sqlserver/69513.html

Date: 12/19/08     Keywords: no keywords

Make the local installation of Axapta and about official requirements.

Source: http://community.livejournal.com/sqlserver/69372.html

Date: 12/18/08     Keywords: software

Small issue erp software and financial crisis

Source: http://community.livejournal.com/sqlserver/69011.html

Date: 11/25/08     Keywords: no keywords

I need to change rows into columns to wrap them into a header contract. This is how I need the data to show. If this is very involved I can see about paying for help.

Customer |Vendor |Service Type

McDonalds |MyCompany |Full Service



Oracle stores the data this way.

Role |Party Name

Customer |McDonalds

Vendor |MyCompany

Service Type |Full Service

Source: http://community.livejournal.com/sqlserver/68660.html

Date: 11/24/08     Keywords: web

I want to search a text field to return multiple instances of my
search criteria so I can apply a count to find out how many time
it appears in that particular piece of text. For EG: searching a
webpage stored in a DB field called content using %

Source: http://community.livejournal.com/sqlserver/68380.html

Date: 11/12/08     Keywords: sql

T-SQL Code:

[...]
SET @OGCWKT = (SELECT Geometry FROM inserted);
SET @valuesOnly = LEFT(@OGCWKT,LEN(@OGCWKT)-1);
SET @valuesOnly = RIGHT(@valuesOnly,LEN(@valuesOnly)-12);
RAISERROR(N'@valuesOnly = %s',0,0,@valuesOnly);
DECLARE @Index INT;
SET @Index = (SELECT CHARINDEX(@valuesOnly,N','));
RAISERROR(N'charindex of , = %i',0,0,@Index);
[...]


Input:

Geometry = 'LINESTRING (-1.21263269085502 53.1441705273226,-1.21261278851606 53.1441091569917)'


Output:

@valuesOnly = -1.21263269085502 53.1441705273226,-1.21261278851606 53.1441091569917
charindex of , = 0
Msg 536, Level 16, State 5, Procedure InsertEdge, Line 38
Invalid length parameter passed to the SUBSTRING function.
The statement has been terminated.

Source: http://community.livejournal.com/sqlserver/68109.html

Date: 09/27/08     Keywords: no keywords

Help me with this problem, please. There are three parts.

I have a table with milestones and dates:
FRID    ResourceKey    Milestone
1005    1    9/15/2008
1005    4    11/13/2008
1005    5    8/18/2008
1005    88    11/30/2008
1008    1    9/17/2008
1009    1    9/16/2008
1009    2    11/13/2008
1009    4    11/1/2008
1009    5    8/18/2008
1009    88    11/30/2008
1010    1    9/17/2008
1010    4    10/22/2008
1010    88    11/10/2008
1014    1    9/15/2008
1014    4    10/14/2008
1014    5    8/27/2008

And a table for key-text.
ResourceKey    FormDescription    SortOrder
1    CC Contacted    8
2    CC Meeting Held    9
3    CEO Meeting Held    10
4    Campaign Start    11
5    AI Completed    2
6    Match Agreement Signed    3
10    Recommendations Complete    14
12    Thank You Sent    16
13    Received Management Support    1

What I want to do is assemble a single text note for each company like this:
FRID    Note
1005    08/21/2007--AI Completed;09/27/2007--CC Contacted;10/18/2007--CC Meeting Held;...
1014    09/06/2007--AI Completed;10/08/2007--CC Contacted;11/01/2007--CC Meeting Held;...
...


First part: How can I get those notes, the way they're supposed to be formatted, in one statement, without using a cursor and a temp table?
(That's how I did it for 2007... I'd like to do it The Right Way for 2008)


The notes table has a three-part primary key and a "note" text field.
Frid, notedate, notesequence

When I insert the data, each company will have a different sequence for the note (depending on how many other notes have been inserted today. I need to have it be one more than the current max for each one.

Second part: How can I insert the rows into the notes table all at once, without looping through?


A problem is that companies might have records merged during the year, for some reason. So, while in the milestones table, there's 3 separate FRIDs, there's only one frid in the notes table. Of course there's a table listing the merged frid and the new frid.

Third part: How can I insert notes all at once, when the data might have more than one row for a particular FRID?

Source: http://community.livejournal.com/sqlserver/68063.html

Date: 09/12/08     Keywords: sql

Okay, this is new...

SQL Server Express Edition 2008. Brand-new install. For some reason SQL Server Agent was listed as Disabled in the agents listing, so I set it to automatic and started it. It worked. I restarted the computer (for an unrelated reason) and started having problems connecting from C#, so I checked the agent again. It was again listed as disabled. I switched it once again to Automatic and hit Start, at which point I received the following message:

"The SQL Server Agent (SKINGAWEE) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

SkingaWee (the instance name) is currently running, I have it open in Management Studio. Thus, it would seem Agent would have something to do. Anyone know why this might be occurring and, more importantly, how I can fix it?

Source: http://community.livejournal.com/sqlserver/67400.html

Date: 08/19/08     Keywords: no keywords

I'm having a weird issue using the FTP Connection Manager to upload and download files to a remote FTP site.

What ends up happening is that our ftp sessions seem to be disconnecting rather than logging off the remote FTP server. We end up having one of our files write locked and our packages start failing. Someone on the other end then kills all 10-15 of our ftp sessions that show as 'disconnected' but not terminated, and unlocks the file as well.

Has anyone seen any issues similar to this before? I would have thought that the FTP connection manager would be smart enough to log off instead of just disconnect....

puzzled - any suggestions welcome!
TIA

Source: http://community.livejournal.com/sqlserver/67089.html