Seeking An SQL Funtion ~ Do You Know IT

Reg Split Funtion
Hi,

Is it possible to split the following value in sql server ?

I have the value like 25 Email Accounts,50 Email Accounts in my sqlserver database.
Here i need only the numeric value .ie 25,50.Is it possible? can any one give me the solution ..

I am using ASP.Net and C# backend is SQL Server 2000.

Thanks and Regards
Arul

View Replies !

---

Replace Funtion
how do i write a replace function that will replace a certain character with a return key (ie what happens when we do Ctrl+return key in SQL Enterprise table... so that the rest of the cell data in the column is on the next line?!

SELECT REPLACE(tasks, '/', '????') AS EXPR1
FROM log_descriptions


what should ???? be?

View Replies !

---

BCP Funtion Problem
Hi,

I'm using the function bcp to transfer data from my table to a data file. When I use it at the dos command prompt, no problem everything works really well.

But if I use query analyser I have an error: unable to open bcp host data-file.

Here's the line:
xp_cmdshell 'bcp table.owner.inventaire out c:1est.txt'

The problem is not with xp_cmdshell because I can call simpler executables in query analyser.

View Replies !

---

To_date Funtion YYYY-DD-MM
Hi All:
We have a database date column in this format: 1/27/2008 1:20:00 AM and need a date or time function to cast local JVM time into the above format.

Suggest me the best options.
1. To go for a more comfortable date format in the database itself or
2. To have an appropriate conversion in my code.( I am not feeling good about the suffix AM/PM in the date column!)

Thanks.

View Replies !

---

Round Funtion On Entire Columns In MSSQL?
Hi,I'd like to round all amounts in a certain column to 2 decimals.I tried the following query, but eventhough the syntax is correct, itdoesn't give any result:update gbkmutset bdr_hfl = round(bdr_hfl,2)can anyone help me?cheers,steve

View Replies !

---

REPLACE Funtion For Multiple Values In SP/Reporting Services
Running into a problem with trying to pull multiple values in a stored procedure.
Ran Profiler for trace on what variable is coming back as when running in Reporting Services.
Profiler shows this:
 

exec apGetCompanysByRep @Product = N'Absorbent Pads,Airedale Terrier'
 
Trying to run Replace function but not quite getting the syntaxt correct. The stored procedure will work but when running report will often get unclosed quotation marks.
What I have:
 

Set @Product=

Replace(@Product, '''' + ',' + @product + '''', (@Product + '''' + ',' + ' ' + '''' + @product + ''''))

 
This is probably a little too much coding but I've tried several ways.
 
In the SP the code is as follows:
 

CREATE PROCEDURE [dbo].[apGetCompanysByRep]

@Magazine varchar(6) = null

, @DirectsMagazine varchar(6) = null

, @Category varchar(50) = null

, @SubCategory varchar(50) = null

--, @FirstName varchar(30)

, @LastName varchar(30)= null

, @Product varchar(1100)

AS

declare @SQL varchar(2000)

Set @Product=Replace(@Product, '''' + ',' + @product + '''', (@Product + '''' + ',' + ' ' + '''' + @product + ''''))



set @SQL = '



 
 
Thanks for any assistance anyone can give.

View Replies !

---

Seeking Help With A Query
Hello
I have this data in a Access DB of ~4500 posts.
Here is a sample of my problem.
The Name has no ID, it is a simple text field with ~1800 diferent names in it:
Year|Name|
-------------------
2005|NN|
2005|NN|
2005|YY|
2005|XX|
2006|XX|
2006|XX|
2006|XX|
2006|NN|
2006|NN|
2008|NN|
2008|NN|
2008|NN|

I have tried to make a SQL query to show this:
Count of each Name Grouped by year

Year|Name|Cnt
-------------------
2005|NN|2
2005|YY|1
2005|XX|1
2006|XX|3
2006|NN|2
2008|NN|3

and this:
All Name as total count in the DB
|Name|TotalCnt
------------
|NN|7
|XX|4
|YY|1

without any success.
All ideas are welcome at this point since i am stucked.

View Replies !

---

Seeking Answer
1)Which statement shows the maximum salary paid in each job category of each department?_______
A. select dept_id, job_cat,max(salary) from employees where salary > max(salary);
B. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat;
C. select dept_id, job_cat,max(salary) from employees;
D. select dept_id, job_cat,max(salary) from employees group by dept_id;
E. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat,salary;

2)description of the students table:
sid_id number
start_date date
end_date date
which two function are valid on the start_date column?_________¡£
A. sum(start_date)
B. avg(start_date)
C. count(start_date)
D. avg(start_date,end_date)
E. min(start_date)
F. maximum(start_date)

