Viewing 15 posts - 10,006 through 10,020 (of 13,874 total)
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
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
No, please don't get me wrong. I said all with humor!
chill
Oops! Glad to hear it. Time I visited the coffee machine for some additional humour-spotting beverage :hehe:
April 3, 2013 at 4:09 am
shalinder.verma (4/3/2013)
April 3, 2013 at 3:29 am
Viewing 15 posts - 10,006 through 10,020 (of 13,874 total)