Too vague to be of any assistance. Can...

Sean Lange (4/29/2015)

---

andrew gothard (4/29/2015)

---

Sean Lange (4/28/2015)

---

Lynn Pettis (4/28/2015)

---

The OP just PMed me with all the info that had been posted on...

You haven't given us much to work on. How similar are the tables supposed to be?

BOR15K (4/24/2015)

---

...I have a list of flights - an itinerary with a request to find a final destination. The steps to find that final are as following:

1. Find the longest...

hemal_301080 (4/27/2015)

---

Igor Micev (4/27/2015)

---

Ok,

If you create an index on Lotno,Kapan and Position it should improve the selection in the where condition.

where Lotno=@Lotno

...

sql_novice_2007 (4/23/2015)

---

I have following strings in the full name field.

first,,

first,,last

,middle,last

I want to have the following results

first

first,last

middle,last

need to remove the unwanted , in the full name string.

How can I do...

Datetimes should be stored in your tables as datetimes, and are displayed in the SSMS grid control in the format you are now familiar with. You can display them in...

challakarthik (4/22/2015)

---

Hi Experts,

I have created a table Employee with Hire_date with datatype as datetime.Then inserted a row with date converted to style 109[ convert(varchar(30),'01-Jan-2013 12:00:00:000AM',109)

After I have inserted ,while retrieving...

peter-757102 (4/21/2015)

---

Even with some of the harsh feedback that comes with publishing I feel the need to write at least one article myself.

Certainly I owe many of the previous writers...

John Hick-456673 (4/20/2015)

---

Thank you, Jeff, and you, Jason. I've learned more from lurking on SSC than I did in my CS classes back in the day.

You two,...

Picket

MotivateMan1394 (4/15/2015)

---

I have a heavy database , More than 100 GB only for six month .

every Query on it takes me along time and I dont have enough space to...

You can explore the reasons why this query is performing poorly using a simplified model of your query - one of the EXIST subqueries.

Here's yours. The filter for postcode isn't...

josjonkmans (3/30/2015)

---

I did find a solution for the problem, I was using an SQL account for my linkedserver connections. When I changed it to use the "Be made using the...

Luis Cazares (3/27/2015)

---

In a different order of ideas, I want to share with you my happiness.

Starting on April 21st I'll be working in the US. I'll make a stop at...