View Replies !

---

DTS Packages- Seeking Confirmation
Hello all,
I have 2 primary key fields the ssn and refnum... if the data in the file is duplicated it will not import to my table rights even though i am using DTS to do my import, correct? or do I need to add an extra validator in there?

View Replies !

---

Seeking BEST Method For SQL To MSAccess
I would like to pull some data from a SQLServer database, and save it into an Access MDB file (which can be empty to start). I would then zip up the MDB and download it to the user.

I am seeking advice on the most "elegant" or "efficient" way to do this. Here are some ideas I have been considering:

1) Should I start with an empty template MDB and file-copy it before I populate it? Or is there a neat way in ASP.NET to allocate a brand new MDB outright?

2) I could read the SQLServer data into a Dataset object. I could then open a connection to the MDB, create a table object, defining all the columns, etc., and then I could write the data to the new table object. BUT ... I have a hunch there is a nifty ADO.NET way to save the data already in the Dataset object right into the MDB (creating the table and columns as a matter of course) ... all with an instruction or two (or three). Any ideas?

Thanks in advance!

View Replies !

---

Seeking For The Fast Query
Hello, everyone:

There is a big table with several million records. I am developing a query that retrieve the first rowset that meets WHERE condition. Any suggestions for the fast query? Thanks a lot.

ZYT

View Replies !

---

Attach Db ( Desperate Seeking For Help )
A database with 1 mdf and 2 ldf has been detached from SQL Server 7.0 . Then removed the log files ( they are gone , unable to recover ) and there's no backup at all . Now I want to attach the database with the same mdf , but got error msg - 'Device activation error'. It seems like it's looking for one of the log files.

Is there any way to recover the db ?

I guess NOT , isn't it ?

I don't understand why it doesn't work with sp_attach_single_file_db and sp_attach_db . I actually tested it with a dummy database with 1 log file , and it worked - a new log file was recreated. Thus I performed in production server. Don't understand why it doesn't work.


thanks in advance.

View Replies !

---

Novice Seeking Advice With SQL 2000
Hello,
 I am asking a question i have seen many threads on, but I am looking for an idiot's guide on how to convert my SQL 2005 database to SQL 2000 so i can get it to run on my web hosting server. I'm very new to asp.net , but have ahd years of experience in normal HTML and a year or two in the old ASP.
 I was advised to learn ASP.Net 2.0 and have found it nothing but brilliant. The intergration with SQL 2005 made it a lot quicker to link up a database than using Access. Unfortunatly my hosting company is a little behind and still using SQL 2000. There isn't mch databse intergration (a few aplication forms) so I dont mind re-writing the whole database but I dont know how to set Visual web developer up with a SQL 2000 Database. I have also read from various other forums that you can convert a databse to 2000 by doing something with the scripts, but the explaination is too complicated for me to follow.
 Is there anyone out there who wouldn't mind going over some old ground and explain this all in simple terms? Im using 'SQL Server Managment Studio Express' (although i dont know how to use it) and 'Microsoft visual web developer 2005 express edition' .
 Thanks for reading this
 
Simon

View Replies !

---

Seeking Walkthru -- Set Up Secure User Rather Than Use Sa
Could someone point me to a walkthru or FAQ that lists the steps involved in creating a user (other than SA) on SQL Server. SA is used in most coding examples but I know I don't want to use it in production.

- seeking info for both a develpment setup and a production setup

I'd like to start out with a user configuration that will move easily to production.

View Replies !

---

