Hi All how can I Create Table (COPY STRUCTURE TO TableName Only ) From Another Table In The Same Database Thanks ...more >>

Hi, I am using SQL Server 2005.I need to find out all the user tables in a database. For this purpose I have written following query. NSBank is the name of the database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ USE NSBank; select name, type_desc from sys.objects where type='u'; ~~~~~~~~~~...more >>

I am trying to restore a data file and not the log file. Acutally, the log file will max out my drive space so i am trying to create a new db from a backup without the log file. Any thoughts? Thanks in advance, -- Stewart Rogers DataSort Software, L.C....more >>

how can i do that in mssql ? e.g. existing data Column 1, Column 2 A 001 B 001 B 002 C 001 then Column 1 and Column 2 are primary key. how can i set the column propertis for column 2 such that i can get auto-number B003 while ...more >>

Hi all. I am confusing on this matter so if anyone recognize this please let me know. Simple scenario. I am using getdate() to fill datetime into a column in a table. All within a prosedure. Create a tmp table with datetime column. Insert getdate() Insert the temptable into a physical ...more >>

All Can anyone advise me the performance advantages of using Stored Procedures vs. a normal SQL statement. Thanks...more >>

Hi, Can any please explain to me the diff.? Use Northwind I created a Non-Clustered index on "LastName' and "FirstName" (Combined) Select * from customers where LastName = 'Hello' and FirstName = 'World' Select * from customers where FirstName = 'World' and LastName = 'Hello' Does that mak...more >>

I have a table that has phone numbers, and a phone-type column. The phone type is foreign-keyed into a phone type table, and the phone-types in both tables are integers. I want to change this to use the new UniqueValues data type. In Management Studio I can create the new column easy enoug...more >>

Is there anyway new in SQL Server 2005 to enumerate all the servers on the network without sqldmo? I'm working in .NET and want to get the list, im doing it now in sqldmo and it works fine, but would like to do it with managed code instead of using a com object... ...more >>

Okay, I can restate this in a more simple way. If I have a table like: EmpSSN EmpID LastTimeIn 001624633 13864 01/28/05 020489644 2897 01/28/05 020489644 3582 12/13/05 041468792 3507 04/05/05 041468792 3614 06/24/05 057627194 3150 06/21/05 057627194 3694 09/20/05 057627194 4081 12/21/05 05...more >>

I have a stored procedure and I want to do something like: INSERT INTO @Table (Field1, Field2, Field3, ....FieldN) SELECT sum(a) AS Field1, sum(b) AS Field2, sum(c) AS Field3 FROM @Table2 WHERE n is null SELECT sum(a) AS Field4, sum(b) AS Field5, sum(c) AS Field6 FROM @Table2 WHERE x <...more >>

Is it possible to case-sensitively compare 2 varchar column values without changing the collation on the column to case-sensitive? For example, I have column called Note on a table called Operation, and I'd like to select distinct note, case-sensitively, without changing the collation. Possibl...more >>

Hello, I have a table with a couple of non-clustered indexes. One of them is a single-column index on a time column. The table has several hundred thousands records, so when I search for data within certain time range, I expect the index to be used. However, SQL optimized only selects the i...more >>

I'm having some issuses with ORDER BY with my query. I'm trying to run the same query in Oracle and SQL Server. select a.APP_ID, a.USER_ID, SUM(a.CB) AS "CB", SUM(a.SB) AS "SB", SUM(a.CA) AS "CA", SUM(a.SA) AS "SA" FROM APP_USER a WHERE a.START_TIME >= 1135044000000 AND a.START_TIME < 1135...more >>

Hi! Using the new SQL 2005 functionality where the optimizer determines where the data is based on the check constraints defined on the tables, can you use a non-deterministic function such as getdate() in the check constraints as long as you have another mechanism to make certain the data ...more >>

Just added a new datafile to my database. How do I distribute all the data evenly across the two files now? I tried dbcc dbreindex on all tables, this results in 75%/25% I also tried creating 2 new files and emptying the main file dbcc shrinkdb. I could not empty the main file completely tho...more >>

Below is part of a stored proc. This code returns an error ONLY if Field.OrderId is included in the query. It runs ok if the OrderID is not included. The error recieved is: Server: Msg 512, Level 16, State 1, Procedure Jobs_TrackInserts, Line 18 Subquery returned more than 1 value. This is no...more >>

Hi all, I have the following table: CREATE TABLE [dbo].[Company]( [CompanyID] [int] IDENTITY(1,1) NOT NULL, [CompanyName] [varchar](100) NOT NULL, [CompanyTypeID] [int] NOT NULL, [Active] [bit] NOT NULL) These companies can have a variety of CompanyType...more >>

