Search Results

Search found 4908 results on 197 pages for 'ssas 2005'.

Page 48/197 | < Previous Page | 44 45 46 47 48 49 50 51 52 53 54 55  | Next Page >

• Convert SQL server datetime fields to compare date parts only, with indexed lookups

  - by Caveatrob

  I've been doing a convert(varchar,datefield,112) on each date field that I'm using in 'between' queries in SQL server to ensure that I'm only accounting for dates and not missing any based on the time part of datetime fields. Now, I'm hearing that the converts aren't indexable and that there are better methods, in SQL Server 2005, to compare the date part of datetimes in a query to determine if dates fall in a range. What is the optimal, indexable, method of doing something like this: select * from appointments where appointmentDate='08-01-2008' and appointmentDate<'08-15-2008'

  Read the article

• Case Order by using Null

  - by molgan

  Hello I have the following test-code: CREATE TABLE #Foo (Foo int) INSERT INTO #Foo SELECT 4 INSERT INTO #Foo SELECT NULL INSERT INTO #Foo SELECT 2 INSERT INTO #Foo SELECT 5 INSERT INTO #Foo SELECT 1 SELECT * FROM #Foo ORDER BY CASE WHEN Foo IS NULL THEN Foo DESC ELSE Foo END DROP TABLE #Foo I'm trying to produce the following output: 1 2 3 4 5 NULL "If null then put it last" How is that done using Sql 2005 /M

  Read the article

• find the all the stored procedures and jobs in sql server 2000

  - by kumar

  Hi, In SQL SERVER 2005 This query works fine : Select * from sys.procedures where object_definition(object_id) like '%J%' SELECT * FROM MSDB.DBO.SYSJOBS WHERE NAME LIKE '%J%' but in sql server 2000 it is not working. Here i need to find the all the stored procedures and jobs which matches my string ? how to find in sql server 2000 ? regards, kumar

  Read the article

• testing for one item in dictionary<k,v>

  - by rod

  Hey All, I'm using VS 2005 fx2.0. If I know my Dictionary contains only 1 item how do I get to it? Thanks, rod

  Read the article

• SQL - SSMS2005 - How do I copy a database diagram to another database?

  - by hamlin11

  Is there a simple method for copying a database diagram from one database server to another? I have a diagram on a development server that needs to be moved to the production server. Thanks (Sql server 2005, SSMS2005 Express)

  Read the article

• Is defragging tough on replication?

  - by Jim

  I've been told that defragging causes the log to grow tremendously. Is this true? If so, is there something better to do than defragging that will not impact the log as much? We are running SQL Server 2005 replicating between 2 sites.

  Read the article

• sql server: import operation won't copy full schema

  - by P a u l

  I recall that the import tool in sql server 2000 would copy indexes, relationships, etc. In sql server 2005/2008 the import tool in SSMS will only create the tables, copy the data, but the keys, indexes, relationships are missing. I can find no option in the import wizard to enable this? What am I missing here? Is this not possible anymore for any good reason?

  Read the article

• How to extract custom tokens in SQL Server NVarChar/VarChar field by using RegEx?

  - by Kthurein

  Is there any way to extract the matched strings by using Regex in T-SQL(SQL Server 2005)? For example: Welcome [CT Name="UserName" /], We hope that you will enjoy our services and your subscription will be expired on [CT Name="ExpiredDate" /]. I would like to extract the custom tokens in tabular format as follows: [CT Name="UserName" /] [CT Name="ExpiredDate" /] Thanks for your suggestion!

  Read the article

• How to use CREATE LOGIN sql statement?

  - by truthseeker

  Hi, How to use CREATE LOGIN statement on SQL Server 2005? I was trying nearly everything, with commas, without them, with strings, without them etc. CREATE LOGIN @loginame WITH PASSWORD = 'pass', DEFAULT_DATABASE='dbname' DEFAULT_LANGUAGE='us_english', CHECK_POLICY= OFF; I always get below error: Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

  Read the article

