Can we create views on temporaty table in sql server2000.If yes how can we do that? From http://www.developmentnow.com/g/113_2004_3_0_2_0/sql-server-programming.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I'm getting inconsistencies with the function IS_SRVROLEMEMBER. When I execute the function in a query window, it returns the value I expect. In my stored procedure, it is returning null for any username that is a windows account. I'm using SQL Server 2005 SP2. Windows + SQL Server authe...more >>

There are planed some design modification to be made in some tables. How can I get the name of SPs and Functions which uses this tables or view of this tables. In other word, what stored procedures and functions are dependent on a table: Thanks...more >>

Hi, I would like to create an exact copy of the existing database and rename it as HR_Staging. I first created a new database - HR_Staging. Then using the Import Data tool, I imported everything - tables and views from the original database HR into HR_Staging database. However I see th...more >>

In the database there are a lot of store procedures. What is the best way to detect which stored procedures uses a collation. For example:COLLATE Latin1_General_CI_AS? One way is to script all SPs and to search manually in the file. Is there any other way. Thanks, ...more >>

I'm kinda stuck here. I need to see a value that was updated in a table, but not the current value and not the value that was there yesterday. Yesterday: xxxK Today: xxx1 xxxa xxx3 xxxG <-- I need this one xxx5 xxxU <- current My googling around hasn't yielded an...more >>

I received a timeout error on my web app due to slow execution. I have this 2 similar DB (i.e. DB_A and DB_B) and when I execute an Insert/Update/Delete statement on DB_A it is much faster to complete compared to DB_B. I checked the tables' primay key PK and foreign key FK where I execute the s...more >>

Group by week having Monday as the first weekday/"week label" For any given date, I want to label/group it by week, having Mondays as the first day of the week and also the label of that group. Example: 2007-06-17 Sun: 2007-06-11 2007-06-18 Mon: 2007-06-18 2007-06-19 Tue: 2007-06-18 2007-...more >>

I recently started seeing a new description in the deadlock event. Anyone have any idea what the underlying issue might be?? "Parallel query worker thread was involved in a deadlock" Thanks Richard ...more >>

I have a header table which is called Batch and the transaction table is called GLTRAN. The key field on both is Batnbr. I want to find all Batch records where the Gltran records have multiple companyid values. Most of the Bathces will have a single companyid value i.e 'Common' or 'Joc'. ...more >>

I have two tables which I'm joining in a query. In the join, I'm creating a column whose value is conditional (see columns Actual_Latitude and Actual_Longitude below). Is it possible to reference the created column in the WHERE clause? Consider the following query: SELECT S.StationID , P...more >>

Hi, from ServerA, I query a database on ServerB (No sql logins or linked servers are allowed) select top 1 * from OpenDataSource ('SqlOleDb','Data Source=ServerB;Trusted_Connection=yes').Master.dbo.sysdatabases the error: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT A...more >>

Hi, I have following stored Procedure. I am writng following ado.net code to get return value from stored procedure but it doesn't work. String constr = System.Configuration.ConfigurationManager.ConnectionStrings["twcsanConnecti­onString"].ConnectionString; SqlConnection ob...more >>

Hi, I have following stored Procedure. I am writng following ado.net code to get return value from stored procedure but it doesn't work. String constr = System.Configuration.ConfigurationManager.ConnectionStrings["twcsanConnectionString"].ConnectionString; SqlConnection objConn =...more >>

How can i get a select to work correctly? the values do match as displayed, but i can not select on this value. declare @binVal as varbinary(150) set @binVal = HashBytes('MD5', 'MyUserID') select @binVal select HashBytes('MD5', secUserID),* from sec where HashBytes('MD5', secUserID) = @bin...more >>

I am using nested transactions in SQL Server. My nested transactions work as expected. If one of the transactions does a "Rollback" before the upper most transaction is commited, then all the transactions will rollback. However, when that occurs I get this error: "Transaction count after ...more >>

