I have a problem with SSIS, could you please let me know which forum i should post my questions. Thank you, Mattie
Hi, I have a question please in a AFTER INSERT,UPDATE trigger. Can this trigger have delete statement in it. what i am trying to do is what ever...
Thank you so much. Mattie
Hi, I checked books online, and thanks for the tip on @@Trancount Satya but i am not sure how to make it work for what i need. What I am trying to...
I will do that. Thank you, Mattie
Hi, I am trying to compare transaction between same db on 2 diff servers. I am trying to count transaction and what is the most effective way to...
Hey, I am trying to create a stor proc for a 12 month billing report. Lets say if i am running it in Mar '07 i need it to show all the months from...
Thank you so much for all your help used this and it works StopDate > dateadd(day, datediff(day, 0, getdate()), 0) Mattie
Hey, Lets say i have a StopDate and Getdate. eg1. 07/31/2007 03/08/2007 eg2. 01/31/2007 03/08/2007 I need to find out...
Hey Guys, I found out the report works but the i get warnings in Microsoft Visual Studio when i check in the report, it does not seem to recognize...
Hey, I need your help please. I havent done Triggers much. I need to write CREate trigger for after insert ,Update. Lets say i have table A with...
Hey, Its working now. I have no idea why it would not work the first time. Thank you soo much for your help. Mattie
Hey, I tried it does not work. Thank you, Mattie
Hey, I am trying to create a report with a stor procedure. the problem i have is this stor proc has some #temp tables that i have created to get to...
Hey, I need to find the previous month of a date thats been provided. eg. Jan 7th 2007 (was provided) Dec 2006 should be the answer. Thank...
Hey, Is there a way to bring in data from two diff data sources in a single report. Thank you, Mattie
Hey, I am new to this I created a matrix report, what i need to do is for the Totals i need that row to have a diff col. How would i do this. If...
Thank you soo much Adrian , I am going to try that. Frank I hope this helps. Attached you will find the documentation regarding the three tables....
Separate names with a comma.
