Search results for query: *

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...

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 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...

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

I am writing a stored procedure whcih accepts 2 date input parameters @fromDate DATEIME @toDate DATEIME and returns a table of 3 columns DispayDate, fromDate, toDAte for example if @fromDate = '01/20/2010 @toDate = '03/15/2010 then the return table should look like DispayDate fromDate...

I have written this query wich is taking lots of time to run I have a table valued function which returns a list of id's I want to get recordset from table1 if @val_value is null then all records from table1 will be returned otherwise, only for those id's from the table function What will be...

SELECT parm.name AS Parameter, typ.name AS [Type] FROM sys.procedures sp JOIN sys.parameters parm ON sp.object_id = parm.object_id JOIN sys.types typ ON parm.system_type_id = typ.system_type_id WHERE sp.name = 'sp_test' I have written the above query to get...

I have stored procdures returning a recordset they basically look like this create proc1 select col1, col2, col3 from tbl1 create proc2 select col1, col2 from tbl2 I have more than 30 of them what I really want is how many records these procedures are returning; I don't want to go and...

I’m having problems importing csv files to SQL-Server. The csv-files are comma-delimited. and in one of the rows there is a comma in the data like Col1 col2 col3 aaa bbb ccc ddd eee fff gg,g hhh iii the third row has a problem importing the data because it has a...

we have more than 90 tables in our dataabase, most of the tables have colum called creaedUserID varchar(100); I am trying to get a unique creaeduserID value from those table having this column; Is there simple query to perform this Thanks

I have a parent table called tblUser which has UserID coulmn and this table has more than 50 child tables (each one have userID, createdDate as their column) I want to get the the latest created record for each table and the table the last record was created How can I achieve this Thanks

I have a package which extracts data from Access database to sql server I have one dataflow task which extacts data to 20 different tables (20 data flows) I want to create a log file where each data flows log their status after their run (each data flow logs to the same log file) in the...

I have a parent package and 5 children all stored in a database I am trying to use create SSIS package (parent) with a Foreach Loop container that will loop round the packages in the database, how can I accomplish this with foreach loop and execute package task; how can I set the foreach loop...

I don't know if this is the right place to post SSIS packages, but I know there are so brilliant guys in this forum to comment on this I have a parent SSIS package and its children; I want to make the connection string of the children package dynamic. so that the parent package passes the...

I am trying to extract data from interbase database through SSIS package; when trying to connect to the database it is failing. here is the message ( I am using the LCPI OLE DB provider) Test connection failed because of an error in initializing provider. Database connection failed. Unable to...

I am trying to generate some random data for one table this table; its parents are already populated can I generate random data for this table through data generation plan (database project) and get its foreign keys from the parent tables? Thanks

I have a query like select * from tbl1 t where exists (select 1 from tbl2 t2 where t2.id = t.id and t2.name = t.name) --this is taking time what would be the efficient way to rewrite this code Thanks,