I have inherited a system that has a table with 9.7 million rows which grows by around 5,000 a day. (SQL 2005) A record is written for each episode every time the unit/ward/doctor changes as well as at 07:00, 15:00, 22:00 and 00:00 each day (changes in shift) Here is a sample episode un...more >>

Hi, I have some table in old DB with column named "index". How to write insert statement to not get an error? if I try to do that SQl Server is saying "error near index...etc" insert into table (index, name) values (1,'Bob') got to be some workaround? thanks ...more >>

Anyone know if there is going to be an "October CTP" for SQL 2008? ...more >>

Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml data type variable into a C# CLR function and retrieve it back out of the C# CLR function when the C# CLR function is done modifying it? I tr...more >>

Are there any conversion utilities that will convert access sql code to sql server 2005 code? ...more >>

how to determine how many milliseconds a segment of code takes to execute in TSQL on sql server 2005? ...more >>

Hello, I need a clear and uncomplicated method to display money values in text reports. For instance, $1.98 and $0 and $.90 should go in characters 3 to 12 (column 2 of 3) in the following format: TX 198column3 value x CA 0column3 value y PN 90column3 value z I've ...more >>

I have input params that can have values (1,2,3,...) or be null. They will be used in searches. My problem is I am using copy and paste code with parameter checks: if(@dt is null) Begin ... -- @dt is not used if(@dt is not null) Begin ... where dt1 > @dt ...more >>

Commit: When using SS when is a commit needed? e.g. if I open a QA session and delete some rows for a table, when does that delete become permanent? ...more >>

Hi Everyone, Please could somebody help me with this problem. I think it should be simple but I am missing something: Assuming I have a query that returns something like this: item weight trip 1 20 5 2 40 5 3 25 5 How do I write query ...more >>

Your product/service may be outstanding, but it's the number of quality customers that you gather that will ultimately turn your business into a multi-million dollar empire! I'm not talking about a few hundred leads .... but a database of 50,000 high-quality customers. Or to put it another ...more >>

I have created a cursor that uses sp_send_dbmail to mail out an e-mail and then insert the values into a table, the values are supplied from a temporary table which is populated with a SELECT statement. The issue that I am having is that the last value is always repeated, two e-mails are sent...more >>

SQL 2000 v4 How can I get the value used in the having clause? Once I've identified the elig_ids that have 2 or more servicedates, I need both the elig_id and the servicedate that contains 2 or more. I don't necessarily need the dupes, one record will suffice. I just can't figure out how to...more >>

Good Morning, I was wondering if there are any instructions or scripts available that would allow me to generate table DDL syntax from SQL Servers system tables\views? I created my own query tool (just for fun) and one of the features is allowing the user to view DDL from the database. T...more >>

Not very good with SQL and need a way to identify the differences between two records based on selected subsets in a single table. . Set 1 is the items in an existing Request and Set 2 is a new Request. I need to identify the deltas. The problem is to identify three types of records - rec...more >>

My SQL database was created using the Access utility to convert an Access database to SQL. On the SQL Server, I have a DTS package that exports the entire contents of a SQL Server table to a fixed- length .txt file with CRLF row delim. The exported table's last column is a field that was an Ac...more >>