Seeking SQL Server And IIS/E-Commerce Engineers
SQL Server RAPID RESPONSE ENGINEER (NYC area - relocation package available) - Seeking SQL and IIS/E-Commerce engineers. Primary responsibilities include: Providing technical and creative solutions for service delivery by visiting customer problems sites, while ensuring customer satisfaction with Microsoft Networking, BackOffice and Desktop software. The successful candidate will be capable of performing on-site support of on-going support activities including but not limited to Premier Support, supportability content development, and escalation team support. The Rapid Response Engineer acts as the customer-visible point of escalation and resolution for Premier Support and provides advanced technical support to corporate customers and end users for complex products, including highly escalated issues. Provides support in-person at the customer's place of business, as well as via telephone, written correspondence, and electronic media. Exceptional customer service, communication, problem solving, and technical writing skills are required. Must have sufficient technical depth to communicate with development and other internal organizations at a peer level. Must have the ability to work with minimal supervision. Must have the ability to work independently and as part of a team. Recommended qualifications include: Superior problem solving and troubleshooting skills at a Systems Engineer level; Demonstrated aptitude for providing exceptional customer service; Ability to grow the technical expertise of peers via training development and delivery, mentoring, and content development; Ability to apply technology to improve existing products and systems; Ability to actively participate in team problem solving by proposing and implementing solutions; Ability to adapt quickly to changing circumstances, direction, and strategy; Demonstrate strategic thinking with value-add contributions. Technical Requirements: Solid understanding of standard computer and networking concepts, and Internet fundamentals, is required. A superior knowledge and demonstrated technical proficiency in at LEAST one of: Windows 95/98 Windows NT/Windows 2000 Exchange SQL IIS/ASP/Proxy Desirable Technical expertise: Strong technical depth in at least two of the above. Technical expertise in other relevant MS applications such as SMS, SNA, other MS Internet Technologies, etc. Debugging skills in Windows 95/98/NT, Exchange, and SQL Programming skills in one or more of the following: SQL, VB, VBA, C++, VJ++, VBS, Jscript, HTML/DHTML Education: College degree, preferably in Computer Science, is required. MCSE. MCDBA, or MCSD strongly preferred. Will consider related field (or equivalent) experience. Please email resume to: a-tomj@microsoft.com

View Replies !

---

Seeking SQL2000 Instance Info
I am looking for information (whitepaper, developer notes, heck even good ole hearsay) about the assumed performance hit that a box takes when running multiple instances of SQL Server 2000. In particular, what is the additional overhead and what is the performance difference between a one instance machine and a two instance machine or a two instance machine and two one instance machines? Certainly, the two instance machine will share memory, etc., but I'm looking for some practical "meat" to help us make some design decisions.

My digging has turned up no information, and the box where I have SQL 2000 installed is a turtle that is not production ready.

Any ideas?

View Replies !

---

Seeking: Alternatives For Initiating SSIS
Hello all,  I'm new to SSIS and this forum, and this is my first post.
 
We're migrating a 2000 DTS ETL process to 2005 SSIS.  We really like the enhanced functionality of SSIS thus far.
 
One problem we have with our 2000 process is that runs at 1:00am each morning. The scheduling is done via a distributed scheduling tool called Maestro. Our process pulls data from a mainframe-based DB2 OLTP and reformats it into SQL Server reporting tables.  We have nightly mainframe batch processing that updates the DB2 tables, and we need those updates on a nightly basis.
 
The mainframe batch process starts at 8:00pm each evening.  It finishes normally by 1:00am 90% of the time, but it is 20+ years old, and has its share of problems, especially during month-end.  The problems can't be resolved until the next business day in some cases.
 
We'd like to elegantly connect the two processes somehow so the SSIS ETL process kicks off when the mainframe batch process finishes.  I intentionally didn't use the word 'trigger' up until this point.
 
It would not be a problem to modify the mainframe batch process to insert or update a DB2 table that SSIS has access to, but I don't think we can get the mainframe batch process to update SQL Server 2005 tables...?
 
Any advice would be greatly appreciated--TIA!
 
John

View Replies !

---

Replication Scenario - Seeking Suggestion
I have two sites. Site A and Site B

Each site has two databases

Site A

     Db1

     Db2

Site B

    Db1

    Db2

Site A Db1 has to perform transaction replication to Site A- Db2 and Site B- Db1 and Db2.

 

I started Site A as pubisher and distributor and Site A and Site B both as subscriber.

 

Site B is in a different geographical area (state).

 

----------

Please suggest the best scenario to save bandwidth and server load for Publisher, and Distributor.

 

-------

Earlier I thought that I will implement local replication between Site B - in between Db1 and Db2. The Sql Server does not let me set Db1 as publisher, and distributor for its local database Db2.

 

