Hi there: What is the most efficient way to apply a unique ID to a table through SQL? I'm working in a SQL Server 2000 DTS package--I have a table that has unique rows but has a null UniqueID field, and I have another table that stored the MaximumLast ID from the master table. I am currently ...more >>

Hello: Currently I have a large SQL Server 2000 DTS package that does many things--I was able to do everything except one without using cursors. I want to get rid of the one instance I use the cursor however as it holds things up. This is a database that measures events in the life of a pho...more >>

I want to sum up the amt field where the acct or group is A1000. Since A1110 belongs to group A1100, and A1100 belongs to group A1000 it should pick those amts up as well. The total should be 600. I have the sql below but I can't figure how to pick up acct A1110 since it should be rolling up t...more >>

I am running the following query that will report back the local admins on a workstation, however the string that is pulled from WMI looks like this... \\machine01\root\cimv2:Win32_UserAccount.Domain="machine01",Name="sysadmin121" is there any way that I can get the query to strip off everyth...more >>

I've got a situation where there is Numeric data coming into a program from an older database. The field in question is a numeric field that is returning this: "51217.00" That number represents Dec 17, 2005. Single digit months look like this: 40116.00 indicating Jan 16, 2004. I need to c...more >>

Is there any way I can select the quantity out of this data such that I could perform a calculation with it? Thanks. CREATE TABLE #TEST ( TestField varchar (100) ) INSERT INTO #TEST (TestField) VALUES ('Code 1. Qty 130,000. (ID: 1218).') INSERT INTO #TEST (TestField) VALUES ('Code 2. Qty 13...more >>

I appreciate any help or advise! Thanks assuming the contents of the table are: 1 52 PUERTO RICO 2 52 PUERTO RICO 3 10 MA 4 52 PUERTO RICO 5 5 NY 6 10 MA 7 5 NY 8 52 PUERTO RICO 9 10 MA 10 11 RI 11 12 PA 12 13 CT 13 14 GA (1) detect if there a...more >>

Is it possible to set the indentitiy flag for a column by simply using alter table/alter column in SQL 2000 and SQL 2005. ...more >>

Hi, In Oracle a query like this works fine: SELECT * FROM ( SELECT * FROM Customer ) However, it does not work in SQL Server. Is there any way to make it work in Sql Server? Thank you, Max ...more >>

I have a table containing unit and employees assigned Unit Employee 2 North Michael Gates 2 North Bill Jordan 3 South Wendy Shore I want to write a query that will concatenate all the employees that are in the same unit with a carriage r...more >>

Hi, Could you please show me how to count variable number in a table? And, why DESCRIBE procedure is not recognized in SQL server? Thanks a lot! Michael ...more >>

I have a stored proceedure that updates 2 fields. Calling it from C# sometimes I want to update 1 field, sometimes both. My USP has @f1 and @f2 as its arguments. Is there a way to say disregard @f2 if I want I know I can just have two USPs but I'd like to combine it all in one here if possible...more >>

I have sql server job defined, it currently does not have a schedule defined. In t-sql, how can I launch the job the instantly and get back Instance_Id or something that I can use to check to see if the job is running or finished in a later step? ...more >>

All, I am trying to get a text data field to update in SQL 2000 using a stored procedure. CREATE PROCEDURE [dbo].[sp_SQL_addUpdate] @SQLUpdate_By nvarchar(25), @SQLUpdate_DB nvarchar(15), @SQLUpdate_Object nvarchar(50), @SQLUpdate_Description varchar(8000), @SQLUpdate_Script text, ...more >>

Hello I have a job in SQL server, which combines the content of table with URL links and sends the data out via email in html format, however content get a carriage return on every ~900 characters. As a result the URL might get cut off and as a result, it is not working. And here is what I ha...more >>

Our client currently consolidates information from across more than 100 databases using SQL Server 2005. Their current solution uses a stored procedure to retrieve the data from each database into a single table which Crystal Reports then reports against. The Stored Procedure logic is as f...more >>

Hi, i'm new in this field. i have excel file with 70 sheets (all the sheets with the same number and name of column), i 'd to import all this data to a SQL table which have the same column. i know that i can use OpenRowset, but i'm allowed to specify only 1 sheet. Thinks you for you help ...more >>

Dear all I have an issue with a query I am trying to run across two different sql servers. The local server is running 2005 and the remote is running 2000. I need to call a stored procedure on the remote (sql 2000) server from the local (sql 2005) server and populate a table variable. Code is...more >>

I just listed a post to find out how to rank a table formatted like the one below in such a way that people who have the same points will be ranked in the same position (a tie). Full_Name Points ----------------- ------------ Name1 855 Name2 805 ...more >>

HI, I have inherited a table that has a self join in it. A column called "Parent" is related to the PK of the same table. Problem is, I think, that when the relation was created, it was never asked to check current rows, now I find a contraint conflict when I try to correct the oversight. My ...more >>

A few years back I thought of a SQL problem related to performing joins up a hierarchy; last summer I spent an afternoon solving it. It's not doing me any good sitting on my hard drive, so I've decided to share my solution. This is a very common problem in business development. Here is an exampl...more >>

I need to write a t-sql query that will take the value of the previous record into consideration before calculating the current row's new column value... Here's the situation... I have a query which return the following table structure... Full_Name Points ----------------- ...more >>

Hello Guys, I have a question: I would like to build a flexible question tool. These are the main tables for the moment. /*This table is question table; Question ID, The kind of answer (Text, integer or list), QuestionType (this is for script), Question Text) CREATE TABLE [dbo].[QUEST...more >>

Hi, I have a SQL Server 2005 db with 60 tables related to customers, orders, payments, etc Now I need to add a COMPANY columns to all tables, as the same database will be accessed by customers from different companies. I want the Customers of COMPANY A to select, insert, update only the rec...more >>

Hi, I am trying to modify the following query which currently pulls records based on max date. I'd actually like to change this so it no longer pulls by max date but rather than the most recent record entered into the table. The current query is as follows: SELECT ll.sDisplay, t.sLastName...more >>

I have the following query which shows the quantity sum for each week: SELECT ProductID, Description, Quality, ProductGroupID, [1] AS W1, [2] AS W2, [3] AS W3, [4] AS W4, [5] AS W5 FROM (SELECT ProductID, Description, Quality, ProductGroupID, DeliveryWeek, Quantity FROM vwProduct_order WHERE...more >>

Hi I need a query to report compliance with a 30 working day KPI of depatched items. That is how long after receipt of a key piece of info the despatch is made. To make matters even more complex, to make a despatch we actually need two pieces of info, and these may arrive before/after each other...more >>

Hi, Is there any way to select some data with a custom span of record number... Lets say a sql qurry return 1000 data ... and i want to get only 200 to 500 record numbers... Just like "TOP" operator which define a records size from top of the querry.... Thanks for any help in advance M...more >>

Hi all I created a C# console application that is called through a stored procedure using xp_cmdshell. The application generates an Excel report from the database with a macro embedded in it. The report generation fails when it is through xp_cmdshell. But when I tried to run the execut...more >>

hi , i'm a C# programmer , i've decided to upgrade my app from using ms access to SQL server 2005 EXPRESS. (i cant BUY the FULL!) So where do i begin , i need a brief but complete article/ book/ sample.. . on the basics : 1. connecting to it 2. making tables , edit them , delete them etc ...more >>

I tried creating a DTS job that will export data from sqlserver to excel using the export wizard. i choose the option execute the job then schedule it. Executing the job (for the first time) works fine but executing it based on schedule or force executing it causes an error: The Microsoft Jet ...more >>