Hi, I am looking to aggregate values for all versions of a slowly changing dimension. Here is a simplified explanation of the problem. I have a Product dimension and this dimension has an attribute called ProductGroup. Products from time to time change ProductGroups. The Product dimension is a slowly changing dimension, and the ch...
Simple problem. I'm working on a Delphi 2007/WIN32 application which now uses MS Access as simple data store. I have to modify it to support SQL Server Express, which is easy. These modifications are working so the application can be deployed using either SQL Server or MS Access. (Whatever the user prefers.) I did consider deploying the ...
Hi All, How to pass array as parameter to a Store Procedure in SQL Server 2005, i this is not possible SQL server 2000, so we pass comma separated values in past. any help appreciated ...
I want to optimize this query WITH CTE AS ( SELECT KladrItemName _KladrItemName , WordPositionKladrItem _WordPositionKladrItem , WordPositionAddressString _WordPositionAddressString , StartPosition _StartPosition , EndPosition _EndPosition , Metric _Metric , IsConstruction ...
Is there a dependable way to find dependencies among views and tables in SQL Server 2005? sys.sql_dependencies doesn't list all of my dependencies. (I thought I saw a similar thread here but can't find it now. Sorry if this is a dup). ...
I have a table with columns - id, x1, x2, x3,x4 if i have values 1,y,y,y,y 2,y,null,n,null 3,y,null,null,null then say, i want to calculate (1)/(number of y's) and display rows as 1,.25,.25,.25,.25 2,1,0,0,0 3,1,0,0,0 Is it possible to do this using sql query? ...
Hello all! I have a quote that contains items (store in table QuoteItem): QuoteItemId, QuoteId, ItemId, Quantity etc. Now, I need to be able to create a group of chosen items in the quote and apply a discount on it. Well that's simple, I create two more tables: Group: GroupId, DiscountPercentage GroupQuoteItem: GroupId, QuoteItemId ...
I'm having some problems with the following Query: SELECT v.idnum ,v.full_name ,convert(varbinary(max),s.signature) as Sig FROM AppDB.dbo.v_People1 AS v INNER JOIN OtherDB.dbo.Signatures AS s ON v.idnum = s.idnum UNION SELECT v.idnum , v.full_name , convert(varbinary(max), s.signatu...
Hi, I'm currently trying to create FULLTEXT indexes into my database (Microsoft SQL Server 2005). First I want to create the catalog: USE [AspDotNetStorefront] GO EXEC sp_fulltext_database 'enable' GO CREATE FULLTEXT CATALOG searchcatalog GO But that doesn't work, the result is this: Msg 7609, Level 17, State 100, Line 1 Full-Text...
In my apps I typically use the Enterprise Library Data Block to simplify my database interactions. C# code such as: public static IDataReader AdminNavigation_Insert(int iGroupId, string sText, string sRelativeUrl, int iSortOrder) { return DatabaseFactory.CreateDatabase("database").ExecuteReader( "cms_uspAdminNavigation_Inser...
I recently developed an SSIS package on my dev machine using the 2008 version. Later I foud the customer had Sql server 2005 and doesn't plan to upgrade anytime soon. Is there a way to turn the 2008 package into a SSIS 2005 package, like a downgrade wizard? ...
Hi All, I have a string Variable test=HARIA|123|MALE|STUDENT|HOUSEWIFE i am using | as delimited character. if i want to extract data from 2nd occurence of pipe till 3rd occurrence. i need to get 'MALE' from above string. any help appreciated ...
I need to provide management with proof that a group of existing stored procedures that use cursors are the cause of much of our performance issues. Can someone point me in the right direction to find scripts and queries to accomplish this, please? Such as, how to monitor and measure cursors, etc. Using SQL Server 2005. Thanks. ====...
How to implement Publishing subscriber Replication topology in SQL? ...
declare @top int set @top = 5 select top @top * from tablename Is it possible? Or any idea for such a logic (i don't want to use dynamic query)? ...
I have an old database that I am inheriting. The access rights are not clearly defined anywhere and I'm looking for a quick way to get them for everyone. Let's say I have a user in my database that does not belong to any membership roles. However, they have been given access to do specific things to specific tables. For example, they can...
I've used a table valued parameter before, but I'm not sure how to use xml. I do not know the best way to format my xml but I think I would try this: <Car> <Name>BMW</Name> <Color>Red</Color> </Car> Then I would pass the xml (one or more car) to the stored procedure and it would insert one row for each car I pass (with ...
Hello, I'm calling a stored procedure from C# .net and one of the string parameters is null. When that is the case, I pass DBNull.Value. However, I get the above error. Any ideas? ...
I'm trying to delete a user's schema from a database and I'm getting the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for Schema 'ext_owner'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&...
I'd like to extract data from a .csv file. I cannot use OpenRowSet on a 64-bit machine because it says: Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "MSDASQL" has not been registered. and there is no MSDASQL entry in the Linked Servers -> Providers section of the SQL Server 2005 SSMS the same way 32-bit ones have. Can som...