ScottPletcher (4/23/2015)

---

Lynn Pettis (4/23/2015)

---

ScottPletcher (4/23/2015)

---

Lynn Pettis (4/23/2015)

---

CELKO (4/22/2015)

---

Please read any book on basic data modelling and look at...

Something like,

CREATE TABLE #ids(id int, codes varchar(30))

CREATE TABLE #codes(code varchar(30), descript varchar(30))

INSERT INTO #ids VALUES(1, 'Code1,Code2,Code3')

INSERT INTO #ids VALUES(2, 'Code1,Code2')

INSERT INTO #ids VALUES(3, 'Code3')

INSERT INTO #codes VALUES('Code1', 'Description1'), ('Code2',...

What do you mean by manual column, is that a column in excel or a column from the query you are running?

You can set excel to automatically refresh every X minutes.

When you say that do you mean when you try to copy...

Why don't you disconnect their session when you change a users access to sensitive data, that should remove any temp tables they've created.

Well is your goal just to get rid of the data in the table or do you have a reason you need to capture errors when deleting row by row?

This is a forum, not a help desk ticketing system, just throwing that out there.

Something like?

DECLARE @table_name varchar(50),

@create_sql varchar(1000),

@insert_sql varchar(1000)

SET @table_name = 'TEST_DATE_' + CONVERT(varchar, getdate(), 112)

SET @create_sql = 'CREATE TABLE ' + @table_name + '(col_one datetime)'

SET @insert_sql = 'INSERT INTO ' +...

Be sure your server doesn't support adding memory by restarting itself if you go down that route 🙂

As far as I know it's based on the number of physical cores running some form of SQL Server component regardless of how many or which mix of components or...

mw112009 (4/6/2015)

---

Thx, it worked.

However when I paste the results in EXCEL the entire string got converted to some numbers ...

Hmm that is outside of this forum but a reply would...

My favorite was coming across a system that...

Are you sure the problem is the compiled execution plan and not just a problem with the code down the slower branch?

Let's be honest requiring statement terminators is to make life easier on the developers writing the syntax parser not because there is any inherent value in a ;