I am trying to import data from a file with below format, each column is located fixed position ( id start at 1 end at 10, name start at 11 end at 40 ) 100348Boothroyd,Green 9080598300 40 WEEK RESTRICT 100348Boothroyd,Green 9080598300 40 WEEK ACC...more >>

OK, what's best practice for this? I have a doc_header table with an identity PK, and a doc_line table that uses the doc_header plus line_nbr for its PK. I want to do insert several rows at once to the header, and then get the identities to use for the lines. If it were a singleton, I'd j...more >>

I'm unable to copy my Stored Procedures from one database to another. I'm using mixed mode authentication. I have set CopyAllStoredProcedures to True, DropObjectsFirst to True and CopySchema to True. Nothing gets copied. I have followed many web sites that say Transfer SQL Server Ob...more >>

I am still using sql 2000. This formula, 1492/108 = 13.814... When I use Round function around it, I expect the result to be 14. Why is it coming out as 13? SELECT ROUND(1492/108, 0); Can someone explain what I missed? Thanks. Faye ...more >>

I'm trying to convert a string to a datetime using the cast function but I get an out of range error. birth_dt = '19000000' select cast( substring(birth_dt, 5,2) + '-' + substring(birth_dt, 7,2) + '-' + substring(birth_dt, 0,5) as DateTime) as birth_date from table ERROR: Caused by...more >>

I am using excel 2k3 to access MS SQL server. I am trying to total qty_shipped for each item with the following statement: SELECT sales_history_view.item_id, view_supplier.supplier_name, Sum(p21_sales_history_view.qty_shipped) AS 'Total Shipped' FROM CC.dbo.sales_history_view sales_histor...more >>

Hello, I'm trying to embed a curser while-loop within another curser while-loop, but with both using "WHILE 0 = @@FETCH_STATUS" the internal loop is causing the external loop to exit too early. Is there anyway to use something other then @@FETCH_STATUS or someway to tell this variable whic...more >>

Hello! I need to do a report and pull all birthdays in October for our customers. How can I pull this information just using October ( "10") part of a date field? Thank you for any time and thought! Ray ...more >>

Say I have four fields: Symbol, Expiration date, Vaule1, value2 If the current date is one month before the expiration date I want to add a new row, where the symbol will be different and all other fields are the same. So in my table I have: PDS,2007-10-17, 234,24 Since the expiration dat...more >>

