I previously posted about a problem where it seemed that changing the case of the word "BY" in a SELECT query was causing it to run much much faster. Now I've hit the same thing again, where basically almost any change I make to how the query is executed (so that it still performs the same fu...more >>

Dear all, In object browser of Query Analyzer, When I right click a table and open it, some columns are displayed as (.....), I think the column is too long for displaying,can I set something to let the Object browser display this too long columns. Thanks. ...more >>

I am working with data from two tables. The first table is the individual weights of product at each station in a food processing process. There may be 3 to 4000 records in a shift and are comprised of 24 stations. The second table is the sums of all the weighs at the scale. There is only ...more >>

Hi, I'm trying to do something tricky and I was wondering if it's possible to do it in a single update statement without using cursors. Here's the thing: Let's say we have this table date userId TimeSpan -------------------------- 1:00 1 1:01 2 1:03 1 1:10 2 1...more >>

In a database I created an audit table in which, e.g., I insert one record for each INSERT statement made on another table (via a trigger). My problem is to recover remote IP address of the connected client which does the INSERT. I tried to use DMV sys.dm_exec_connections because it contai...more >>

Hello all, In SQL2005 I would like to call DATEADD() using parameters for datepart and number. Actually, the number part is easy but the datepart part will not take VARCHAR(2) or CHAR(2) with the 2 character code. Does anyone know how to do this? Thanks ...more >>

Is there a way to execute a stored procedure from a command line? Note: I cannot use xp_cmdshell due to security issues. Thanks in advance ...more >>

Hi, Is there a way to use SQL Profiler to catpure execution of a specific SP? SQL profiler is giving me too much data while I am only interested in one SP. Thanks, Brian ...more >>

I am trying to write a report that displays a hierarchy such as: Director, Manager, Employee I want to suppress the repeating Director, Manager for the employees. This is my code: sSQL = "SELECT FY99Info.MDName, FY99Info.MgrName, FY99Info.firstname, FY99Info.lastname, FY99Info.grade FROM FY9...more >>

i'm having the strangest problem right now and can't seem to figure out what's going on- here's the deal: i'm trying to use the openrowset command, in combination with the bulk insert command to load data from a text file into sql server. the text file im using has a field that can have a ...more >>

Hi, When I set a variable for a function in sql statement I get error: Here my select statement. SELECT dbo.fGetProductCount as ProductCount FROM Orders WHERE ProductCount > 0 aAnd the error which I get is: Invalid column name 'ProductCount'. If I use function directly in WHE...more >>

Hi all, I need to create some audit trails for out database. The audit trails woll probably be recorded in a single audit table. Can some one point me in the right direction as to how to create this script/trigger Thanks Robert ...more >>

We have this very strange problem. We've created this trigger that has been running in production for a good while now. We have a .net application on 6 pc's that insert rows into a table which runs the trigger. 5 out of the 6 pc's run great. The application inserts the row and the trigger runs...more >>

I need to join a db2 table to a sql server table and execute the query in sql server. Can anyone suggest any solutions? Thanks, ...more >>

The following print statement as part of a loop, generates the date table as shown below in the messages window of Query Analyser. However, I want the ISOYear date to be close to the date which I am representing the ISO year from like 12/25/08 - 2008 12/26/08 - 2008 How can I acheive th...more >>

Hi, I've got a really simple question, but no concrete way to test this myself. When I do a select such as "select ColA, ColB, ColC from tblA where PKCol=@filter" will SQL server read the entirity of the row into memory and then pick out the relevant columns, or will it just read the ones I'm...more >>

Hi, I saw in description of RESTORE HEADERONLY that BackupType column can indicate an incremental backup! Is that different from Differential Backup or Log Backup? Is it new in SQL Server 2005? Thanks in advance, Leila ...more >>

Hi guys, SQL server 2000 I have a view which returns info based on amongst other things a week number. Now it appears that the app which inserts the data into the table uses a 1 to 52 week number but sql uses a 1 to 53. my problem is I was using datepart(week,getdate()) to compare the week n...more >>

Hello I'm having serious problems with my procedures. For some reason now that we've moved to sql 2005, it complains about variables being scalar. such as this one CREATE FUNCTION [dbo].[MolTest](@MolID int) RETURNS varchar(500) AS BEGIN DECLARE @Molpath varchar(500), @X0 int, @X1...more >>

My searches for a solution have all led me to the same basic articles and answers with the same examples -- hoping someone can chime in and provide an example that seems more relevant to my case. I have a table that has one column ("isOpen"). It can have anywhere from 1 to 100 rows. isOpen ...more >>

I have a windows application (written in .Net) that connects to a SqlServer 2005 database. I need to install this application on a user's PC. What components of Sql Server 2005 should I install on the user's computer? The user is not allowed to have query analyser on the machine and the data...more >>

Hi,all: I want to build a multi language website, one language is simplified Chinese (gb2312 encoding) and the other is tranditional Chinese (big5 encoding), because they are using different encoding, I'm wondering if it is possible to save both of these characters in a single database? I...more >>

I am using SQL 2005. Is there a difference between INNER JOIN with an UDF or CROSS APPLY? Thanks ...more >>

I am trying to get all backup jobs on a server using the following query but I am getting error. can some one help select sysjobs.name,sysjobschedules.active_start_time ,sysjobschedules.active_end_time from sysjobschedules Join sysjobs on job_id.sysjobs=job_id.sysjobschedules Thanks! ...more >>

Hi, help needed :) i have a row: ex. amount text account in account out 100,00 test 120 230 but i need amount text account 100,00 test 120 100 test -230 Guys please help Paul ...more >>

Hi, I have developed a .Net Windows application that has to connect a SQL Server database. Currently i am using the following connection string for connecting this database: server=3Dmyserver;database=3Dmydatabase;uid=3Dmyuser;pwd=3Dmypassword Unfortunately this way is actually unsecur...more >>

Hi everyone, In one of my procedure i want all the data to be entered in upper case to the table. I used UPPER function for that .But still I gets data in lowercase to the table in some cases.....!!! It will be of much help for me if someone can put some suggestions on this Thanks in Adv...more >>

Hello, I have a stored procedure that gets it's data from a View in SQL server: Select "WO Number", "Part Number", "Complete Date", "WO Quantity" >From [AWO_VIEW] --Select the View Where [Work Center] Like @WorkCenter Order By [Complete Date] ASC I have code in my client app that retur...more >>

Hi, I need some help finding out how to list the column that I have used for the partition scheme when creating my table. as in : create table columns ON MyPartitionScheme(ColumnName) I know how to get the function name, the scheme name but i don't know how to get what column i used...more >>

Hi all, I have a variable like this one: DECLARE @array varchar(1000) SET @array = 'aa-bb-cc-dd-ee-ff-gg' and I'd like to put the values in as many variables, like so: @1 = 'aa' @2 = 'bb' @3 = 'cc' @4 = 'dd' @5 = 'ee' @6 = 'ff' @7 = 'gg' My problem is that I don't know the exact ...more >>