Viewing 15 posts - 2,416 through 2,430 (of 2,647 total)
How are you pasting the data? A simple ctrl+v? Look at your other pasting options when right-clicking.
Thanks,
Jared
October 13, 2011 at 2:35 pm
xgcmcbain (10/13/2011)
jared-709193 (10/13/2011)
October 13, 2011 at 2:20 pm
Are you copying the information after exporting it, or are you exporting it to Excel? If the first... Then what format are you exporting it into?
Thanks,
Jared
October 13, 2011 at 2:17 pm
Also, going back to your very first question... It is not "checking" to see if it is null or not. It simply won't allow a null. It is not...
October 13, 2011 at 2:08 pm
xgcmcbain (10/13/2011)
Lynn Pettis (10/13/2011)
xgcmcbain (10/13/2011)
it will null, cause your implicity saying null, if i omit the column the default will fire
I think you are missing the point. If the...
October 13, 2011 at 2:02 pm
ramadesai108 (10/13/2011)
I found an example on BOL as Lynn stated and is working now. The first parameter to sp_executesql has to be Nvarchar and not varchar.Thanks.
Okay, but simplify it....
October 13, 2011 at 1:55 pm
The error is from referencing a parameter that does not exist (out of scope). The parameter does not exist in the dynamic SQL and cannot be global. You must...
October 13, 2011 at 1:43 pm
xgcmcbain (10/13/2011)
jared-709193 (10/13/2011)
xgcmcbain (10/13/2011)
enforcing not null is always good on a table, and peformance.
I'm not sure what you mean by this statement, but I want to make clear that enforcing...
October 13, 2011 at 1:41 pm
xgcmcbain (10/13/2011)
enforcing not null is always good on a table, and peformance.
I'm not sure what you mean by this statement, but I want to make clear that enforcing NOT NULL...
October 13, 2011 at 1:24 pm
tnk (10/13/2011)
October 13, 2011 at 1:13 pm
You will probably want to do a couple of joins to pivot the data so that your select looks more like this:
SELECT CommissionDate, Consultant, Disbursals, Target1, Target1 * 1.1 AS...
October 13, 2011 at 12:13 pm
This typically happens when 1 or more fields exceeds the width restriction. However, I find it easier with Excel to SELECT * FROM table and then highlight the results, copy...
October 12, 2011 at 2:42 pm
Take a look at the Edit Mappings and tell me what the data types and sizes you are trying to export are.
Thanks,
Jared
October 12, 2011 at 2:37 pm
Other thoughts... Have any changes been made to your audit table? Do any of the columns in the audit table have defaults? Are any of the columns set to...
October 12, 2011 at 2:11 pm
Is this the only known occurrence of this? How robust is your audit? I would say that it was not the stored procedure that did this, but something else that...
October 12, 2011 at 2:09 pm
Viewing 15 posts - 2,416 through 2,430 (of 2,647 total)