Sorry Guys just a misunderstanding ..

now...

how it works as looping ?? how it go through all of the commas ?

twin.devil (3/5/2014)

---

It a very simple replace working. to split a comma separated data into a table. 🙂

Let break it down for understanding

Replace Function Definition Replaces all occurrences of a...

Could you assist me to create custom audit ?

hunchback (2/12/2014)

---

The UNION approach is completely different from the other suggestions based on your initial requirement.

The previous suggestions are constraining that a row in the referencing table should exist in...

I have done the above by using the following, but it costs much.

create table sample(id int primary key)

create table sample2(id int primary key)

create view sampleall

As

select id from sample

union

select...

GilaMonster (2/12/2014)

---

Yup, perfectly possible. It's not one foreign key though, it's two foreign keys, one referencing each of the tables

CREATE TABLE sample1(id INT PRIMARY KEY)

CREATE TABLE sample2(id INT PRIMARY KEY)

CREATE...

Lowell (1/29/2014)

---

great job posting sample data! post slike this make me want to help!

here's an example of a set based operation using a well know technique with FOR XML;

the STUFF...

This is other party table.. we do have only select permission ( even my DBA also).

Is there any other way to perform this?

Exactly! but I cant find any efficient way... help me out...

John Mitchell-245523 (1/17/2014)

---

You still haven't shown us what you've tried. But from your required results, it looks as if you need a PIVOT query. If you search for...

I did this in a very complex way..

steps :

1. created columns for every month

2. update corresponding month column...

Jeff Moden (1/4/2014)

---

To be honest, whomever designed the table with an integer representation of year and month did a great disservice to anyone and everyone using the table and it's...

Jeff Moden (12/21/2013)

---

bitbucket-25253 (12/21/2013)

---

In the left most column of a this page, as you read my response click on the word Stairways and you will be rewarded with a...

Thanks Guys... thanks for your assistance ....

Really helpful... and awesome.