Viewing 15 posts - 10,006 through 10,020 (of 13,879 total)
rajeshk 36156 (4/8/2013)
"CWBZZ5014 Value of parameter columnName could not be converted to the host data type."."CWBNL0107 - Converted 80 bytes, 2 errors found beginning at...
April 8, 2013 at 6:51 am
What is the text of the error message?
April 8, 2013 at 6:28 am
It should work. Have you tried setting a pre-execute breakpoint on the task to ensure that the value in the variable is exactly what you are expecting?
April 8, 2013 at 4:22 am
This is not easy without knowing more about your data and table structures.
Please follow the link in my signature to see how to post easily consumable DDL and sample data.
April 8, 2013 at 3:13 am
Could the fact that 'Destination' is spelt incorrectly in the following be a factor, or is it just a typing error?
"Access to the path 'D:\Destinaion' is denied."."
April 8, 2013 at 1:39 am
Shadab Shah (4/7/2013)
Scott Thornton-407727 (11/9/2011)
wow, that worked.I had no idea you could use Alias's in the UPDATE clause.
Thanks!
Hi experts,
This solution is working for me as a butter on a hot...
April 8, 2013 at 1:17 am
TheSQLGuru (4/6/2013)
Please put the stuff up as a TEXT document. I don't download files that can run code. :hehe:
Word's .docx files cannot run code, as far as I know...
April 7, 2013 at 9:02 am
Saying that something "isn't working" is not that helpful.
More useful is if you post error messages or expected behaviour vs actual behaviour.
April 5, 2013 at 8:55 am
Surely dogs speak Doggish? 😀
Yep, please excuse me: it's Friday afternoon and nearly beer time.
April 5, 2013 at 7:38 am
andrewalex.r (4/5/2013)
MY employee Table contain CREATE TABLE EmployeeTable(ID INT IDENTITY NOT NULL PRIMARY KEY,Department_ID INT,Employee_Name VARCHAR(100),Designation VARCHAR(100),Salary BIGINT,DOJ DATETIME)
I think these r the requirments u need........
April 5, 2013 at 4:03 am
andrewalex.r (4/5/2013)
By using Trigger i need to get the sum(salary) of Employee's from employee table,on tanother table,send me the code
How can any human who lacks supernatural powers provide code for...
April 5, 2013 at 3:33 am
Paul Hernández (4/4/2013)
Now I'm trying to persuade my colleagues to go directly to the database and not over the web service. They allege that write...
April 4, 2013 at 6:59 am
Can you get to the database directly, or do you have to use the web service method?
April 4, 2013 at 5:49 am
natalirozin (4/3/2013)
Obviously , "WHEN NOT MATCHED BY SOURCE THEN DELETE" behaves as designed clearly...
April 3, 2013 at 9:31 am
It is good to use subset of the source table, considering that you don't need the whole table content.
I don't understand what you mean - please elucidate.
April 3, 2013 at 8:57 am
Viewing 15 posts - 10,006 through 10,020 (of 13,879 total)