Yes, it is the only instance on the server and that is what puzzles me. Every time I changed port, it created sp17s server as shown in the output...

I totally agree with you. Initially they were all Stored Procedures. I changed them to functions as I can't really do EXEC in select query unless I write...

I may not have conveyed my question properly. This is how I achieved my solution. I understand my code references tbl and fn but I have to...

This question tested more of my English understanding rather than the actual problem. Question should have been expanded. A quick read by anybody would consider syntax errors also.

Sean Lange (10/28/2015)

---

sarath.tata (10/28/2015)

---

So many questions... This could be achieved with this query... The mistake i did was putting same number in person id for everyone (copy / paste issue)....

So many questions... This could be achieved with this query... The mistake i did was putting same number in person id for everyone (copy / paste issue). There can...

P Jones (7/29/2015)

---

Because SSIS (2008) only writes to one system table we decided to write our package logs to flat files on the database server then add a step to...

Alvin Ramard (7/23/2015)

---

sarath.tata (7/23/2015)

---

Yes, I selected SSIS log provider for SQL Server and selected an OLEDB connection for configuration, selected Events to be logged. But, I'm not sure where...

Yes, I selected SSIS log provider for SQL Server and selected an OLEDB connection for configuration, selected Events to be logged. But, I'm not sure where to look for...

I have implemented Package Logging in my SSIS package and executed it. Can you please advise where I can see the results stored? I thought it might be creating...

No doubt, it is the best community of SQL 🙂

Well, Yes, I agree!! I am working on data migration where I saw this pattern. I'm fixing this to have clean data in my new DB. I would like...

Alvin Ramard (6/2/2015)

---

I know of any simple way to do what you're asking without using REPLACE.

FYI, using REPLACE with the format you gave looks pretty simple:

REPLACE(REPLACE(REPLACE(REPLACE(PhoneNumber, '(',...

A solution from a guy:

SELECT DeptName, PersonName, StartDate, EndDate

FROM (

SELECT DeptName, PersonName,

ROW_NUMBER() OVER (PARTITION BY DeptName

...

Sean Lange (5/29/2015)

---

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

Your question is not at all clear. What would be helpful is if you could post ddl and sample data in addition...