I havent messed with triggers before so I am hoping I can get some help on this... I am assuming that what I am trying to do is easy.. First off, I have a test table to just play with temporaily and a real table that will hold the trigger... here they are: CREATE TABLE [dbo].[sku_info]( [id...more >>

Hi I have 2 tables CREATE TABLE a ( rowid uniqueidentifier not null, numericid int not null ) CREATE TABLE b ( rowid uniqueidentifier not null sometext varchar(10) not null ) foreign key of b.rowid to a.rowid Table a contains insert (rowid, numericid) values (1306, 'F122BF2...more >>

I created a trigger in SQL 2005 and wanted to use ALTER statement to update it. But It did not work. I have to drop it and recreate it. It is odd, isnot it??????? Does anyone know this? Thanks in advance. Wei ...more >>

I have a SQL 2005 based database and I want it to be able to support accents and graves etc from the Polish language in a varchar. I do not want to use nvarchar If I change the language and/or collation sequence will I be able to stored accented strings to a varchar field. If so, is it ...more >>

Hi, I have a table with a field called caption when I do declare @name varchar(3) set @name = 'ED' if exists ( select * from Group where (caption like @name + '%' )) print @name else print 'not found' if 1 = ( select count(*) from Group where (caption like @name + '%' )) prin...more >>

I have a date that I am using as part of my select statement: DATEADD(YEAR, 2, a.SurveyDate) I need to restict the results of my query to only start with displaying next month. I need to add two years to every surveydate and only display results begininng with next month. In other words t...more >>

Hi, Is it possible to remove a column from a view (or even a SELECT) that only holds NULL values? Example: ID Value1 Value2 1 A NULL 2 NULL NULL 3 C NULL I only want to display the ID and Value1 columns because the Value2 column holds nothing...more >>

Hello, I have a syntax error in IF that I do not understand. I marked the error in attached source code. Please help. The following stored procedure generates new number for Documents, according to DocumentsNumbering table (with columns: DocumentYear PK, StartingDocumentNumber, DocumentN...more >>

Often, I find my SQL queries doesn't return data in a format useful in my code due to joins. For example, imagine I have a Pen product and a Paper Product. The first has variations Color and Size, the second just Size. When I select products from the database, I get a list where pen appears ...more >>

Hello, Here is DDL CREATE TABLE "dbo"."Contract" ( "System_ID" CHAR(3) NOT NULL, "Material_Number" CHAR(18) NOT NULL, "Cust_Number" VARCHAR (18) NULL, "Date" DATETIME NULL, "Sales_Eur" NUMERIC(15,5) NULL ) ; and sample data "System_ID" "Material...more >>

Hello: I need to print labels via Report Services and one of my parameters is how many copies I should print. I could print one label with the same data or decide to print the same label in the same label sheet more than once. I have a sql statement to insert from a select. I need help to se...more >>

I would like to write a stored proc that inserts a row into a table. The table's PK is a GUID with newid() set to auto generate a value. I would like the proc to then return the GUID after the insert. I thought I could do something like: INSERT INTO Employee(EmployeeFirstName) VALUES (...more >>

Hi, I have 3 stored proc to view from an ASP.NET website. What is the most efficient : To run the 3 stored proc from the ASP.NET, or to make another stored proc running the 3 others from the Sql Server and run this new stored proc from the ASP.NET ? Thanks for helping ! ...more >>

"Q7: I would like to change my user name, how can I do it? A: Unfortunately, it is not possible due to technical reasons (because of the way GameKnot stores and references the user data on the server) -- your user name is permanent and cannot be changed." Gotta love the natural key crowd :-)...more >>

I am experiencing a problem with transaction handling in my SQL Server-based application. To demonstrate the problem, here are some simple T-SQL statements, which can be executed one by one in SQL Server Management Studio: \\\ -- Get the current transaction count, which is of courser zer...more >>

I have a datetime column when I pass date value, it bails out.. Convert doesn't works convert(varchar(20),@myDateColumn,101) cast doesn't work!!! cast(@myDateColumn as smalldatetime) datepart works but fails when you have spanning months [oct-nov] what's the solution??? TIA SQL2000 ...more >>

I have query like that SELECT Urun_ID ,Urun_Ad FROM TBL_URUNLER WHERE CONTAINS(Urun_Ad, '"*mta1000-*"' ) it returns 62 MTA1000-1 When i chance the search phrase mta1000-1 it returns nothing. Urun_Ad is defined as NVARCHAR(50) in my tbl_urunler tabl...more >>

Hello Somebody knows as I can keeps Chinese characters in a data base SQL? My necessity is to be able to as much send reports in English as in Chinese ...more >>

Is there a way to bulk insert from a variable, not a file? Example: Instead of this: BULK INSERT [dbo].[Inventory_ent_Load_25] FROM 'c:\hold\Data.txt' WITH ( FORMATFILE = '\\sdvipp1\SQLFormatFiles\CanonicalInventoryBase.FMT', TABLOCK ) This: BULK INSERT [db...more >>

Hello, I am a bit confused. The documentation recommends having set ansi_padding on, and I agree. But if I create a new database in Studio the SET ANSI_PADDING option is by default false. This makes no sense to me, surely if they recommend it being on then a new database should have it t...more >>

Hi, I need help with an interesting query, I have a table containing Login and Logout times, I need to know the maximum number of concurrent users (maximum number of users connected on the same time) Thanks Meir CREATE TABLE [dbo].[LogTimes] ( [LogTimeId] [int] NOT NULL , [UserId] ...more >>

I've just created a check constraint... ALTER TABLE [dbo].[Tours] ADD CONSTRAINT [CK_Tours_VehicleSeatAllocation_SeatingPlanWebsite] CHECK (([VehicleSeatAllocation] is null and [OwnAgentsSeatingPlanWebsite] = 0 and [OtherAgentsSeatingPlanWebsite] = 0 and [DirectSeatingPlanWebsite] = 0) or ...more >>

I'm customizing an ERP application that has a SQL Server 2000 back end. I need to create a few views, stored procedures, and tables in the database to support my customization. In an effort to logically separate my custom additions to the application's database entities (which are in the dbo s...more >>

I have two SQL2000 servers. I have a database on each server, let's call them DatabaseA and DatabaseB. Each databases has a table with identical structures, lets call them TableA and TableB. As records are inserted into DatabaseA.dbo.TableA, I want them to appear in DatabaseB.dbo.TableB as soo...more >>