Viewing 15 posts - 10,006 through 10,020 (of 13,876 total)
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........
Please read the link. Here[/url]...
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
Right - I've never done that.
It might be worth creating another thread & posting your C# snippet, if it's not too complex.
April 3, 2013 at 8:56 am
rs80 (4/3/2013)
April 3, 2013 at 8:44 am
rs80 (4/3/2013)
Phil's approach is working. But when I try to run the package thru a batch job passing variables for the template path (source) and report...
April 3, 2013 at 8:22 am
Viewing 15 posts - 10,006 through 10,020 (of 13,876 total)