In SQL Server 2005, I have a table say tbl_Info. There I have one column say Info. The values are as under Name1 Age1 Sex1 Name2 Age2 Sex2 ….. ….. ….. And the row values goes on like this. My question is how to make row col transposition. The desired output will be Name Age […]
I used the wizard to build a package that loops through my tables does whatever. It has worked forever and now I have to change it. How on earth do I debug this thing? When I try to run it from bids, it opens InnerPackage.dtsx for editing and then asks me if I want to […]
We are moving our database server to a bigger box. I have several databases with full text indexes. What is the best way to move the full text indexes?
I have two tables both of which have columns StartDate and EndDate. I’m trying to return a single resultset that contains all date ranges from one table (TableA), and all complement date ranges from the other one (TableB). CREATE TABLE [dbo].[TableA]( [ID] [int] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NOT NULL ) CREATE […]
I’m new to XML world. I’m having a problem with XML data type in SQL Server 2005. I’ve a stored procedure that expects XML parameter. The value of the parameter as given below… DECLARE @productIds xml SET @productIds = ‘<ROOT> <AGENTLIST> <AGENT> <HOSTAPPLICATIONRECORDKEY>GRI</HOSTAPPLICATIONRECORDKEY> <BROKERID>02h21a0539</BROKERID> <BROKERSHARE>25</BROKERSHARE> <BROKERSTATE>AK</BROKERSTATE> <CARRIERCODE>GRIC</CARRIERCODE> <PLANCODE>EP02</PLANCODE> <COVERAGECODES> <COVERAGECODE>TL50IM06</COVERAGECODE> <COVERAGECODE>TL50IM10</COVERAGECODE> </COVERAGECODES> <SPLITBROKERID1>2</SPLITBROKERID1> <SPLITBROKERSHARE1>25</SPLITBROKERSHARE1> <SPLITBROKERID2></SPLITBROKERID2> […]
We are experiencing some difficulties with SQL Server performance and wanted some help. Our environment is: – Windows 2003 Enterprise x64 Edition R2 Intel E5450 Quad Core 3ghz Processor 16GB RAM SQL Server 2005 64bit Enterprise Edition (9.00.3282.00) Database compatibility is 8 (but tested on 9 as well) Hyperthreading is switched off We have one […]
I have single big table in Ms access 2k daabase and i need a way to copy this table and then populate my two already ready tables on sql server . I can use Migration tool but is there any way we can do it from Ms access like a form which executes the stored […]
I am developing an application in C#/WPF that requires a distributed data model, as it will have both online and offline access. My current thoughts are to develop the first version of the application against SQL Server express and LINQ to SQL. Then use the schema to create a SQL Express Compact DB (and modify […]
I need to set up a system which will allow developers to request an emergency ID for a database. They will be assigned to a role called ‘analyst’ which will provide them a drop down box with the databases they can gain access to. They will submit the request and a temporary SQL Login will […]
I’m looking at the Activity Monitor in SQL Server 2005 and when I double click a specific process to view the SQL I am given a blank screen. What does this mean? What could be causing this?