liorvikel (10/30/2016)

---

hey

i have link server to oracle from mssql.

i want to update or insert with four part.

1. how can i do it?

2. i read somewhere recommend to create...

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Welcome aboard. I must admit, I do use your posts...

spam reported

Lynn Pettis (10/25/2016)

---

jasona.work (10/25/2016)

---

Lynn Pettis (10/25/2016)

---

jasona.work (10/25/2016)

---

Brandie Tarvin (10/25/2016)

---

jasona.work (10/25/2016)

---

So this ought to be fun...

Dev asked me to take a look at a view that isn't performing as well as...

I see. Well be careful...

GrassHopper (10/21/2016)

---

I have scripts which I want to change all the letters to upper on it.

i.e.

Select * from MyTable where myVar = 'RED'

output:

SELECT * FROM MYTABLE WHERE...

Yes indeed. The website for our soccer club was down for about the half the day today. I kept receiving reports that...

g.powers (10/21/2016)

---

I recently had the same requirement and wrote a function which strips HTML tags and entities regardless of any additional information. I posted the code here at Stack Overflow...

coool_sweet (10/20/2016)

---

hi

i have table from where data is coming like this

price

12.345

345.6789

23.56

now i am taking this into tem table nd what i need is remove decimal and round the number...

Still kind of guessing here. I assume you have a table with the teachers in it that you could use for this. Since it is unclear I created a cte...

sindhupavani123 (10/18/2016)

---

Thank you.

Its quite close to what i expect

In your query 'left join #something s on s.day = d.NameOfDay

and s.name = 'Mary'' you are trying to retrieve data...

NineIron (10/18/2016)

---

This is the function to parse the parameter string. The parameters are doctors' full names that contain commas so, I need to use a pipe or semi colon or...

Pretty sparse on details here. I notice you are very new around here so I decided to help you out with some ddl and sample data so you can see...

harleen5102 (10/18/2016)

---

Hi,

I want to add string "@abc.com" next to the Employ_ref for each employee. What is the best way to do so?

USE tempdb

GO

CREATE TABLE [Staff](

[Surname] [nvarchar](255) NULL,

[Forename] [nvarchar](255) NULL,

[Employ_ref] [float]...

Grumpy DBA (10/18/2016)

---

Grant Fritchey (10/18/2016)

---

BLOB_EATER (10/18/2016)

---

Grant Fritchey (10/18/2016)

---

Wow, just read the comments on Reddit about a recent blog post... ouch.

Evidently stating the obvious when others are stating the opposite is...