Hi I have percentages that sums to 100%, but the business people wants to show the percentages with one decimal only. I understand why some numbers are rounded up, others down and why they don’t always add up to 100% afterwards. Does anyone have any good suggestions for a rounding algorithm ...more >>

Hello I have to log some data and I'm trying to figure out the best way to store the data. As the database I will be using MSSQL express and disk space used by the database is a big concern of mine. The application is made in .Net. Here is a bit info about the data I will be logging: 1) Da...more >>

In a web page, the user can start a long query on SQL server. How can I stop the query if its taking too long? ...more >>

Hi All, I have a cursor that compares rows and applies business rules (in cursor), but it is very slow, because of large number of rows. What would be the best approach for this scenario (row-by-row processing)? GO /****** Object: StoredProcedure [dbo].[usp_sessionization] Script Dat...more >>

I have a Case Statement that almost works. I have marked the troublesome pseudo portion with [[ around my desired outcome ]] CASE WHEN EXISTS (SELECT * FROM tbl_DelSup WHERE DelID = purchasing_reg.tbl_delega...more >>

I have an application which needs to work in French & English. Now the actual .Net application handles this in the code, but I need to handle it as I create the data warehouse. All column headings need to be in the language of choice. Data is not affected. Any thought on how I could do this?...more >>

hi all can anybody tell me where i am doing mistake in this query :- SELECT logUpdate.author, logUpdate.dateAdded, logUpdate.dateEdited, logUpdate.effectiveDate = select logUpdate.effectiveDate FROM logUpdate WHERE (effectiveDate BETWEEN CONVERT(DATETIME, '" & txtFromEffective.Text & ...more >>

Is it possible to create an index on a table type variable? If so, is it limited to Primary or Unique type? The column I need an index on would not contain unique data. Thanks. ...more >>

Hi all, I've been trying to figure out if there's a way to write a set based query statement that does this Compare record 1 against record 2 on a criteria and based on these 2 values Example: Key Column1 Column2 a test 1 a test2 2 b test3 3 I want to write a query ...more >>

Need help with the SELECT statement Hi all, I am get stuck with the queries below. Please see the requirements describe below and help me correct the sequel statements below to return corrct results set. As always, thank you for your help. IF OBJECT_ID('Tempdb.dbo.#DeviceStatus',...more >>

should I create 4 individual indexes on a table or 1 composite index. and the table is Temp Table Thanks This is my temp table: #Temp col1, col2, col3, col4 my query is something like this select xxxx >From #Temp A INNER JOIN (select xxx. FROM #Temp Group ...more >>

hey all, .... AS BEGIN -- Insert statements for procedure here EXEC [dbo].[usp_myproc] @EmployeeID = @employeeId, @StartDate = @startDate is it ok to have @EmployeeID = @employeeId differ by only casing? or should i name the local variable something obviously different? thanks, ro...more >>

Hi there, I'm using Access 2007 and SQL Server 2005 What is the equivalent code in TSQL to the Access query look like this SELECT Customers.CustomerID, Customers.CompanyName FROM Customers WHERE (((Customers.CompanyName)=[What Company])) OR (((Customers.CompanyName) Like [What Company] ...more >>

hey all, how do you create a constant in a sql server 2005 stored proc? thanks, rodchar...more >>

I have kind of a complex situation and wondering if this could be scripted: Contains two columns of data, "field1" and "field2" Sample data: Field1: joe|sam|pete|mike Field2: Manager|Team Lead|Worker Ant|Worker Ant So you can see a field1 contains multiple names, and Field2 contains the...more >>

hey all, i was task with tracking vacation hours for each employee in a company. the way i did it was i calculated the accruals and hours taken on the fly in a stored procedure and it worked just fine. but then some changes came along and the solution discovered was to save the totals in the ...more >>

Hey. I'm trying to take the following kind of result (a grouping aggregation): Field, Count field1, 10 field2, 943 field3, 238 etc... ....And assign this to a variable for use later in a print statement. So, something like select @group_result = (yadda yadda...) I have a feeling I'm...more >>

I have the following table (yes it at the moment is using non-valid naming conventions) where I'm looking for procedure code can be ('22558','22612','22630'). If it finds this code; using the DOS (date of service); I want it to give me a list of all rows 1 week behind and 1 week ahead. C...more >>

Hello all, I am fairly new to the whole SQL enviorment as a whole, it was kind of pushed apon me as the IT guy of course. Currently I have a couple of databases that I have to create tables, views and triggers for but I would like to write them from say my laptop. I heard there was a manag...more >>

I am trying to troubleshoot deadlocks in SQL Server 2000. I have the relevant trace flags enabled, and I am getting the dealock info in the error log. I have nested SPs, one may call many others, which may in turn call others. My question is, in the deadlock info, I have a Line Number. Does this...more >>

I am using VB6 with SQL 2000. I made a query and tested it in SQL Analyzer, takes about 30 seconds but works very well. I rewrite it as an Stored Procedured and use it in my VB App, but it does not finished, I supposed, and send me an ERROR: TimeOut Expired. What can I do? It is possible to in...more >>

Hi, In other database environments, (FoxPro and Access in particularily), I created code that allow me to 1. create the database at first run, so I don't have to deploy the application with a ready made copy of the database. This also allowed me to automate the build provcess of the applica...more >>

I’m using SQL Server 2005, and this concerns making the xpath part of the XQUERY exist() function dynamic. I've combed the net and there (is yet) nothing on this (as far as i could tell). I'm using the stored procedure below to make a Selection. In the Where clause i use an XQUERY exist...more >>

Getting this error when trying to shrink tempdb: Page 1:123 could not be moved because it is a work table page Is there any way to: a) find out what this table is ( eg DBCC PAGE examples ? ) b) find out which process created it / is using it c) move the table to the start of the tempdb file...more >>

hello I have a remote server in a datacentre that hosts our website (www.sheffcare.co.uk) and we have an online backup service that tries to backup out \inetpub\www and SQL files. The thing is, that everytime the the backup runs, the website SQL queries break, with the following errors: ...more >>

Hi, I have an issue with address information. I need to be able to take one column containing City, State, and Zip and split them up into their own columns. My current queries use the comma after city as a reference point to select left as City, select substring 2, +2 as State and select l...more >>

Hi there, I am in the process of creating an RSS news feed from our website. The news items are all in HTML stored in a table column of type Text. I chose text as it can take the most amount of text. The news items could be really large with all the HTML formatting, but if I am using the wr...more >>

Hi All, I got a new administrator user, he is part of my admin domamin MYDOMAIN\userName. I included this user in my login sql server 2005 and give sysadmin permissions. He can't connect to the sql server... What is the problem? Tks JFB ...more >>

I have a column in my table that stores a date the job was run (IE: = 10/15/007). How can I determine 10 days prior to that date? So for example, I need to get my data column and 10 days back and remove = them from the table. So I need to get everything that equals today minus 10 days and re...more >>

I have a very large table that stores what is now Image fields... it's about 5GB in size and I want to change it to a varbinary(max) for sql server 2005 since image has been depriciated... but when I try to alter the table it comes back with a timeout error because of how many records are in i...more >>

Hi, I'm sorry but I'm not quite sure how to describe this problem. I'm running a series of tasks from a service application at a time interval that may be hourly/daily etc. I don't want to force a schedule to suit my software/ease of processing. The tasks consist of sending automated emails/...more >>