Search Results

Search found 47776 results on 1912 pages for 'sql case'.

Page 58/1912 | < Previous Page | 54 55 56 57 58 59 60 61 62 63 64 65  | Next Page >

• Strange Values in SYS.DM_TRAN_LOCKS table RESOURCE_ASSOCIATED_ENTITY_ID column

  - by AJM

  I’ve been trying to understand some strange values in the RESOURCE_ASSOCIATED_ENTITY_ID column of SYS.DM_TRAN_LOCKS when RESOURCE_TYPE is “OBJECT”. Although these should be object Ids, I cannot determine what object they actually refer to. I’ve tried everything I can think of, including querying all system tables with columns of type INT and…

  Read the article

• Problem with nvarchar data with XML in SQL server 2005

  - by Paresh

  Create table testxml (xmldata xml) declare @var nvarchar(max) set @var = N'?????? ?????? ????' insert into testxml select @var After inserting , i am getting data from table like select * from testxml --------------------- ???????? Can you provide me the solution?

  Read the article

• Tsql can't update the column with count statement

  - by desi

  declare @t1 Table ( a1 int ) insert into @t1 select top 10 AnimalID from Animal --select * from @t1 declare @t2 table ( dogs int null ) update @t2 set dogs = (Select COUNT(*) from @t1) --------- The out put it gives me is just 0

  Read the article

• Tools to manage sql 2008 database mirroring?

  - by lemkepf

  We are going to be moving about 20 databases that live on a single instance of sql 2000 to a sql 2008 r2 environment with database mirroring. What I'm looking for is a tool or scripts that will help me manage the conversion and management of those 20db's onto this new mirrored environment easily. There are many steps in setting each DB up…

  Read the article

• Convert XML to table in SQL Server 2005.

  - by Tamim Sadikali

  If I pass in an xml parameter to a stored proc which looks like this: <ClientKeys> <ck>3052</ck> <ck>3051</ck> <ck>3050</ck> <ck>3049</ck> ... </ClientKeys> ...and then convert the XML to a temp table like this: CREATE TABLE #ClientKeys ( ClientKey varchar(36) )…

  Read the article

• Copy SQL 2005 view result column headers?

  - by DonnMt

  Is there a way to copy View output column headers along with the data? There is a setting in Options to include column headers with query results, but that only works with "New Query" and Stored Procedure output. Looks like SSMS 2008 has this functionality built in to the contextual menu when you right click on results, but I only have…

  Read the article

