Search results for query: *

Thanks guys for the responses. So I am using the visual studio 2012 Data compare tool to do my data compare. And it works out perfect for me. Now the next step is how to merge the data. I am generating all the DML scripts (Insert or update), but couldn't run this scripts because of the...

Hi everyone, I have this task to compete it within a week, and need some idea how to start it. we have 2 databases with identical schema objects, and 90% data. we are in the process of merging the two databases. So I want to compare the data in the tables (column by column) and find what data is...

Thanks, George it indeed reduced the time. I face a tricky situation, what if the variable is 2 or more? declare @id varchar(max), @name varchar(max) set @id = '1, 2, 3, 4, 5' set @name = 'Washington, Jefferson, Lincoln' select * from table1 where (@id is null or exists (select 1 from...

I have this query and taking long time to execute declare @id varchar(max) set @id = '1, 2, 3, 4, 5' select * from table1 where @id is null or exists (select 1 from split_fun(@id) where id = table1.id) could you suggest better way to write it

I tryed cte and recursive cte but not able to resolve it, I am forwarding it to the gurus of tek-tips

site 1 has minimum date Aug 2011 and maximum date of Nov 2011, so we fill out the missing dates between the two Sep 2011 and Oct 2011 Thanks

that was by mistake should have been 2009 --first recordset SiteID ProtocolID Month Year PatientCount 1 2 Aug 2011 3 1 2 Nov 2011 2 2 3 Jul 2010 1 2 3 Aug...

I have a recordset like this SiteID ProtocolID Month Year PatientCount 1 2 Aug 2011 3 1 2 Nov 2011 2 2 3 Jul 2010 1 2 3 Aug 2010 3 3 4...

perfect Thanks very much Lodlaiden

I have 15 columns in the table and equating each coulmn is a bit hard, I was checking if we have any built-in function Thanks

How do I check if all columns in a single row have same value (COALESCE kind of function) but in this case all column same value foe example COL1 COl2 1 1 2 3 4 4 my result set should return COL1 COl2 1 1 4 4 Thanks

Hi, We have started using the VS2010 Unit test, and have some question on the data checksome test condition, I have created a script via the configuration property and it calcuates the checksome value my question is, is this value always fixed or does it change based on recordset change? the...

I have 32 data flow tasks which are running same time; I want to get rowcount for each data flow and update it to a table. my problem is I have to define 32 variables to write the rowcount on whcih I am not happy with; Is there a better way to define one variable and get all the counts without...

I am trying to bring oracle database to sql server 2008 there are about 50 table to bring in verbatim is there a migration tool build into sql server 2008 to do this instead of creating SSIS package which pumps the data? Thanks

Thanks, it is perfect

The thing is The Number of months varies, it could be 1 or 2 or 5 or 10 but max is 60, our report is for max 5 years how can we dynamically change base on the columns Thanks again

I tryed the dynamic pivot, my problem was how can I include the column names as resultset as well please look at what the report should look like Report Month1 Month2 SubmissionType JAN-10 FEB-10 Initial 64 47 Amendment 32 63 Thanks...

Hello all, I have a follow up question if you guys don't mind I am trying to creat a report for a client I have this Resultset SubmissionType DisplayDate SubmissionCount Initial JAN-10 64 Initial FEB-10 47 Amendment JAN-10 32 Amendment...

Thank you Markros, it works for me

Are we always talking about 3 months or could it be 1 month or 6 months? it could be any month 1 0r 3 or any