Dear All is it possible to add a column in middle of the table if yes then how thanx Jami *** Sent via Developersdex http://www.developersdex.com ***...more >>

I'd like to use a single SQL table as a centralized queue for a set of distributed clients. Each client will run a sproc that would return the top X rows from the table that have not already been sent to another client for processing. the sproc would also update that same set of records ...more >>

Hello, Please tell me what's wrong with my stored procedure, it does not show me any result, there may be some syntax problem DECLARE @RC int DECLARE @TerminalName varchar(1) SELECT @TerminalName = '''"Terminal Manager'',''Real Termianl"''' EXEC @RC = [HTMS].[dbo].[dt_SearchTerminalinfo_By...more >>

I have a table which is shows below as such. Fields ---------- Counter_pk Primary Key vchr_input vchr_output blah blah...loads of other crap fields.. example ====== "1", "Brown, Blue, Black", "apple" "2". "Brown", "Bannana" "3", "Blue", "apple, Pear" "4", "Black,...more >>

hi i have a this field [inicio] char type with mm/dd/yyyy date format and i want to compare it with the today date this sql statement ("UPDATE precos SET livre = 0 WHERE inicio < convert(nchar,GETDATE(),101) ")doesn´t work . thanks ...more >>

I have a table named Categoties. The following T-SQL creates a table having identical structure as Categoties but named as New_Categoties. CREATE TABLE [dbo].[New_Categoties]( [CATID] [nvarchar](16) NOT NULL, [CATNAME] [nvarchar](20) NULL, [CATTYPE] [nvarchar](2) NULL CONSTRAINT [Categ...more >>

Hello. I have a question about the internal consistency of a single row during an update statement when another connection is reading the data with a READ UNCOMMITTED (also known as WITH(NOLOCK) ) isolation level. Let me give a small example to illustrate my question. Say I have a table...more >>

SQL 2000: Database instance "Instance1" on server "Server1" has a table-valued UDF called "UDF1". I can sign on to Query Analyzer, connect to Server1 \Instance1, using database Database1, and do this: Select * From UDF1('12/31/2006') And I get the results table. Good. Opening a new ...more >>

Hello: I have successfully created a view in SQL Server 2005. But, I found out here on the Newsgroups board that views are not allowed to have "COMPUTE" as a means of addings rows of a field (column) together. I need to have the view have the ability to sum. You see, an application th...more >>

Greetings All, I want to know if it is possible to construct a scenario using SQL such that: thread 1 selects from table1 with the tablockx hint thread 2 selects from table1 with the tablockx hint but instead of having thread 2 wait for thread 1 to commit or rollback I want thread 2 to thro...more >>

Can some one tell me what is "domain data". I am applying for a job and the job description states that applicants must have domain data knowledge. I understand that in a table, a domain includes not only the concept of enforcing data types, but also the values allowed in the column. Or across...more >>

Hi, I am using SQL Server 2005 as my application backend. As a thumb rule, I have included error handling code in all my stored procedures. For ex: have a look at an sample below. Now I just want to know whether this is the right way of doing or is there any better way of doing it? L...more >>

EXEC sp_rename MyTable, MyNewTable; The above script gives me the followin error; how do i get it to work? Caution: Changing any part of an object name could break scripts and stored procedures....more >>

Consider this scenario i have 2 database servers both have sql 2005 installed and one of them is mirror and other one is principal. Now my principal server goes down and mirror server comes back online. I start doing my things up and starts applying the transactions to mirror server. By that t...more >>

I used Try and Catch. However it doesn't catch when error like this. Msg 208, Level 16, State 1, Line 6 Invalid object name 'tblbackpodfpulatemcna'. Isn't The Try block supposed to catch this kind of error alos? If it is not then, what should I use to get this code work in case of erro...more >>

Hello: I was able to successfully parse a query in SQL 2005. But, when I copy this query into the CREATE VIEW statement in order to create a new view, I get an error saying that SQL is unable to parse it. Why is that? How can I get this view created? Below is my query. Any help would...more >>

I have a varchar that is supposed to be a phone number, the field sometimes contains things other than numbers. I would like to clean this up for a report I have to generate and was hoping there is some way to do this without using a bunch of nested replace() statements, also I don't have the a...more >>

Hello, What is the expected behavior of the following T-SQL: declare @t datetime set @t = '03/11/2007 01:59:00' select @t as BeforeDST, dateadd(mi, 1, @t) AfterDST My expectation was that the time would account for daylight savings time and would have yielded an AfterDST of 3 AM. U...more >>

My T-SQL imports a text file. In the operations log table I want to record the creation date of the imported file. With T-SQL can I find the creation date of a text file? Thanks, Tom...more >>

Hi, I have been having performance trouble over the last few days with our SQL server 2005. Queries are timing out. We made some changes a few days ago by adding additional indexes to some tables and that seems to correlate to the time the performance issues started. I checked counters and ...more >>

I've set up maintenance plans, and they are working fine until it comes time to delete the old files. That does not work for .trn, .bak, or for .txt files. Am I missing something in the setup? Even when I run the xp_delete_file command manually, it says it runs successfully, but I look and ...more >>

Is it a good practice to run DIsk Defragmenter on SQL User Database Drives where lots of data gets added/deleted? ...more >>

Hi, My sources files are sending data with the following format 12.345.678,12-. And I want to use this information as a decimal. What can i do if i want to transform this value to -12345678,12. Thanks...more >>

Hello, we are just getting started with creating/modifying database objects (tables, indexes, stored procedures etc) and SSIS packages in SS2005. What tools/products are people using with respect to change management and version control? We are a relatively small development group with fewer t...more >>

One of the large tables in SQL 2005 (100 GB), DBREINDEX operation bloated the total database size from 537 GB to 800 GB. Any suggestions as to why would this happen? Where can I look at the space allocated. I tried looking in sys.allocation_units but still no clue after adding the number I saw...more >>

For a very high reads and writes (Random - Since user db) on SQL 2005, Raid 0+1 better or 1+0 in performance? -Nitin ...more >>

Hi All I have a table Tab1 with column Col1 varchar (20) and with records as below: Col1 B E F G I S I would like to select and order the records in the table in a way that the record 'G' comes on top of the resultset as below: Col1 G B E F I S --select col1 from tab1 ord...more >>

Hi, I am quite new to SQL. I need a help with this query. How can I get the top 3 salaries paid department wise? Sample data and table structure below - -- Sample Data Create Table Emp ( eid tinyint, sal smallint, dept tinyint ) insert into emp values (1, 10, 1) insert into em...more >>

Hello Everybody, I want to load XML file into sql server table from specific folder using sql server 2005 database. Every day i will get XML file into that folder and i want to truncate and load into same table. Sample xml is <?xml version="1.0" encoding="UTF-8" ?> - <ROWSET xmlns:xsi=...more >>

Hello: In the following script and specifically in the SELECT statement, I'm trying to place an if,then statement to say "if UPR30300.PAYROLCD = 'HOUR' then UPR30300.UNTSTOPY else if UPR30300.PAYROLCD = 'VACN' then UPR30300.UNTSTOPY else 0". I have tried working with placing a nested SEL...more >>

Sometimes when testing for temp tables, or stored procedures from sysobjects I sometimes see the name of the object right padded with _'s, other times not. for example (not sure if there are other examples): create table #foo (col int) select name from tempdb..sysobjects where name like '#f...more >>

hello all, I have a column of type smalldatetype in table a. Viewing this table in Enterprise Manager you see the values in DD/MM/YYYY (UK) format, however, if you do a SELECT dateColumn from TABLE A using Query Analyser the results come back in YYYY/MM/DD (USA) format. Now, I've tried C...more >>

Use Case: Say, the same crystal report can be used to show the records from three different databases. How to use the same crystal report (not 3 different crystal reports) for fetching and displaying the records from these three databases depending upon different business validations… ...more >>

Use Case: Suppose a Quotation is to be printed where the details of the Quotation are to be filled by fetching the records from different tables based on different business validations. Can we use more than one SQL Queries for the same crystal report to fetch different values from different t...more >>

i need the query for converting the integer into float or vice versa EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com...more >>

I have a reporting requirement that I show the total number of workdays on a project.. I can do a select Distinct and get the actual rows needed but haven't been able to figure out how to total the rows with an aggregate function and grouping SQLServer 2000 and Attached DDL. Thanks for...more >>

Hi all, I want to write case statement in sql server 2000. What i want is in stored procedure i am passing one value. and this value i have to compared means i have to put in case statement. How will i do this? something like as below:-- declare @casefield varchar(800) select case ...more >>

hi, on localServer i execute this query INSERT INTO table (A, B, C) SELECT A, B, C FROM LinkedServer.myDB.dbo.table everything is fine. But if i execute this one INSERT INTO LinkedServer.myDB.dbo.table (A, B, C) SELECT A, B, C FROM table it is very slow. Is there any solution to...more >>

I've created an application to process some documents in a file with the following structure: DocumentMailer (DocId Int (Identity), DocName varchar(20), DocDetails VarChar(200), DocReceived datetime, DocSent datetime) I need some suggestions on creating indexes: - DocId column id an Identit...more >>

I own an MSDN subscription. After I installed SQL server 2005 I've noticed that it shows SQL Server 2005 Express. For a reason that I don't know it doesn't show a Copy Database context menu right after right clicking at a database. I also don't see any wizard in management. Do I need to install ...more >>

I have 2 servers (named A and B and they are not part of the domain). Server A hosts asp.net application (open to the Internet) and server B hosts sql server 2005. Right now, I use connectionstring "server=xxxxx;database=xxxxx;user id=xxxxxxxx;password=xxxxxxxx" to connect to the sql server...more >>

Hi, I have a small, incredibly simple Access database that I'm using to keep track of asset numbers of branch computer systems. The table tblBranchAssets has the following fields: branch_id[pk] - Branch number server_asset: Server asset number terminal1_asset: Terminal 1 asset .... ter...more >>