-------

P.S. My all databases need same transactions though they are connected to different hardware at different places. So please don't question that why I need four similar databases.

 

View Replies !

---

Upgrading To SQL 2005 From 2000 - Seeking Advice
Hello everyone, I am upgrading from SQL Server 2000 to SQL Server 2005. Any caveats? Can I just detach the db's and attach them into 2005. Or is there any conversion I should run or import first?

Thanks,

View Replies !

---

Seeking Testing Volunteers W2K MTS/DTC To VMS DECdtm Distributed 2PC Transactions
Hi,I am seeking the help of volunteers to test some software that I'vedeveloped which facilitates distributed two-phase commit transactions,encompassing any resource manager (e.g. SQL/Server or Oracle) controlled byMicrosoft's Distributed Transaction Coordinator in a Windows2000environment, with any resource manager under the control of DECdtm (e.g. Rdb(or Oracle via the XA Veneer)) in a VMS environment.[Yes, at some stage, I hope to sell this software and make money out of it,so unless you have a large philanthropic streak or are simply a techie wholikes to stay on top of Windows<->VMS connectivity issues, then you may wishto look away now. But if you do choose to participate, then rest assuredthat I have no interest in your personal or company details. (Just yourwork-rate :-)]What differentiates my Transaction Manager software from existingTransaction Monitor packages that are already in the marketplace (and whyyou should be interested) is that it is based on the Transaction InternetProtocol TIP standard. (RFC 2372) For those of you who don't know, thebeauty of TIP's "Two-Pipe" strategy is it's application-pipe (or middleware)neutrality. Whereas most XA implementations mandate homogenous TransactionMonitor deployments (such as Tuxedo everywhere, Encina everywhere, MQSerieseverywhere, ACMSxp everywhere and so on . . .), hotTIP from TIER3 Softwaregives you complete freedom to choose the middleware product(s) that bestsuite your particular application and heterogeneous network needs.Would you like to talk to VMS with TIER3 Sockets, COM or DCE/RPC? BEAMessageQ, IBM MQSeries or HTML? The choice is yours and yours alone. Butonce you realize that you need to encase your critical transactions withinthe ACID properties of a true Heterogeneous Two-Phase Commit then you willcome to the conclusion that you need a Transaction Manager that looks a lotlike this.Another drawback of traditional "One-Pipe" strategies is that they precludethe run-time determination of transaction participants. (Functionalitywhich may be advantageous in a wide-area or Internet based application.)Anyway, this is what I have: -On the Windows side, you need absolutely *NO* additional software! I'llreply to this note with a brief description of the COM+ and DTC functionsthat you would need to invoke in order to successfully push a MTS/DTCtransaction to VMS. NB: These are standard Windows APIs that are fullydocumented on MSDN.On the VMS side, I have a VMSINSTAL saveset that (all zipped up) is some150KB that I'm happy to e-mail to you along similar lines to the VMShobbyists (non-commercial use) license. I'll reply to this note with anInternet Daemon (INETd) example of code that uses my software to cedetransactional control, over an SQL insert into a Rdb database, to MTS/DTC.It's under 500 lines long and contains all of the DCL, 3GL, SQL required toproduce a working example of a TIP-2PC capable TCP/IP auxiliary server. Thisexample will insert a row into the MF_PERSONNEL.Employees table on the VMSside in co-operation with Windows2000 MTS/DTC client that is inserting a rowinto the NORTHWIND.Employee table. Commit them all or roll them all back.So, in summary, If you'd like to volunteer to put hotTIP through it's pacesthen simply reply to this mail.Regards Richard MaherPS. The following are a few functionality restrictions with the currentversion of my software that may effect your decision to participate: -1) Transaction has to be started/mastered/coordinated by W2K MTS/DTC2) Transactions cannot be PULLed from VMS and must be PUSHed from W2K3) No cluster-wide recovery.(If a txn falls over after being prepared then you have to wait for thatspecific node to become contactable again even though that lovely RDMrecovery job is sitting on another node protecting the database until myhotTIP TM tells it to commit or abort.)4) There is currently no Alpha or Itanium version available. The Alpha portis currently in progress but, for the time being, you'll either need a VAXor a VAX emulator on your PC.

