I use Sql Server 2000. I've structure like it: Create table T1( RID int primary key, A varchar(8), ... ... ) Create table T2( RID int primary key, A varchar(8), ... ... ) To make easy to view, so I make a view like it Create view VUni as Select ...more >>

Hello there I'm creating new temp table using select into statement. the temp table has has 2 main fields: rowid id identity(1, 1), Sign bit and all other fields from another table choosed dinamicly by parameter. it works fine exept tables which has their own identity field. in this c...more >>

Hello, friends, I am not that good in SQL programming, so please help. I need to randomly select just one record from unknown number records that belong to the same group, say grouped by CategoryID. I know I can do it in C#.net like the follows: Query SQL Server for the toal number of ...more >>

I am working on a database driven application and would like to run some concerns I have past some other people! The system is being used to track the process of student's following various courses. The courses are static and have a predefined 'plan'. This is represented in various tables where ...more >>

I would like to change the name of a column that appears within dozens of tables in one database. That same column name also appears within hundreds of stored procedures in the same database. I could manually change each table column name, and then manually changing each stored procedu...more >>

Hello there IS there a way when i run procedure to know from which database i run it? on server there is @@servername and for users there is SUSER_SNAME() is there is something like this for the current database? ...more >>

I get an error at the conditional where clause : Incorrect syntax near the keyword 'BETWEEN'. Code where the problem is caused: Where Case When OrderLineItems.datetime_refunded = OrderHeader.date_created THEN OrderHeader.date_created BETWEEN @DateFrom AND @DateTo AND OrderLineItems.ItemSt...more >>

I get an error at the conditional where clause. The Case When use inside the Where clausing is causing this problem: Incorrect syntax near the keyword 'BETWEEN'. Can someone suggest how to use Case inside Where. This is the code in Where clause that is causing the error. I have included the enti...more >>

I have the following Stored procedure. There is column named "tcktreceived" in my database and I want to pass all the rows one by one to the parameter @starttime. I don't know how to do it. CREATE PROCEDURE [twcsan].[usp_DateDiff] -- Add the parameters for the stored procedure he...more >>

Hello!! Im trying to find out which views, stored procedures, and other functions use a bunch of functions that I have created. Is there a system view/SP I can run to view this information. Thank you!!!!!...more >>

Hi I am automating a merge of databases and there ids are int identitys (1,1) i am trying to create a list of new numbers where there are duplicates by getting the max id of one table and generating a new list on numbers bu my code is failing as below. Is this possible to create a table automa...more >>

How can I get Current date in Stored Procedure. Datetime.now doesn't work. GetDate also dioen't work for me. Thanks, ...more >>

