oscarooko (10/2/2012)

---

Eugene Elutin (10/2/2012)

---

Use XML FOR PATH method (it most likely will give you the best performance for T-SQL implementation):

declare @Table1 table (EmailAddress varchar(20), Msg varchar(20))

insert @Table1

...

in response to rf44 mammoth post..... what an effort. :w00t: ..I do hope that the OP will appreciate the effort that you must have put into...

Welsh Corgi (10/1/2012)

---

It is quite common in the Access world but I do not see any benefit in doing this.

I hear a lot of laughs when professional come across tables...

Hi Welsh...out of curiosity ....why "not a good practice"?

Hi Mike

take a look at this article by Jeff Moden...may give you a few ideas

http://www.sqlservercentral.com/articles/T-SQL/72503/

would you care to provide some set up scripts (create table / sample data) this will help us to clarify your question.

thanks

something along these lines......??

--=== this relies on a "numbers" or "tally" table

--=== http://www.sqlservercentral.com/articles/T-SQL/62867/ by Jeff Moden

; WITH CTE as

(

SELECT dbo.WIPMaster.WorksOrder ,

dbo.WIPMaster.Parent ,...

Chris Schmidt (9/27/2012)

---

I am working on a project to automate our end of month (EOM) reporting. There are multiple SQL's that get manually run and the results are manually...

yingchai (9/22/2012)

---

Hi SQL Gurus,

I have a below table with column names ACCOUNT, QTR1, QTR2, QTR3, QTR4

ACCOUNT QTR1 QTR2 QTR3 QTR4

-------------------------------

Opex 20 0 0 0

Sales 30 0 0 0

Costs 55 0...

If you are talking about formatting your code into a more readily readable layout then there are several "tools/addins" that will allow you to do this...along with allowing you to...

article here may help you:

http://blog.sqlauthority.com/2008/11/04/sql-server-fix-error-4064-cannot-open-user-default-database-login-failed-login-failed-for-user/

can you please provide some sample data...it would be helpful in understanding your problem

thanks

Hi

as a start, suggest you read the article below...it seems to be very clsoe to what you are asking and will explain the method far better than I can.

http://www.sqlservercentral.com/articles/T-SQL/88244/

if you...

really not sure if this is what you are after...but try it as a start and then we maybe improve

;with CTE as

(

SELECT OURID

FROM XTR

WHERE FACILITY IN(...

maybe this will give you some ideas

hope it helps

http://www.csharpest.net/?p=117