Hi guys, I want to create store procedure called "GetQueryPlan", CREATE PROCEDURE GetQueryPlan @Enabled INT=0 AS IF @Enabled=1 exec master.dbo.sp_executesql N'SET SHOWPLAN_TEXT ON ' ELSE exec master.dbo.sp_executesql N'SET SHOWPLAN_TEXT OFF' Howev...more >>

Hello, all. I have a student voting application on SQL Server 2000. Once everyone has finished voting, I need to display the results broken into the various categories (offices) and subcategories (sophomore, junior, ...). Here's the table that holds the votes, CREATE TABLE [Votes] ( [voterID...more >>

Given the 2 tables Sponsor and SponsorEvent with SponsorID on SponsorEvent as a FK >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> CREATE TABLE [dbo].[Sponsor] ( [SponsorID] [int] NOT NULL , [SponsorCode] [char] (15) NOT NULL , [BrandID] [int] NOT NULL , [FirstDate] [int] NOT NULL ) ON [PRIMA...more >>

Hi all, I want to calculate holidays for the next 10 years and store them in a table. Unfortunately a lot of holidays are defined as "the <nth> day of <Month>." Has anyone done this already, or can you point me to a website that describes how to do this before I re-invent the wheel? Th...more >>

What's the best way to avoid the problem of being off by a cent or 2 in money calculations due to internal floating point rounding? Does using the "money" datatype solve this alone? Do you need to use all "integer" data types insetad and handle displaying the data appropriately manually? I don't...more >>

I can't figure out I continually get a msg 7124 error using READTEXT. The script: DECLARE @TextfieldPtr varbinary(16) DECLARE @CommentsBytes int SELECT @TextfieldPtr = TEXTPTR(TextComments) FROM Comments WHERE CommentId = 25 SELECT @CommentsBytes = DATALENGTH(TextComments) FROM Comme...more >>

I have a table containing 65 fields. One of the fields is a varchar(6) field which is unique and contains a client number . witin the 64 other fields there are 10 'PIN number' fields ( PIN1, PIN2 etc ) and i need to check if a given pin exists ie check if '123456' exists in PIN1, PIN2 - PI...more >>

Hello, I was wondering if anyone had some insight into my problem. I'm running a trace and I want to generate a report to show some simple statistics about the duration, reads, and writes for the stored procedures in my database. I'm having trouble parsing the stored procedure name from ...more >>

Hi, Am trying to work out how to perform a query. I have a table which contains finance cost codes (tblCostCodes). I have another table that contains Customers and the Cost Codes used by that Customer (tblCustomerCostCodes) - they are related by the CostCode field. What I want is to be a...more >>

hi, I understand if the table structure is changed in terms of index and column, sp needs to be recompiled. is there anyway to tell if it is necessary to recompile the stored procedure. Thanks Ed...more >>

Using the following DLL ======================================================= CREATE TABLE [Test] ( [Job] [int] NULL , [Area] [int] NULL , [Town] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Road] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [AddressID] [in...more >>

Dear sir, Some times, some unimportant stored procedure on my application are using too much resource, etc 50% of CUP power. Is there a way to set the priority of a SP or limite the max resource it can use? thanks, Guoqi Zheng http://www.ureader.com...more >>

I have a char(10) column in a table, I would like to concatenate the string to a variable with coma's in between the strings. I currently use a cursor. Can any one think of a better way? -- Thanks, Jon A...more >>

I have two tables like this: 1. Transfer Table: TranID, TranDate, PlaceID,..., Amount 2. Place Table: PlaceID, PlaceName I am sending the money one place to another place, like that I will receive the money from their also and will update in one database. so need some unique identification....more >>