I saw they were linked, I wanted to know the logic that generated your final list. Thank you, now I have something to work with here.

tshad (5/12/2013)

---

Actually, that was a mistake that I fixed. Change the line "1 AS MonthPart" in CTE1 to "2 AS MonthPart".

I hadn't realized what the CTE was doing...

So, you want a single list in a variable the looks like this:

January, January, February, March, April, May, June, July, August, September, October, November, December

Why do you want January listed...

I have to ask again, please provide a step by step description of everything you have done, from setting up the mirror to testing the failover and what you have...

Can you explain the logic the takes the original data to the final results?

Would you please explain (and by that I mean show) what the output should be. I run your code and see what is generated, but I don't know what...

atheeth (5/12/2013)

---

Hello dear,

please tryout this . I assume from your query string is not limited to 2 commas .

Declare @strsql varchar(50),@chrindex int

set @strsql = 'AA,BB,C,D'

select @strsql --print original val

select...

Jeff Moden (5/10/2013)

---

I understand what the semi-colon can do so far as ending a statement but it worked just fine before without it before. I don't know what your...

Questions:

1) Are we talking Development or Production?

2) What rights are you requesting?

3) What are you doing that requires access to the databases?

4) What does the documentation say that you need...

Sorry, not enough info and even if I had a sandbox to play in not enough to even try to emulate your environment.

rick.servant (5/10/2013)

---

date1 >= 01/01/2013 --@STARTDATE

date1 <= 02/28/2013 --@ENDDATE

columns:

quote# date1 ...

SQLRNNR (5/10/2013)

---

Jeff Moden (5/10/2013)

---

SQLRNNR (5/10/2013)

---

Not a huge fan of the expected requirement of the semi-colon at the end of each statement.

They do come in handy occasionally to help distinguish the...

SQL_Enthusiast (5/10/2013)

---

Sorry Lynn

My COMMENT table (original table in DB) and TEMP_COMMENT are indentical in fields and data types. COMMENT has the FK on it while TEMP_COMMENT has no FK's or...

SQL_Enthusiast (5/10/2013)

---

Sorry Lynn

My COMMENT table (original table in DB) and TEMP_COMMENT are indentical in fields and data types. COMMENT has the FK on it while TEMP_COMMENT has no FK's or...

Neeraj Dwivedi (5/10/2013)

---

We use database mirroring ( high safety) for our HA needs.

Our application uses db_datareader & db_datawriter role for running the applications.

I had set up the application user account...