domingo.sqlservercentral (3/18/2014)
J Livingston SQL (3/17/2014)
sample data would help us help you....do you know how to provide this?
No, I don't know. Do you mean about upload of database backup file? Or that I write you a script for generating sample base properly for the query I asked?
This just means that in order to help you it is best to provide some code and data that can help them recreate the problem and craft an answer.
You might do something like this:
<YOUR PROBLEM DEFINITION>
Blah blah
<SAMPLE DDL AND DATA>
CREATE TABLE #tmp(myfirstcol SMALLINT, mysecondcol SMALLINT);
INSERT #tmp(myfirstcol,
mysecondcol)
SELECT 1,2
<CURRENT RESULTS>
SELECT * FROM #tmp;
myfirstcol mysecondcol
12
<EXPECTED RESULTS>
mycol
1
2
Obviously, in your case you will need to provide ddl and data that accurately reflects your problem.