I created a stored procedure with table variable and inserted the values to the table variable and returned the table variable column and returns number of integer values.Now i need to select the records from a table depending on the returned result. ...
I am BI Manager on top of a SAP installation. I have a SAP DB which the SAP application writes data to. In order to get an environment to query without loading on the sap, I have mirrored the SAP DB on a server, and it works fine. Each night I do a full load of data, and it works fine for now. I know that somewhere down the line, I will...
Hi all, I have a table which hold multiple languages(English, French, Arabic, German). I also have full text index on the table. I also have two meta date fields that are independent of the languages. So for all the languages I need to query these fields. I have kept the meta data field as language neutral. But when I query the index us...
Hi all, I have a master table and a details table. On delete cascade is not specified. I want delete child record as well as master record in a single query. Suppose I want to delete EmployeeDetails and Employee record where EmpID=20 using a single query. Is it possible? Please help. ...
I have data like this. Following is the sample data. I want to get all those CustomerIDs which has date diff of 2 hours in DateCreated of Enquiry. For example CustomerId 10602 has 3 enquiries . If the time difference is 2 hours in any of these three enquiries then this CustomerId should be in my result set. Same for the other Custome...
Hey I have some temp tables which hold data and then gets deleted after. I was just checking the size of these tables and eventough they currently have 0 records in them they are very large in size. SQL 2005 DB How Can I reduce the size of these tables ? ...
Here are the two designs I have : (I'm using SQL Server 2005) Constellation Schema : http://img84.imageshack.us/img84/7206/constellation.jpg Star Schema : http://img692.imageshack.us/img692/971/starme.jpg I need to build a report which shows ProjectID,ProjectName,Hours,isImpacted,isRequesting for a given line of business(LO...
I am trying to copy all the tables and views from a database on SQL Server 2005 to a database on SQL Server 2008 using the Import data wizard, but after running for some time it just copied 230 tables from 570 tables and views and gave the following warning. Warning 0x80019002: Data Flow Task 46: SSIS Warning Code DTS_W_MAXIMUMERRORC...
I have a TSQL Table-Valued Function and it is complex. I want to ensure that one of the parameters cannot be null. Yet, when I specify NOT NULL after my parameter declaration I am presented with SQL errors. Is it possible to prevent a parameter of a Table-Valued Function to be assigned null by the calling SQL? ...
Hi, I have the following data: cust subject date Cust1 Subject1 2010-12-31 21:59:59.000 Cust1 Subject1 2010-12-31 21:59:59.000 Cust4 Subject3 2011-02-27 21:59:59.000 Cust5 Subject1 2010-10-31 21:59:59.000 Cust5 Subject2 2010-10-31 21:59:59.000 Cust6 Subject2 2010-10-31 21:59:59.000 Cust6 Subject2 2010-12-31 21:59:59.000 I need to a...
Most questions I've seen on similar subjects relate to how to speed up inserts into a table. I want to know what can I do to speed up deletes? I can't truncate nor drop a table, I have to do something similar to DELETE FROM table WHERE id IN (SELECT id FROM other_table) ...
In activity monitor the process details shown as ] "SET TRANSACTION ISOLATION LEVEL READ COMMITTED;BEGIN TRANSACTION".what does it means? ...
Dear Friends How can i retrive the SQL Server startup parameter using SQL Query?? Plz help me Thanks in advance ...
I need to compare 2 strings in sql so that the word "iast" would be equal to "îăşţ" anybody knows how to do this ? ...
Hi Guys, I have one table in that they are four coumns like startdate varchar(15), enddate varchar(15), starttime varchar(15), endtime varchar(15) Here I need to get the time in hours between these two dates (ex: 6/7/2010,6/12/2010) if i pass these days as inputs regards, ravi ...
Hi guys, Here i want to transfer data from one database to another database in sql 2005, i tried in dts but its not working. ...
I am getting the following error when I am trying to copy database and it's getting stopped at this point. Error 0xc0047008: Data Flow Task 46: The package contains two objects with the duplicate name of "output column "ErrorCode" (720)" and "output column "ErrorCode" (737)". Warning 0x80019002: Data Flow Task 46: SSIS Warning Code DTS...
Is there a way to determine how much disk space is used by an Indexed/Materialized View? ...
I have a lengthy stored procedure in which I would like to do something like the following: IF @SubPageDirectory IS NULL BEGIN RAISERROR('@SubPageDirectory cannot be NULL', 10, 1) EXIT STORED PROCEDURE END Basically I wish to check whether my variable is NULL, and if it is, return an error message to my .NET Web Application, a...
Hi, data mapping exercise approaches (3000+ tables) and I can get table names out (thanks to previous Stack Overflow answer) but is there easy way to get all table & view names and their associated columns, ideally with foreign and primary keys noted? Newbie here so answers need to be be very simple please! Many thanks, Jules. ...