I have a UDF that takes one single INT parameter and returns a Table like So:: CREATE PROCEDURE dbo.TestUDF ( @aParam int ) AS BEGIN CREATE TABLE #TestTempTable ( a INT PRIMARY KEY, b INT, c INT ) INSERT INTO #TestTempTable VALUES ( 1, 2, 3 ) INSERT INTO ...more >>

any better way of writing this Select serialnumber from tbl_test2 where serialnumber not in (select serialnumber from tbl_test) and exportedflag=0 ...more >>

i am using sp_OASetProperty for setting property value for a cdo.message object. But it might happen body size is more than 8000 character... in that case i want to write follwoing statement in a loop ...more >>

Does anyone know how -- during an insert -- to automatically populate a field with the same data as the field in the last inserted row? Thanks. ...more >>

Thanks in advance (even CELKO) DDL attached I DID NOT create this application. I am trying to fix it. The application recieves a Access database table once a month. This table contains employees and multiple columns detailing begining and ending balances, pay amounts etc... The tables co...more >>

Folks, I am trying to use ole db to read a date field created as a DATETIME in C#. It only seems to work if I set the binding type (wType) to DBTYPE_DBTIMESTAMP. When I do this, 16 bytes of data are written to my buffer. The question then is what to do with this raw data. What should I ca...more >>

I got this error, for the first time today: System.Data.SqlClient.SqlException: Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF. [OLE/DB provider returned message: Cannot start more transacti...more >>

how I can connect remotely to SQLExpress?.. I have enabled TCP/IP, but it does not work. error: ..... When connecting to SQL server 2005m this failure may be caused by the fact the under the default settings SQL server does not allow remote connections (provider SQL Network Inter...more >>

I have no experience with Triggers and need help to create 2. My goal is to generate the average and Stard Devation for 2 values when they are inserted or updated. In the first field I insert a count that I need to calculate the mean and StdDev based on the values of the past 30 days. The...more >>

I have run into an interesting problem. I have some code that adds a column to an existing table. The column is set as primary key, identity and clustered. On the 32-bit version of SQL Server 2005 it works fine. It fails on the 64-bit version of SQL Server 2005 intermittently with a "could...more >>

This is probably stupid, but can I have 3 selects in my stored procedure and get the results back from all of them? I have a set of data and I need to get 3 sets of totals based on different criteria. I've declared my tables, inserted/updated the data in the tables and then have my 3 selects....more >>

Why will this case statement not work? It checks the length of a char field TRAN_TIME and pads it accordingly. SELECT a.TRAN_TIME FROM QUINN_ST..get_bcp_h_cvcmis a(nolock), QUINN_CT..Rec_Pol_WH b(nolock) WHERE a.POLICY_CODE = b.Policy_desc AND a.TRAN_DT >= '20051221' AND (CASE len(a.TRAN_...more >>

Can anyone suggest a good approach to this problem? I need to match transactions from two tables on several columns. When I have a match, I need to set a match flag and a match number in each table. There can be duplicate transactions in either table. If I have two transactions in one table...more >>

I've seen others have had trouble with this. Using vs2005 connecting to sql2000, procedure works from command object with parameters but doesn't from a datasource defined on the page. I've tried any number of variations to get it to work, uses a session parameter and three control parameters fro...more >>

I'm looking for a script to do the following? I need to have a date range for each month of the year from the 22nd of each month to the 21st of the next. This doesn't work... as it starts at the first, I need it to start at the 22 of the previous month. declare @date datetime set @date =...more >>

I have a table with order dates for the past few years. I am trying to write a query that just ives me a distinct month/year for all the orders so that I can do my reports monthly. I have been wracking my brains over this one for the past few days and just can't seem to get it. Basically what...more >>

Could some please help me in obtaining the query plan by modifying the T-SQL statement below? Thank you. select top 50 sum(qs.total_worker_time) as total_cpu_time, sum(qs.execution_count) as total_execution_count, count(*) as number_of_statements, qs.plan_handle from...more >>

Hi All, I posted this query a coupe of days ago and had a few repiies but I have only just got around to trying them out, I was trying to convert a nvarchar values of 01112005 which this time I will explain is meant to be the !st of November 2005, this is something that I forgot to mention ...more >>

My brain is not working right now and I need some help. I have two tables Employee EmpID varchar(10) (primary key, unique values) EmpSSN varchar(9) And TimeSheet EmpID varchar(10) (foreign key to employee EmpID) TimeIn datetime The problem is that we have multiple Employees with ...more >>