I just went for a generic POC...the concept should still apply. I am super-curious now about your comment regarding select * vs. a named column list. Please provide DDL, DML...

lgoolsby 86333 (7/7/2011)

---

This is exactly what I was trying but having...

Results from snippet for all combinations:

Table Query code_char len_code_char datalength_code_char @code_varchar len_@code_varchar ...

rapperson (7/7/2011)

---

I have a question about some strange behavior I've observed. I'll simplify things a little for this question, but the schema is actually quite a bit more complicated....

Post the actual execution plans for the proc exec when run by each user.

What's wrong with comparing it to the result of the function call you used to populate PERIOD?

CONVERT(VARCHAR(6), tableB.INV_SER_DTs, 112)

parissa_bakhshi (7/7/2011)

---

Actually we don\t have a SAN, but planning to buy an HP EVA if it supports this feature. You mean if I do a snap clone or local replication...

Settle down. We're just having some terminology challenges that's all. The configuration manager will show you all instances on the machine. Just because SharePoint services is installed on a machine...

Are you in the sysadmin Server Role in the Express instance? And is the Windows Service running the Express instance a local administrator? If yes to both then you may...

Many SANs have snapshot utilities that get can take a transaction-consistent snapshot of a SQL Server database and place it on a different volume just how you're wanting. VSS is...

Both are brilliant!

The string-based solution rocks...how simple!

I'll throw one more approach out there using XML just because it seemed interesting when I thought of it. There is a chance it...

davidsalazar01 (7/6/2011)

---

-- insert statement

INSERT INTO VimasProFast1

SELECT MONTH(dbo.MerInfo.addtosys) AS month,

...

Please post the new query you're trying.

You sure could. The only thing that may become apparent is that hobby_num is a value-add column that the UNION ALL method provides...

Bruce W Cassidy (7/6/2011)

---

opc.three (7/6/2011)The preferred way (in terms of performance) to do this now is to use Table-Valued Parameters (introduced in SQL 2008) to pass a set of data...