View Replies !

---

Seeking MS SQL Server Users To Beta Test New Db Acceleration S/w
Lightning Data Technologies, a Virginia based technology company is looking for SQL Server users in the mid-atlantic area to be beta testers for its "RangeLightning" and "MultiLightning" products.
These products are based on patent pending technology that dramatically improves the performance of SQL Server (and other) databases for both ad hoc and scheduled queries and batch processing applications. Our internal benchmarks have shown orders of magnitude performance improvements in applicable implementations.
Lightning's technology resides between the SQL Server database and user applications. We are looking for beta testers with databases of at least 1 TB and who are willing to provide us with regular feedback for a term of at least 30 days. Lightning Data Technologies will provide a free evaluation license and free on site and telephone support for qualified testers. This is not a business solicitation
To be considered, please contact us with the subject line "beta" at info@lightningdatatech.com or call 703-582-3552.

For more information on our technology please download our white paper and technical overview PowerPoint presentation at http://www.lightningdatatech.com

View Replies !

---

Seeking Info On 2-node Active Passive Sql Setup
In desperate need of implementing a solution where the customer has purchased a CMS to replace their corporate site and wants to use MSSQL as the DB server type. I have 3 servers allocated to me to complete this and I could use some advice on the best setup.
THey're running windows 2003 standard server along with sql 2000 standard server. The intended plan is for the 2 servers to become web servers with the last server becoming the sql server. The CMS will reside soley on the sql server and the content for the web site on the seb server(s).
What I need to know is if it's possible to set up an active/passive node to accommadate this using the items mentioned above? From what I've been reading sql 2000 enterprise does clustering but I'm hoping this version of sql can be used for something.
Any responses are appreciated.

View Replies !

---

Seeking SQLServer 7.0 Courses/training Classes In Atlanta
Hi friends,
Just looking out to find out good training centers typically 5-day SQLServer courses offered in Atlanta, GA .

If you know any good courses that you come acroos, or tell me how to find out the information, I would appreciate a lot. My company is after me to get more expert training ( Been using 7.0 for 5 months).

Thanks for your help.
Shabu

View Replies !

---

Seeking Advice On Converting Crystal Reports To SSRS
Hi. We've decided to convert our Crystal Reports to SSRS 2005. We know (thanks to this forum) there are companies that will convert the reports at a cost; however, we'd like to undertake this ourselves. Are there resources you can point us to that might be specific for Crystal Reports users coming over to SSRS, especially for newbies? Thank you.

View Replies !

---

Horizontal Variety Seeking Association Rule Problem
I read somewhere that market basket analysis finds rules with substitutes as likely as rules with complements due to a consumer behavior called "horizontal variety seeking". This is when customers buy more than one product in the same category even though they are subsitutes. For example, when people go to the grocery store and buy soda, they buy coke and sprite at the same time even though they are substitutes of each other. I was wondering if anyone has experience with this anomaly and how they solved it. I found a time series model called the vector autoregressive model which is used to find the elasticity of prices over a time period. Does anyone have experience working with the VAR model? I am having trouble figuring out what some of the variables in the model are.

Below is the paper

http://www.feb.ugent.be/fac/research/WP/Papers/wp_04_262.pdf#search='VAR%20model%20market%20basket%20analysis'

 

View Replies !

---

Insert A Jpeg Into A Column Sql Server 2000 - Desperately Seeking Help
I'm a complete newbie. Need to insert a Company logo into a databasecolumn to use later on in a check printing application. Read how toinsert the pointer instead of the object into the column. Below iswhat I did:SET QUOTED_IDENTIFIER OFFGOINSERT INTO BankInfo(CoLogo) VALUES(0xFFFFFFFF)***Then I did this****DECLARE @Pointer_Value varbinary(16)Select @Pointer_Value = TEXTPTR(CoLogo)FROM BankInfoWHERE CMCo = '91'WRITETEXT BankInfo.CoLogo @Pointer_Value"\192.31.82.77DataCheckImagesWyattLogo.jpg"****This was straight out of a book and it seemed to work it gave me amessage that it was successful and when I view the data in the columnI can see the pointer0x453A5C436865636B496D616765735C57796174744C6F676F 2E6A7067*****But when I try to use the column in either Crytal Report or an AccessReport the Bank Logo does not show up. I also placed the logo on my Cdrive and tried pointing to it there with "C:WyattLogo.jpg" with nosuccess.It can't be this difficult to get a Company logo into a column. Idesperately need assistance. Remember I am the ultimate newbie. Ilooked at my first sql database last week. Thanks in advance for anyhelp, it is appreciated.