• visual studio recognizing .asp properly or suggestion for classic asp editor/iDE

  - by Neil Warner

  How do I get visual studio 2005 to work best with .asp files? I used to have this on my old PC but I can't get the settings right. I exported and important all my old settings and still no dice. alternatively I think there might be an even better choice for classic asp IDE editor. It'd be nice to have intellisense, completion, highlighting, stuff like that for ASP (vbscript) and css/html at the same time. (I'm happy not to type out css selectors) thanks

  Read the article

• How to tell visual studio that i have installed visual C# too?

  - by Rajesh Kumar

  I got visual studio 2005 express edition installed on my machine.But it did not contain any C# or web developer with it. So i later installed visual C# too. Now , I can create a C# project through visual C#. But I cant use visual studio for the same purpose. I guess there would be some mechanism to integrate visual C# with visual studio. Can anyone help me out?

  Read the article

• SQL query that returns columns form table A plus a bit column that specifies with the PK of table A

  - by dannie.f

  How can I write an efficient SQL query that returns columns form table A plus a bit column that specifies whether the PK of table A exists in table B? I am using MS SQLServer 2005. Thanks.

  Read the article

• SQL Server connection help...

  - by Gopal

  Using SQL Server 2005 I have the server connection name as (server1) in windows authentication mode, I want to change windows authentication mode to sql server authentication mode... when i try to change sql server authentication mode with username = sa & password = sa, it showing error... How to change the authentication mode or how to create a new sql connection?

  Read the article

• Visual studio settings css

  - by skamale

  My css file does not show any color high lights for the css what are the studio setting to enable it.Also my css intellisence won't work. I am using visual studio 2005. kindly help

  Read the article

• Creation date column in SQL table

  - by MatsT

  What is the easiest way to automatically fill a datetime column in an SQL data table with the date the row was created? Using SQL Server 2005 if that matters.

  Read the article

• how to forward engineer database diagram from visio 2003 file ?

  - by dotnetcoder

  I came across some vb macros that export it to a mdb ( ms access ) file. But does not work very well when copying forward constraints , etc. I want generate schema from the database diagram for sql server 2005 database.

  Read the article

• In a stored procedure how to run a query and conditionally do something

  - by Greg

  How would I do this in a stored procedure (SQL 2005): count = select count(*) from table1 where line like '%success%' if count > 0: delete from table1 where not line like '%success%' Thanks for any help. My google skills are really failing me today :-(

  Read the article

• How can I add a binary device driver in Platform Builder for Windows CE 6.0?

  - by Jaime Soriano

  I need to add a device driver to a Windows CE image, I have the driver in .dll and .reg files and in a .cab package. I'm using Visual Studio 2005 with Platform Builder for Windows CE 6.0. How can I do that?

  Read the article

• How to make the process quicker?

  - by dewacorp.alliances

  We build a system that handling the billing analyse and what it does it just have a raw bill from vendor and process to "common" table and this is using SQL Server 2005 Integration Services. At the moment, the batch has 300,000 rows and it took about 6 minutes to process. Now, the current spec are: 2 CPUs Intel Xeon E5345 @ 2.33 GHz RAM 4GB Is there anyway I can speed up this process?

  Read the article

• WCF 3.0 Service Contract method will return 992 rows but not 993 rows. 50 column observable collecti

  - by Ferrell Carr

  Exact duplicate of: http://stackoverflow.com/questions/2845454/wcf-3-0-service-contract-method-will-return-992-rows-but-not-993-rows-50-column My VS.Net 2005 CF 3.0 WCF will has a limit on how much data it will return

  Read the article

• Bulk updation of sql server table using xml

  - by Nimesh

  How can i update bulk data in sql server 2005 by sending the data in XML form ? i am able to insert bulk data into the table, but i am not getting idea to update the data.

  Read the article

• bulk insert to SQL Server, insert statements vs one insert XML statement?

  - by Henry

  The application layer (ColdFusion) needs to insert multiple rows onto SQL Server 2005. I was thinking of using loop in app layer to construct multiple input statements and send to SQL Server over JDBC in a single connection. My colleague however suggests to construct an XML and bulk insert the XML instead. Which one is the better method?

  Read the article

• SQL Server Transactions how can I commit my transaction

  - by codingguy3000

  I have SQL Server 2005 stored procedure. Someone one is calling my stored procedure within a transaction. In my stored proc I'm logging some information (insert into a table). When the higher level transaction rolls back it removes my insert. Is there anyway I can commit my insert and prevent the higher level rollback from removing my insert? Thanks

  Read the article

• How to organize infinite while loop in mssql ?

  - by alpav

  I want to use infinite WHILE loop in SQL 2005 and use BREAK keyword to exit from it on certain condition. while true does not work, so I have to use while 1=1. Is there a better way to organize infinite loop ? I know that I can use goto, but while 1=1 begin .. end looks better structurally.

  Read the article

• How do you extract just date from datetime in T-Sql?

  - by Grand Master T

  I am running a select against a datetime column in SQL Server 2005. I can select only the date from this datetime column?

  Read the article

< Previous Page | 44 45 46 47 48 49 50 51 52 53 54 55  | Next Page >