I am trying to process some records conditionally in a cursor (SQL2000). The SP is below. I always seem to have issues with IF :( When I execute the code below (trying to create the SP, via Query Analyzer) I get:Server: Msg 170, Level 15, State 1, Procedure TRMaintenance_Daily, Line 23 Li...more >>

Hi, I need to update a table in server A from a date-effective table in server B. In table A, it has account, description, and status; and in table B, it has account, effective date, and statusB. The unqiue key in table A is account, and unique key in table B is account and effective date. Fo...more >>

I am trying to recompile a legacy 32 bit extended stored procedure into 64 bits for use on 64 bit SQL 2005. I have downloaded the Microsoft Platform SDK for Windows Server 2003 R2 with the 64 bit binaries and libraries and I have the opends60.lib file that gets installed with SQL2005 64bit...more >>

Hi. I'm using SQL 2005 to page results for a web application. There will be 10 rows per results page. I'm using a CTE and the row_number() function. On the web page, I want to also show page numbers that can be navigated to and probably the total count. To get the total row count, I see th...more >>

I've been struggling with the best way to use a DataSet, Bindings and Adapters in the application I'm laying out. To start, I'm new with DataSet's and MS SQL. I'll start by describing what my goals are: I have a form that will have a list (grid) of items from Orders. This list will be do...more >>

I dont know is this the correct forum to ask this question. I am creating a maintanace plan for rebuilding an index. The table is having 7 non clustered indexes. Out of that only one index is getting fragmented a lot. I want to create a maintanance plan to rebuild that particular index. I have...more >>

Let's say that you have two statements in SS 2000 stored proc. The first is an INSERT statement that inserts 500,000 rows into a table and the second is an UPDATE statement that updates some of those 500,000 rows. And let's say that 499,000 rows get inserted but then something bad happens an...more >>

Hello, I'm trying to parse a log file, but I'm not sure the best way to get the output the way I need. Here's a snippet of the log: FileName MD5CheckSum Date test.txt 123123123 2007-01-02 test2.txt 443223432 2007-...more >>

I'm working at a new place and I found this on a table (SS 2000 SP4) after running sp_helpindex. One of the DBA's here claims that one time he had a similar situation on another table and removing the index, the equivalent of idx_nn_tbl_OS2007Q2_CDate in this case, hurt performance. How ...more >>

I have a table which inclues around 64,000 records. When I use table's property to check its counts it always shows the wrong records less than the real records. I try to refresh the table, but it does not work. Does someone have same experience? ...more >>

I got an error this morning when my optimization job run 'Could not allocate space for object '(SYSTEM table id: -637536758)' in database 'DB' because the 'PRIMARY' filegroup is full.' For the data file settings : * Space allocated for data : 3335 MB (PRIMARY) * Auto grow file is set, 10%...more >>

Hi I have this table (XTable) A B C D 1 2 3 "X" 1 2 3 "Y" 1 2 3 "X" 1 1 3 "X" 1 1 3 "Y" I want to calculate the number of times the A,B,C is X and Y like a report: A B C XTimes YTimes 1 2 3 2 1 1 1 3 1 1 I could us...more >>

Is it possible to keep an hisotry of my DB modification (not data only structure schema) in SQL 2005. For example if i ALTER a procedure, can i have trace of this modification, can i go back to previous versione of my proc? Thanks...more >>

I have an instance of SQL Server 2005. I have a job in this server that runs twice when it should only run once. In the job history log the duplicate always has a negative duration run time. for Example -3976.20:35:40 Is there a fix or work around for this? I have other jobs on this server...more >>

I cannot make more than one query on a complex CTE I am trying to run a query with quite a complex CTE query (using CROSS JOINs and several CASE statements in the WHERE clause) After the CTE has been made there are 3 queries (SELECT statements) because I want this to return 3 distinct tables...more >>

Can anyone tell me how In and EXISTS work under the hood? ie are hash tables or binary checksums involved ? Thanks...more >>

idDocumento DataEntrega days ----------- ----------------------- ---- 80002281 2006-11-06 00:00:00 80002280 2006-11-04 00:00:00 80002279 2006-10-06 00:00:00 80002278 2006-09-06 00:00:00 80002272 2006-09-01 00:00:00 Hi, I have this table with this records, and ...more >>

Hi, Is there a way using only a query in say, query analyzer, to add images to a table? Thanks very much in advance for any answers Ant...more >>

Hello everybody, I have the following question. Let's say that I have the following values in my column (text column, 15 characters long) and If I order the alfabetically, I get the following result: 6A001 6A0010 6A00100 6A002 6A0021 6A0022 6A003 6A004 Is there a way to order them ...more >>

Hi, is there a collation for EBCDIC 870 for importing into SQL-Server? I'm currently trying to import hungarian Characters from an AS400 (stored as Codepage 870) to SQL-Server via ODBC (V5R3V5 ?) On character-Code $EF there is one of the hungarian Characters (big "O" with two accents) sto...more >>

Hi, I'm working with SQL 2000, I have a table called Items with an Image field called Content, this field contains an XML Serialization, I'm using the following command to extract the XML from the table: SELECT CAST(CAST(Content AS varbinary(8000)) AS varchar(8000)) AS Content FROM Items ...more >>

What are the benefits of using backup devices when they are configured as the same place on a disk as a normal backup to file operation? The only one I can see is the that you can backup to a remote disk? Am I missing something? Thaks Paddy ...more >>

Hi, In the Decimal datatype, why is the default precision 18 and not 19 as they both allow for a maximum length on 9? Thanks Andrew...more >>

Hi, Does anyone know of a valid method to import a database from MSAccess to MSSQL? The MSSQL tool is not much of a help so far, considering that I have MSAccess queries that need to be imported as Stored Procedures in MSSQL. If not, does anyone know how to import the SQL queries syntax ou...more >>

Here is the trouble I need to track system outages based on batched jobs. I have the following data in tables (headers) Job, Start Date, Start Time,End Date, End Time This is a batch schedule with jobs that make a system unavailable. Now there are two types of batch jobs, a start ...more >>

Hi All! I have access to a view which contains a large amount of data, but is only available over a slow connection. I have several large queries/reports that I must run against it all day long. It is much faster to just select * on the entire view into a temp table and then query that tabl...more >>

Hi, I have login the sql server 2005 with Window authontication. and execute following SQL EXEC master..xp_cmdshell 'bcp TestDB.dbo.tblTest out C:\Rahul.txt -c - t -T' And the output is ------------------------------------------------------------------------------------------------------...more >>