Database

alotinhay[^].

If you are still struggling with this and have not had a response from mmtuts, then I suggest you post a question with the code that you have written (only the relevent bits). You are more likely to get help that way.

Very few software applications are forwards compatible, so what you are doing, 2012 => 2008 is probably not going to work. The error messages are probably invalid/random as there will almost certainly be a compatibility error in the package. Never underestimate the power of human stupidity RAH

You can't restore a backup from a higher version on a lower version. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

I am confused here because I thought it was a database question... well, it is a php and database question but there is no php section and I also am not sure how to copy and paste the sniptool because it shows that the information is not inserted into the database table but when using the query from the database, it does work... I have checked my sql query and I have got all the variables correct but am also including a multiple select option, where I have included name="subscription[]". Is this question clearer?

indian143 wrote: What I am asking is, are there any places that I can be suspicious of taking more time than normal. The usual things. Converting varchars to dates is a big timewaster, having magical numbers shows a design-flaw, and every function that is called on each value will slow the thing down fast. 8 Ways to Fine-tune your SQL Queries (for production databases) | Sisense[^] Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Which info do you need ? Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vimalsoft.com vuyiswa[at]vimalsoft.com

The comments still stand - there should be no reason to store the productname in a different table especially as it is user input and free form. Never underestimate the power of human stupidity RAH

Last tuesday I made a suggestion to you that would probably help you get assistance. CHill60 wrote: You might get a better response with some sample data and expected results You've given us the outputs but still haven't provided any sample data ... on the tables (or views) vw_ServicesXML5010, vq_ServiceFacilityXML5010, vw_OwnerXML5010 or dbo.vw_SDMCPhaseTwoParentLevelXML You have said that you don't understand how the two scripts are different, yet one of them is reading from vw_OwnerXML5010 but the other is reading from dbo.vw_SDMCPhaseTwoParentLevelXML having been given an alias of vw_OwnerXML5010. I suggest you start by comparing the output of the following sql commands SELECT * FROM vb_OwnerXML5010 and SELECT * FROM dbo.vw_SDMCPhaseTwoParentLevelXML introducing an appropriate WHERE clause to both. We can't help you any further without sample data.

I can understand by can you please help me how can I create dummy values for the views vw_ServicesXML5010, vw_ServiceFacilityXML5010, as those views are not fetching any records, the xml is not generating those elements, is it possible to help me in that regards. For example if I don't have any records for the View vw_ServicesXML5010 for that where condition I want to have empty value for the elements Procedure_Code, Modifier1, Modifier2, Modifier3, Modifier4, From_Date, To_Date, Revenue_Code, Place_Of_Service, Taxonomy_Code Same thing applies to the View: vw_ServiceFacilityXML5010, if it doesn't have any records then at least one record set with empty values for the Service_Facility_NPI, County_Owned_Indicator. Can you please help me buddy, thanks in advance. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Mycroft Holmes wrote: Has been deprecated in favour of Oracles ODP For having been deprecated for so many years (2009), it's getting an awful lot of updates. :) Mycroft Holmes wrote: I chased down a connection string that does not need tsnames.ora that works a treat. The content of the tnsnames.ora can be put in so many different places... Happy it works for you. Configuration of Oracle is admittedly a PITA. Me, I'm swearing over the locks in SQL Server and wishing myself back to the stability and performance of Oracle. :) Wrong is evil and must be defeated. - Jeff Ello

Member 13806085 wrote: Perform Write and Read as fast as possible using all the hardware resources. "As fast as possible" will take some experimenting and reading, will depend on your data-structure, indexes, triggers, and a bunch more - a bit much for a single forum-post. Member 13806085 wrote: I have configured Always On Read Routing, how can I test it? Check if the routing-URL is invoked and run a SQL-trace. Configure Read-Only Routing for an Availability Group (SQL Server) | Microsoft Docs[^] Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Hi friends, Its easy, create a Boolean or some other type variable, assign that value accordingly in the script task, then after the script task, you can have more than one Precedence Constraint Editor, in that, take the Evaluation Operation as either expression or expression and Constraint etc according to your needs then set the expression with your variable that you have assigned in the script task, now after the script task it will either continue with next steps or it will go to the task you have assigned after the failure constraint. This is all it is, thank you SSIS and thanks for all the friends who tried to help or support me. :) Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."

Cool, thanks for the link :) Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

You're welcome Wrong is evil and must be defeated. - Jeff Ello

Thank you very much that did it great, its a great help. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."