View Replies !

---

Seeking Correct Syntax To Pass A NULL Value For A Datetime Field From An Asp Page To SQL
Hello,I've been searching the web for quite some time to resolve the problemof "1/1/1900" returning in a datetime field in SQL that resulted from ablank (not NULL) value being passed to it through an ASP page.The solution is that a NULL value needs to passed to SQL from ASP.Thats fine...I understand the why the problem is happening and thesolution around it. HOWEVER, I can't seem to get the proper syntax towork in the ASP page. It seems no matter what I try the "1/1/1900"still results. Below are a few variations of the code that I havetried, with the key part being the first section. Does anyone have anysuggestions?!?!?______________cDateClosed = ""If(Request.Form("dateClosed")= "") ThencDateClosed = (NULL)end ifsql="UPDATE rfa SET "&_"dateClosed='"& cDateClosed &"', "&_"where rfaId='"& Request.Form("RFAID")&"'"_____________________________cDateClosed = ""If(Request.Form("dateClosed") <> "") ThencDateClosed = (NULL)end ifsql="UPDATE rfa SET "&_"dateClosed='"& cDateClosed &"', "&_"where rfaId='"& Request.Form("RFAID")&"'"_____________________________cDateClosed = ""If(Request.Form("dateClosed")= "") ThencDateClosed = NULLend ifsql="UPDATE rfa SET "&_"dateClosed='"& cDateClosed &"', "&_"where rfaId='"& Request.Form("RFAID")&"'"_______________Thanks in advance!!!!

View Replies !

---

SEEKING BASIC INFO ON SQLAgent - TSQL Jobstep Type Program_name(s)
 

I'm trying to ascertain how I can find out more about a particular job.
 
The information I have from a script I have to identify deadlock root causes gave me back this information:
spid 86 is blocking spid 51... spid 86 info:  SQLAgent - TSQL JobStep (Job 0xBAD836E3D331B44BA4CCAC400D244B17 : Step 1)
 
Well, that's good to know, but I would like to be able to identify the particular job that 'owns' TSQL JobStep (Job 0xBAD836E3D331B44BA4CCAC400D244B17 : Step 1).
 
I've read the BOL on the sysjob type tables; and, while they tell me about the columns in the tables and what they are, they tell me absolutely nothing about how one goes about figureing out what I want to know.
 
I suspect one problem I have is that '0xBAD836E3D331B44BA4CCAC400D244B17' needs converting to something else and I have no idea how to go about doing this.  I was never that good at converting hex (I assume that is what this is) when I was doing it rather often, which is years ago, so I really have no idea how to start.
 
Can anyone throw me a lifeline here?
Tia
randyvol

View Replies !

---

Seeking Both An Age From Birthdate And Nearest Birthdate Qry
I'm having a problem finding the nearest age. If the last bday is closer then the current age, if the next bday is closer then current age + 1 year. I'm familar with dateadd, datediff and datepart. Here's some psudo code...

declare @bday datetime ,@age int
set @bday = '01/26/1956'
set @thisdate = getdate()
set @age = case
when next @bday is closer than the past birthdate then age(@bday) + 1yr
when next @bday is farther than past @bday then age(@bday)
end

I know there is not an age() function, but that's part of what I'm looking for. I'm also stumped on getting the nearest age. What I had only worked for part of the year, prior to around June 15th, (183 days into the year)

TIA

JeffP...

View Replies !

---

Seeking Advice: SQL Server On Win 2008 Virtual Server Or Just Win 2008?
 

Hello - does anyone have experience w/SQL Server 2005 in a virtual environment? I'm considering this for a production environment but not sure if performance will suffer. Our databases will have a lot of writing but not too much reading. A SSRS solution is currently the only app. connecting to the SQL db. Max users to server at any given time will be very low (~10 users max). But the databases are pulling in data from other, outside multiple data sources on a daily basis.
 
Any pointers to documentation or any advice?
 
Thanks,
 
A Brown

View Replies !

---