• SQL Server 2008 Reporting Services Charting - adding a data table to bottom of a chart

  - by Christopherous 5000

  I would like to add a data table to bottom of a (line) chart in a report. I know I can create a matrix report with the same data source. I would like to have everything lineup automatically like it does when you add a data table to a chart in Excel (as shown at http://www.tushar-mehta.com/excel/newsgroups/data_table/). Example from…

  Read the article

• Can I use EXISTS keyword in sql query for assignment of result

  - by Shantanu Gupta

  Can I assign a value with EXISTS in the query. Currently it is giving me error Incorrect syntax near '='. But when I uses this query only it runs as expected. IF EXISTS (SELECT @PK_LOGIN_ID=PK_LOGIN_ID FROM dbo.M_LOGIN WHERE LOGIN_NAME=@LOGIN_NAME AND PASSWORD=@PASSWORD AND FK_ROLE_ID=@FK_ROLE_ID) RETURN @PK_LOGIN_ID …

  Read the article

• Help with a t-sql query

  - by user324650

  Hi Based on the following table Path ---------------------- area1 area1\area2 area1\area2\area3 area1\area2\area3\area4 area1\area2\area5 area1\area2\area6 area1\area7 Input to my stored procedure is areapath and no.of children (indicates the depth that needs to considered from the input areapath) areapath=area1 children=2 Above…

  Read the article

• Moving a Point along a Path in SQL Server 2008

  - by David Pfeffer

  I have a geography field stored in my database, holding a linestring path. I want to move a point n meters along this linestring, and return the destination. For example, I want the destination point 500 meters along the linestring starting from its beginning. Here's an example -- what is the YourFunctionHere? Or, is there…

  Read the article

• SQL & Linq To SQL Help

  - by cre-johnny07

  I have a table which is some thing like below.. Date ID 2009-07-01 1 2009-07-01 2 2009-07-01 3 2009-08-01 4 2009-08-01 5 2009-08-01 6 2009-09-01 7 2009-09-01 8 2009-10-01 9 2009-10-01 10 …

  Read the article

• Dynamically determining table name given field name in SQL server

  - by Salman A

  Strange situation: I am trying to remove some hard coding from my code. There is a situation where I have a field, lets say "CityID", and using this information, I want to find out which table contains a primary key called CityID. Logically, you'd say that it's probably a table called "City" but it's not... that table…

  Read the article

• Contains performs MUCH slower with variable vs constant string MS SQL Server

  - by Greg R

  For some unknown reason I'm running into a problem when passing a variable to a full text search stored procedure performs many times slower than executing the same statement with a constant value. Any idea why and how can that be avoided? This executes very fast: SELECT * FROM table WHERE CONTAINS (comments, '123') …

  Read the article

• SQL Server: "Mostly-unique" index

  - by Ian Boyd

  In a table i want to ensure that only unique vales exist over the five-column key: Timestamp Account RatingDate TripHistoryKey EventAction ========= ======= ========== ============== =========== 2010511 1234 2010511 1 INSERT 2010511 1234 2010511 4 INSERT 2010511 1234 …

  Read the article

• Need help with a SQL CTE Query

  - by Chuck

  I have a table that I need to get some specific data from for a view. Here's the base table structure with some sample data: | UserID | ReportsToUserID | Org ID | ------------------------------------- | 1 | NULL | 1 | ------------------------------------- | 2 | 1 | 1 |…

  Read the article

• T-SQL QUERY PROBLEM

  - by Sam

  Hi All, I have table called Summary and the data in the table looks like this: ID Type Name Parent 1 Act Rent Null 2 Eng E21-01-Rent Rent 3 Prj P01-12-Rent E21-Rent 1 Act Fin Null 2 Eng E13-27-Fin Fin 3 Prj P56-35-Fin…

  Read the article

• Error while trying to attach .mdf to a SQL Server Express 2008

  - by peace

  The snapshot says is it all - I used to be able to attach a database, but after i detached today then tried to attach, i kept getting this error: http://img197.imageshack.us/img197/2574/attacht.jpg

  Read the article

• SQL Duplicates Issue SQL SERVER 2000

  - by jeff

  I have two tables : Product and ProductRateDetail. The parent table is Product. I have duplicate records in the product table which need to be unique. There are entries in the ProductRateDetail table which correspond to duplicate records in the product table. Somehow I need to update the ProductRateDetail table…

  Read the article

• Creating an appropriate index for a frequently used query in SQL Server

  - by Slauma

  In my application I have two queries which will be quite frequently used. The Where clauses of these queries are the following: WHERE FieldA = @P1 AND (FieldB = @P2 OR FieldC = @P2) and WHERE FieldA = @P1 AND FieldB = @P2 P1 and P2 are parameters entered in the UI or coming from external datasources. …

  Read the article

• Multiple SQL Server Integration Services (SSIS) database instances on one machine

  - by kumar

  Hi, i want to configured the configuration file to use more than one MSDB database, which are stored in separated database instances in Stored packages of SSIS database. if any body knows let me know ? write in steps how to do..? Regards. kumar

  Read the article

• Linq to SQL - what's better?

  - by msony

  db.Albums.FirstOrDefault(x => x.OrderId == orderId) or db.Albums.FirstOrDefault(x => x.OrderId.Equals(orderId))

  Read the article

• Licensing SQL Server 2012 Reporting Services w/ SharePoint 2010

  - by Evan M.

  Here's my situation: I have 1 VM that is running SharePoint 2010 SP1. I have a different physical server that is running SQL Server 2008 R2 that hosts all the configuration and content database for SharePoint. Now, we want to start providing BI capabilities to our users with SharePoint and SQL Server. With…

  Read the article

• Passing delimited string to stored procedure to search database

  - by rs

  How can i pass a string delimited by space or comma to stored procedure and filter result? I'm trying to do something like - Parameter Value -------------------------- @keywords key1 key2 key3 Then is stored procedure i want to first find all records with first or last name like key1 filter…

  Read the article

• SQL SERVER Project

  - by Saif Omari

  My Application Database Without Project and without Source safe, i planned to make my DB to be as project and add it to TFS, but I have no idea how to script the stored procedures, Triggers, Views, Functions, and what is the best practice to Make Update Script for All My stored procedures, Triggers, Views,…

  Read the article

• SQL server 2008 trigger not working correct with multiple inserts

  - by Rob

  I've got the following trigger; CREATE TRIGGER trFLightAndDestination ON checkin_flight AFTER INSERT,UPDATE AS BEGIN IF NOT EXISTS ( SELECT 1 FROM Flight v INNER JOIN Inserted AS i ON i.flightnumber = v.flightnumber INNER JOIN…

  Read the article

< Previous Page | 54 55 56 57 58 59 60 61 62 63 64 65  | Next Page >