You mean like the code I posted?

Eric M Russell (7/27/2015)

---

Sean Lange (7/27/2015)

---

Eric M Russell (7/27/2015)

---

SQL Server stored procedure calls can accomodate multi-valued input paramters, if that's what you're talking about here. By this, I mean you...

Eric M Russell (7/27/2015)

---

SQL Server stored procedure calls can accomodate multi-valued input paramters, if that's what you're talking about here. By this, I mean you can pass in a string...

I can only surmise that this is your blog that you are linking to.

abhishek_300 (7/27/2015)

---

How to get the last record value in sql server without using MAX/TOP clause?

Solution :

Using...

sqlinterset (7/27/2015)

---

Table1:

SELECT 1AS ID,'May-2014' AS date,7 AS I1

UNION ALL SELECT 1,'May-2014',4

UNION ALL SELECT 1,'May-2014',5

UNION ALL SELECT 1,'Jun- 2014',2

UNION ALL SELECT 1,'Oct-2014',1

UNION ALL SELECT 2,'Jan-2013',10;

Table2:

SELECT 1AS...

Jason A. Long (7/27/2015)

---

This should give you what you're looking for...

SELECT ID, [Date],0 AS T1, I1 FROM K1

UNION ALL

SELECT ID, [Date], T1, 0 AS I1 FROM K2

ORDER...

I can give you a real world example of where storing a delimited string made the most sense. This is something I built just a few months ago.

We have...

sqlinterset (7/27/2015)

---

I have below two tables

K1:

IDdate I1

11-May-147

11-May-144

11-May-145

1Jun-142

1Oct-141

2Jan-1310

K2:

IDdate T1

11-May-14300

1Jun-14400

1Jan-15100

1Apr-15200

1Oct-131000

3Jan-15600

I want a result table as:

IDdate ...

shamshad.ali (7/20/2015)

---

I need to search for such SPs in my database in which the queries for update a table contains where clause which uses non primary key while updating rows...

Ells (7/27/2015)

---

I have been using a VM with an evaluation version of SQL Server 2012 on there. The 180 days ran out. I tried adding two product keys but both...

Adam Sandler (7/27/2015)

---

I currently use access as FE to my sql db. My bog standard data entry edits/inserts etc are handled by bound access forms.

To move away from an...

Still on page 2 for me. 😛

Steve Jones - SSC Editor (7/24/2015)

---

Today is National Tequila Day in the US, so all speaker dinners should include that, perhaps with some Latin flavored food.

My kids have declined margaritas,...

michaelf.fitzpatrick (7/24/2015)

---

I'm surprised that somebody working in IT would use that argument. Face it, the question is poorly worded and ambiguous. Clarity is needed in the specification provided.

Because the question...

edwardwill (7/24/2015)

---

Sean Lange (7/24/2015)

---

Wow so much complaining about skipping a word in the question. I don't recognize most of the names of those complaining. I suspect that is because they...