I get an error when trying to use Nested Case When: CASE WHEN oh.date_created=oli.datetime_refunded then CASE WHEN oli.ItemStatus IN (10, 20, 30) THEN SUM(oli.Price) ELSE SUM(oli.Price) * -1 END AS Tickets, CASE WHEN oli.ItemStatus IN (10, 20, 30) THEN SUM(oli.TransactionFee) ELSE SUM(oli...more >>

I have a stored procedure which returns three values: 1. The 1st select returns the gross sales 2. The 2nd select returns the refunds 3. The 3rd select returns net sales which is gross sales-refunds The 1st and 2nd select are workin just fine. The 3rd select also works fine as long the order ...more >>

i would like to know if there is a way to 'step through sql server t-sql commands' using one of the sql server 200 tools, sql server managment studio, or viusal studio .net 2005 professtional version? If so can you give me directions on how to 'step through' (debug) the t-sql commands. if not...more >>

I am concatenating data for the famous ticket process. I am now joining to another table (customer_own_Pnumber) for an additional column. The problem I’m having is data in that table does not always have their own part number in that table. So, when I join cust_ID or item_id (which does...more >>

I have an index on a column which is free form. The problem comes up when I have a value in the column such as abc/xyz. If I search for abc, the results come back finding the value, however if I search for xyz no values are returned. I assume the forward slash is acting as an escape charact...more >>

Hi, I'm looking for advice on creating databases for someone just starting out. Articles, books, websites, etc. Here's what I'm trying to do. I want to create a SQL database to be used as a business contact manager, where I can input names, dates, phone numbers, etc and keep a log of variou...more >>

I'm not sure if this is a SQL Server or .net question so I appologize if this is in the wrong news group... I have two sql server stored procedures that use transactions. Both stored procedures have there own begin transaction , commit and rollback. Currently I have .Net code that exec...more >>

Hello, I need to convert this string: '6/13/2007' to this string: '06/13/07' This statement returns the correct format that I need. SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY] Just can't seem to figure out how to convert the initial string to date, then to this format, then ba...more >>

Hi; I want to select some data from tables in db and with the query below exec msdb.dbo.sp_send_dbmail @profile_name='webmaildb', @recipients='dogumgunu@bimeks.com.tr', @subject= @SUB, @query='SELECT NAME,SURNAME,BIRTHDATE FROM PERSONAL WHERE RECNO=XXXXXXXXX, @exclude_query_ou...more >>

Hi! I wrote an ACCESS 2003 app which uses SQL Server 2005 Express Edition. My app uses a lot of stored procedures/views/udfs and I somehow would like to hide/protect the source code of these objects when I install my app and the database by a customer. I think I can use permissions on my ob...more >>

Hi folks, I created a clr stored procedure, deployed to the database successfully. And I could see the stored proecedure in the object browse window of the management studio. When I ran it, I got an error message as below: - Msg 6263 - Execution of user code in the .net framewor...more >>

Hi I need to perform a select query within a stored procedure eg, SELECT lng,lat FROM table WHERE postcode='BN1' I then need to put lng and lat into variables to use in a different query. How do I do this in SQL? Thanks Jeff ...more >>

Hi, I have an SQL Server Table in which one of the attributes is stored as a GUID. The GUID actually represents the name of a SQL Server Reporting Services report. Once I retrive the GUID from the DB, I cant figure out how to get the Report Name back from it. I was wondering if anyone co...more >>

http://beyondsql.blogspot.com/2007/06/dataphor-inclusive-sql-vs-exclusive-d4.html ...more >>

Hi Experts, How to reset the primary key values. For Examples Primary key in my is now 750, i want to delete all the rows and start primary key value to 0 regards sundara murthy s...more >>

i have got a brand new windows 2003 standart insallation with brand new sql server express 2005 and brand new sql server management studio instalaltions. When i start sql server management studio i get this errorr (see link) http://img265.imageshack.us/img265/6607/mamagementstudioerroryd8.jpg ...more >>

Hi I don't thik there is but for confirmation is there a way programatically to remove the identity from a column on table on a Sql 2000 Server. I can remove it using EM but I have a script that I would like to run to completion. I am updating some of these values to diff numbers. t...more >>

Following is the simplified form of ddl create table securityprice( securityid int, pricedate datetime , price numeric(20,8)) Price is updated everyday . Need to store old prices which are dating back to 2004 . Most of the queries are targeted towards current date OR dates in the current...more >>

Hello, I'm having a doubt abut the behaviour of the AND clause in the SELECT order I have a table with a VARCHAR field called COD, wich contains different codes for ledger accounts; its contents are: 43001021 45001129 45001128 45001127 45001126 4500112C If I want to select all th...more >>

i am using sql server 2000. I have written update trigger on CORP_CAGE table to log the details in CORP_CAGE_LOG_HIST table,if any changes in EMP_SEQ_NO column. please find the structure of CORP_CAGE table: 1.CORP_CAGE_SEQ_NO 2.RECEIVED_DATE 3.EMP_SEQ_NO CORP_CAGE table is having 50,0...more >>

HI IS THERE A WAY TO GET MY PROC FASTER IT RUNS OK NOW BUT I JUST NEED IT FASTER THANKS. POSTING HERE B-COZ I WAS TOLD THAT THE REAL SQL GURU'S HANG AROUND IN THIS GROUP CREATE PROCEDURE SP_ORDERSUBMISSION @SENDRECORD BIT, @TYPE CHAR(3) AS SET NOCOUNT ON DECLARE @STR_USER_ID CHAR(...more >>

My company working days is from Monday to Friday. I would like to generate a result set which show all consecutive working days (Monday to Friday excluding the weekends) that is, for June 2007, it show me 1st, 4th, 5th, 6th, 8th, 11th etc... until 29th (last working day of June). Is it possi...more >>

I have two tables: table1: Id col1 1 my dog is black 2 my cat is white 3 my bird is yellow 4 my snake is green table2: Id col1 1 yellow 2 white I want to return the rows from table1 where the values from table2 are not found results: my dog i...more >>

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), ... ... ) then I make a view like it Create view VUni as Select RID, A From T1 uni...more >>

Hi Yesterday one of my colleagues pointed out to me that some database software under development wasnt working. I checked the event log to be greeted with a message that 'user bromley was disabled'. I tried to log onto the server remotely with Management studio using windows authentication ...more >>

Hello there For some reasons i would like to run actions from sql server or from application uses sql server in order to get entire database creation script or creation scripts for objects on sql server Where can i start learn on it? ...more >>