Ok, I have virtually no experience in FoxPro so tell me if this is possible. I have created a very simple table within a FoxPro6 database. (At least I think that's the correct terminology) I have already created a link within my local instance of SQL Server 2000 using the command: EXEC sp...more >>

I need to get the job name that is running my SSIS package. Then I need to take that job name and get it's value into a table via a derived column. I figued the first step in my job would be setting a variable for the job name like this. declare @jobid as uniqueidentifier declare @varJobNam...more >>

I have a stored proceure whic is returning a table. Now I need ADO.Net statement So that IO can pass parameters to this stored procedure and get Retuened table from stored procedure. Could you please send me code how can I reterive a returen value of tyoe table from stroed procedure in ADO....more >>

Does anyone know how to programatically get the version of Windows a SQL Server install is running under? This would be specifically for SQL 2000 sp4. Thanks!...more >>

When I log into Enterprise Manager using the administrators account and I create a new table in a database the owner is always "User". How can I change that to another user? There doesn't seem to be any place in the Properties that allows me to change either database or table owners. ...more >>

I have the following stroed procedue. But whebnnI execute it it gives me following errors. Could you please tell me what is wrong Msg 156, Level 15, State 1, Procedure usp_DateDiff, Line 43 Incorrect syntax near the keyword 'SELECT'. Msg 156, Level 15, State 1, Procedure usp_DateDiff, Line ...more >>

How is the syntax to add a foreign key for a table on a field which has in the two tables different COLLATION TABLE1 -> FIELD1 (Latin1_General_CI_AS) type nvarchar(18) TABLE2 -> FIELD1 (Latin1_General_CS_AS) type nvarchar(18) The FIELD1 is unique in TABLE2 ALTER TABLE [MyTable] WITH NOC...more >>

Hi, I am using two similar SQL Server 2005 boxes. In a proc on both machines I use SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data Source="\\server1\files\data.xls"; User ID=Admin;Password=;Extended properties="Excel 8.0;HDR=NO;IMEX=1"')...Sheet1$ This has been work...more >>

I'm taking baby steps in using Visual Studio to automate a task. I'm needing to take an existing file, and save it to a new file, with the current date as part of the new file name. I've dropped the File System into my control flow, filled in the source info, but don't know what to put for...more >>

I execute DBCC SHOWCONTIG ('TableName') WITH TABLERESULTS, ALL_INDEXES, NO_INFOMSGS It causes heavy blocking on a server, even SPID 1 is being blocked by my process. Is there any way to avoid blocking while running DBCC SHOWCONTIG? Thank you in advance, Leon...more >>

Hello everyone! We have a database that contains links to flat files in one of the tables. The flat files are created/updated/deleted in line with their corresponding entry in the database. We have a plan to introduce incremental database backups, but we are unsure how we can track the ch...more >>

for a SQL2005 database - the database under extended properties shows Collation:Latin1_General_CS_AS For the table under extended properties it is shows also Collation:Latin1_General_CS_AS But in the script of the creation of the table it shows CREATE TABLE [dbo].[MyTable]( [ID] [int] ...more >>

Hi : 1. I import data into sqlserver, from an excel file, from a worksheet within it, named 'input_data' 2. then i scrub the data in sqlserver 3. then i export some data into the same excelfile but into another worksheet named 'output_data' I have got it working and this is how i am doing ...more >>

I am looking for sugestions on best peactices for securing a SQL 2005 database from another party that may have access to the physical server, such as in a server farm. Any tips are appreciated. Thanks! Chris Evans www.globalmarketmedia.com *** Sent via Developersdex http://www.develo...more >>

I have a two tables, A & B, on two separate instances, on the same server. I have created linked server connections and can query each instance from the other. Both are test instances. We are testing a scenario where Table A is fed with daily loads, and using a SQL command, we'd like to cop...more >>

Hello, Can someone please help me with an update query? I have two tables: CUSTOMER and ACCOUNT_SEGMENT They look as follows: -------------- CUSTOMER -------------- CUST_ID =A6BUS_DIV =A6 --------------------------------- 0001 =A6PRIV =A6 0002 =A6BUSI =A6 0003 =A6PRIV =A6 00...more >>

I have created a user-defined data type and added a new column to a table using that type. In the syscolumns table, the xtype field for that column is 106. What command can I run to see the type number of my user defined types? Darin *** Sent via Developersdex http://www.developersdex.com *...more >>

Hi, I have a Contact table that stores the firstname, surname. I am trying to get the initials of the user in the table and use the sql in crystal reports. Let's use 2 users: 'Brian Johnson' and 'Jack Shand-Brown' For Brian it will be 'BJ' - which is simple enough. However, how will ...more >>

Hi all, I'm using MSSQL2000. I have a "S_Loggeduser" table. This table is for users who logged in a web site. The table has "LoggedDate" column. This column is valued by date when a user logged in the web. If a user logs out by clicking "Logout" button, a row for this user is deleted from t...more >>

Hello there, I am executing a stored procedure from inside my own procedure. The procedure I am calling returns a resultset and this messes up the resultsets from my procedure. Is there a way to ignore the output from a stored procedure? (like set nocount on?) Best...more >>

Hi, I want to know about DDL Trigger (Sql Server 2005). How can I use it, create it, about body of DDL Trigger? I have serarch some urls, but has not get enough knowledge. Rahul ...more >>