I am trying to accomplish this GrossMargin Sumof31000 Year Month 733747.10 x 2006 1 745466.90 x 2006 2 792383.03 x 2006 ...more >>

Is there a way do programmable get a Collation list from server? Tried this: [C# code] using Microsoft.SqlServer.Management.Smo; Server srv = ...; DataTable collations = srv.EnumCollations(); but it returns an empty DataTable, i wish to fetch it somehow. SELECT * FROM ::fn_helpcollat...more >>

How can I populate a variable in a stored procedure without returning the recordset from the exec statement? DECLARE @temp float DECLARE @rv int DECLARE @MyCursor CURSOR SET @MyCursor = CURSOR FAST_FORWARD FOR Select XOID FROM tblSalesOrder_XO WHERE SOID = @id OPEN @MyCursor FETCH NEXT ...more >>

In Sql Server Query Analyzer, to get a blank query window, it seems that I must first edit an existing stored procedure, at which point the "New window" button is enabled. Is there a way to get an empty window without first having to edit another query? If I launch Query Analyzer, I have an em...more >>

I am experiencing a large volume of deadlocks with a stored procedure I have written. The stored procedure only ever accesses one table. First it performs a couple of selects to check if a record exists or not and if it doesn't then it tries to insert it. Its on the insert that I get the de...more >>

Hi all, I want to copy data from one table and insert it into a view using Import/Export wizard. But the wizard is not showing me my view in the dropdown list for destination. So is this possible? If so, how? Thanks in advance. ...more >>

I am trying to find a query to count rows with multiple conditions. I have files which are suffixed with -R and then a number from 1 to 3 and then two digits 00-14. the field is char i.e.: -R101 -R102 -R114 -R201 -R302 I need to determine how many 101, how many 102, etc through 114 ...more >>

Hello, I am creating my first procedures in SQL using SQL 2005. I have 3 tables, with the following columns: Surveys - [SurveyId](PK) and [SurveyName] Questions - [SurveyId](FK), [SurveyQuestionId](PK) and [SurveyQuestion] Answers - [SurveyQuestionId](FK), [SurveyAnswerId](PK) and [Survey...more >>

Hi all, I'm using SQL Server 2000 and I have a strange problem with a temporary table I'm creating in a stored procedure. I use the following code: SELECT * INTO #TempTable FROM tblUsers ALTER TABLE #TempTable ADD RecPosition INTEGER IDENTITY This creates a copy of the tblUsers table an...more >>

Is there a way for me to globally select "Delete rows in destination table" when performing an export via the Export Wizard? It is not obviously visible to me, and I have a great deal of tables. I've been clicking "Edit" for each one, and this isnt practical for obvious reasons. Can anyo...more >>

Hi all, Does anyone know if it is possible to set identity seed using a = variable, and if not what is the alternative? I would not like to use = Dynamic SQL. I cannot get any of the following to work. For example, ---------------------------------------------------------------------- Declar...more >>

Here's what I'm trying to accomplish: Each record returned by a single select statement within a stored procedure must be sent as a parameter to another stored procedure, and a resultant field is to be added to a local variable for output in the first procedure. Something like: SELECT SU...more >>

I have a group table build like this: CustomerGroupId int CustomerGroupName nvarchar CustomerGroupParent int and a user table like this userId int userName nvarchar CustomerGroupId int .... now i've written a recursive query where i pass a groupId and i get all SubGroups WITH C...more >>

Hi All, I have a data file with delimiters that contains data for relational table. How can I populate these tables with the data file without writing much of code. The trick is these tables have Constraints PK, FK and identity fields. The ID From Table1 is the FK in Table2.... BCP with format ...more >>

Hi, how to find out what table, field contain "mysearchtext" in side? Thanks a lot. ...more >>

I need to have in my staff_rank table each staffname and region, but it's OK to have a duplicate staffNames as long as the region is different. Please note that, I can't correct the problem of the same staffName having additional entries with the same region code, there are good reasons this is...more >>

I am using the following code in a stored procedure to refresh a selected group of views (for which the underlying tables have changed): SET XACT_ABORT OFF EXECUTE @spErrNo = sp_refreshview @fullViewName IF @spErrNo <> 0 or @ERROR<> 0 PRINT 'ERROR: ('...more >>

I am trying to round values to the nearest $5. I work in the casino industry and we offer patrons cashback on thier play. Let's say someone earns $42 cash back. I need to send them an extra check for 25% rounded to the nearest $5. $42 * 25% = 10.5 which I need to round to $10 $53 * 25% ...more >>

Thanks, Charlie ...more >>

Thanks Charlie ...more >>

I've got a query where I have to find all messages for a particular topic, and then I need a count of all child messages for each message. Here's what I have so far: ALTER PROCEDURE [dbo].[udForumTopicMessageByForumTopicID] @ForumTopicID int AS SELECT A.ForumTopicMessageID AS "F...more >>

I have a vendor who uses sql server 2005 but we are currently using 2000 sp4. He has sent me a mdf, a ldf file and a bak file. I would like to get this on my ss2k server. What is the best way to do this? I've tried restoring the bak file but it tells me that there is a compatibility pro...more >>

I'm trying to find the distinction between Local temp tables vs. Global Temp Tables. Seem that Global temp tables have greater persistence when using a stored procedure with a returning select statement. Question: Are any of the #tempLocalTable or ##tempGlobalTable accessible from other ...more >>

I am utilizing the June 2005 PPEL and I am logging exceptions to a SQL Server 2000 database. In the PPEL installation there is a script named LoggingDatabse.sql that creates the necessary table and stored procedure. When I execute this script I am getting the following warning: Warning: The...more >>

Hi Have this code, http://code.doria.se/?c=21, that I found at CodeProject.com. (http://www.codeproject.com/cs/database/Trees_in_SQL_databases.asp) To the Node table I have added a IsActive column, that you can see is being used in the last query. select c.* from Node n, Tree t, Node ...more >>

Dear all, I can't work out with this query: declare @var char(20) set @var = 'look%' select name from table where field like @var No return rows when there is a lot Any input or advice would be very appreciated. -- Current location: Alicante (ES)...more >>

Hi, I have a database containing products, the tables of which are basically as follows: table_PRODUCTS -->(products may or may not have colours) table_PRODUCT_Colours -->(colours may or may not have sizes) table_PRODUCT_Colour_Sizes - The tables currently hold stock values at all 3...more >>

Hello, I've been asked to rebuild an app. The app in question is a real time stats engine. It uses C# to loop over each stat and send it to a SQL Server 2000 SP3 stored procedure. There the stat is parsed into it's different parts and stored in 15 different tables using UPDATE and INSERTs. ...more >>

I have some records in my Sql Db. There are some duplicate record in my email and adsoyad fields Email Adsoyad a@a.com Savas a@a.com Pele b@b.com Savas c@c.om Ilim d@d.com Hasan d@d.com Hasan I want to eliminate email address whic...more >>

HI all, If I hav a SP like CREATE PROCEDURE addclaim @ctkey int, @headerid int, @cpkey int, @brkref varchar(25), @DET varchar(100), @Status tinyint, @peril int, @cause int, @resc int, @fault int, @polsection int, @Assid int AS What is the best way to check that a value ...more >>