Thanks Steve for a nice question.

Good question.Thanks for question Andy.

Nice one.Thanks for question Steve.

I guess you have posted it on wrong forum.

SQL_Novice23 (5/22/2014)

---

Certainly not a homework question. That was a long time ago. 🙂

I don't have any SQL to give at the moment.

I was just seeking ideas as to how...

huw.pickrell (5/22/2014)

---

I have a string that contains names delaminated by a '&'.

There can be any number of names in this field.

I want to exclude names that either have a (X)...

bbf.kurd (5/22/2014)

---

this code

Select filmtype , zhmara FROM query2,query3;

Result

why repeat data

i cant Join, Left Outer Join, Right Outer Join because

my query dont have id or id_fkey

just...

You can handle new line or carriage return at source (Stored Procedure) itself as suggested by Koen.

But still as you mentioned "SSIS Help with flat text file issues" suggests that...

Thanks for the question Steve.

However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in SQL...

Good question.Thanks for question Andy.

I have seen max 15 foreign keys per table in my database till now.

Absolutely right.If you do not ask, you will not get.But at the same time it is also true that sometimes we fear of loosing offer and quote less. 🙁

Nice question.One has to read the word optimal carefully 🙂

Thanks for question.

smart_analyst (5/14/2014)

---

Got an error ''DATEFROMPARTS' is not a recognized built-in function name.'

Yes I am summing up reading for monthly. I want data to be displayed monthly like for October...

smart_analyst (5/14/2014)

---

I want to aggregate to monthly values for the reading. I want to display Reading value for Oct 2010, November 2010 likewise My question is simple and I have...

Grass (5/14/2014)

---

Hi all,

I am trying to insert data from one table to another table which is easy. But i have two situations where first i have to load all the...