Sponsored Links

microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming

Page 67 of 1545

Threads in Forum : microsoft.public.sqlserver.programming

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
How to Recompile a Stored Procedure Without Executing ( 1 2 ) I have a database with a lot of stored procedures, and over time the schema has changed such that some sprocs won't run. It would be a headache to... Charles	09-04-2009 07:24 AM Charles	19	87
IRR calculation ( 1 2 ) Hi guys Has anyone here had any experience with internal rate of return (IRR)calculations on SQL Server. We have an asset management system where... N	09-04-2009 06:45 AM Charlie	11	332
displaing data horizontally hi; I am using sql server (msde) 2000 the report is already in excel manually updated need help with a sql statement. I have a transactional data... Ore	09-04-2009 12:40 AM John Bell	1	36
Finding a string match in a table Hello, I have a string that is entered on a website. I would like to create a procedure to find the records where the column value in a table is... Jack	09-03-2009 09:17 PM Plamen Ratchev	1	33
Date and Null Hello, On my Users table I have a column named LastLock. This column holds the last date where the account was locked. The problem is that some... shapper	09-03-2009 04:51 PM Erland Sommarskog	2	56
Finding Previous Next Using SQL Server 2008, I have 2 tables and need to figure out how to get the (max date) previous result and the (max date) future result... CREATE... dm	09-03-2009 04:36 PM dm	2	42
Trouble with a CASE WHEN multiple criterea statement I am not getting the results I am needing. I am trying to do a item called pace in this hierarchy Three types of capacity- with each cap type three... Paul Lambson	09-03-2009 01:20 PM Krystian Zieja	1	43
scheduling "CREATE INDEX" Hello: Is there a such thing as scheduling SQL to run a CREATE INDEX statement each night in order to create a table's index? It's easy to set up a... SQL Programmer	09-03-2009 12:11 PM Bob	2	47
I wonder at the difference in the name patterns I look at the DB names in a User Instance and I see the system names and Two DBs are named like: I:\MY DOCUMENTS\VISUAL... AAaron123	09-03-2009 11:57 AM AAaron123	6	44
Square characters in .sql file? Hello, received a .sql script file which is aimed in creating a new sql 2005 db and noticed a bunch of square symbol characters when opening it and... 7777	09-03-2009 11:25 AM Sylvain Lafontaine	4	33
ntile Dear ALL, I'd like to know if anyone of you knows what is formula for NTILE funcion. Regards Alberto	09-03-2009 09:56 AM --CELKO--	5	38
The database is being closed before database mirroring is fully initialized. The ALTER DATABASE command failed ALTER DATABASE DBNAME SET PARTNER = N'TCP://??.???.???:5022' ------------------------*/ Msg 1414, Level 16, State 1, Line 1 The database is being... Dima Abramov	09-03-2009 09:49 AM Dima Abramov	2	38
Selection by part of a field Hi, I'm fairly new to using SQL. I have a database with a field where I once combined two values (sometimes) into one (the original db dates back 15... Larie Koek	09-03-2009 01:05 AM Larie Koek	6	46
Linked SERVER Issues Hi All Trying to setup a linked server in SQl Server Express 2005 is driving me nuts I created a Linked server in SSME, selected SQl Server as... Steve	09-02-2009 04:43 PM Steve	6	39
Searching a last name I'm trying to find a last names that begin with a "M". I thought the "%" option meant at the beginning of line, but this returns records like... Scott	09-02-2009 03:56 PM --CELKO--	5	44
Jobs problem Gurus It appears that in one of our production servers there is a situation.It seemed that in the view of the progress of the job it is running but... Bill_Orova	09-02-2009 02:10 PM Russell Fields	2	37
Query alternate views, per user's choice Is there an approach that permits querying one of two identically structured views depending on the user's choice, other than using an IF? So, an... Duke Carey	09-02-2009 11:48 AM Duke Carey	3	33
Restore of DB Backup gave some errors Hello, I have a database that I have managed for many years now. I have done many backups and restores with no problems. Today I did a restore... JPK	09-02-2009 10:30 AM JPK	4	115
Updating across databases not working if a value is null I tried to format this... :-) This is a update trigger example for a database called Database1 and a table called DatabaseTable. When I update a... danid12	09-02-2009 10:19 AM ML	3	49
Same query returns two different results Hi all, using sql 2008 sp1 32-bit Here is strange one maybe someone could shed some light. In studio when runing the same query in two different... gv	09-02-2009 09:53 AM gv	4	39
Current DILBERT series I am surprised that nobody has made fun of me with the current series in DILBERT on Standards. What is the funof being Troll bait, if nobody bites?... --CELKO--	09-02-2009 09:46 AM Smokey Grindel	5	42
openquery question: using it inside "WHERE field IN(" ? I have two working SQL queries: EVENTS: SELECT memberid FROM OPENQUERY(events,'SELECT * FROM registrations WHERE eventid = 1615') CRM: SELECT... Kevin Blount	09-02-2009 08:28 AM Kevin Blount	4	32
Parse as records are added We have a device that can log events to a SQL server, but it only send fields: EventDate EventTime Device Message and a few others The Message... Jordan	09-02-2009 05:57 AM ML	2	61
Throttling connections, custom connection pooling Hi, - cross posting from ADO.NET newsgroup - what are the proper design patterns for throttling sql server command execution/the number of... dlosch	09-02-2009 12:54 AM dlosch	3	31
String after third space Is there a function in SQL 2000 that will find a string between the 3rd and 4th space so if I had a string fields that contained "Today is Tuesday... Chris	09-01-2009 10:56 PM Chris	3	45
Dynamic UNPIVOT using FOR XML and nodes() Hi. My SQL knowledge often benefits from browsing this newsgroup. Today I would like to benefit others and share a way I solved one of my own... Farmer	09-01-2009 10:17 PM Farmer	2	39
Disable trigger failed I've tried disabling a trigger via SSMS (VS2005) query window and it takes forever 'executing', until I just cancel it. When I use right click on... danid12	09-01-2009 05:28 PM danid12	3	36
NEWSEQUENTIALID() behaviour while adding a default to the existing table I'm considering binding a default with the NEWSEQUENTIALID() function in it for the Clustered PK on the existing table to avoid fragmentation... mEmENT0m0RI	09-01-2009 05:21 PM mEmENT0m0RI	9	35
Performance Issues with exec(SQL)? I need to create a solution to populate some reporting tables. Whatever I come up with will be used in different locations, therefore the source and... gambool	09-01-2009 05:07 PM Erland Sommarskog	2	40
collations and Unicode string processing Hi - The environment here is a SQL 2k5 Std Edition instance on a Win 2k3 Std Edition box. The collation of the databases and the default for the... Steve M	09-01-2009 02:57 PM Steve M	9	35
Insert NULL into Char column? ( 1 2 ) SQL Server 2005 and 2008: I have a table with a column defined as Char. The table contains a dozen rows where the Char column contains a NULL value... Dean Slindee	09-01-2009 02:22 PM slindee	10	62
Using .NET Assembly as stored proc I'm hoping someone here can help answer a few questions for me regarding using .NET Assemblies as stored procs (or referencing them inside stored... JDeats	09-01-2009 01:25 PM Bob Beauchemin	2	35
Question about database name and Initial Catalog If I attach a database and the connection string includes an Initial Catalog I find the database name is different than if I don't include an... AAaron123	09-01-2009 01:04 PM AAaron123	3	31
Syntax on xp_instance_regwrite I'm having an issue with xp_instance_regwrite in getting values stored into the registry from a SQL 20008 enterprise server running with sp1 on win... tom	09-01-2009 01:01 PM tom	2	29
Insert Order Hello, On a table, when not using Id Identity as PK, is it possible to get the order of the inserted records based on Created Date? CreatedDate is... shapper	09-01-2009 12:09 PM Russell Fields	4	57
Get Values from same table Lets say I have a table called info and it has 5columns. The first column is called Emp_id, the second is last_name, third is called first_name,... Big Ern	09-01-2009 11:52 AM Big Ern	4	44
Get Id value Hello, I am mapping the following SQL table using Entity Framework: create table dbo.Assets ( Id int identity not null, Content nvarchar(max) not... shapper	09-01-2009 10:31 AM Lucas Kartawidjaja	5	32
Append 1st view to 2nd view results Hi Experts I have 2 views (View1 and View2) that produce different recordsets but the column name are the same. I would like a third view (View3) to... jez123456	09-01-2009 07:48 AM sloan	1	42
text as an output type I need to return a text data type as my output type, but I get the error : Invalid parameter 2 ('@FileLocation'): Data type 0x23 is a... Mike P	09-01-2009 07:30 AM Tibor Karaszi	1	36
SqlParameter is already contained by another SqlParameterCollectio I am getting the following error: "The SqlParameter is already contained by another SqlParameterCollection." In the code below, the error occurs... MCM	09-01-2009 06:35 AM Charles Wang [MSFT]	3	71
Scripts -> Create Database The create database scripts in sql 2008 appear to work differently to 2005, in that they seem to point to the database files to attach, rather... j	09-01-2009 05:32 AM j	1	29
Code to compare with Calendar table Hello, ---DDL start --- CREATE TABLE #test ( Tid TINYINT PRIMARY KEY, Team VARCHAR(10), CHAR(1) CHECK ( in('P','B')), Abba	09-01-2009 04:32 AM Abba	9	20
help with a query probably cursor declare @test table (prodid int, serialno int) insert into @test select 1, 2220 union all SELECT 1, 2221 UNION ALL SELECT 1, 2222 UNION ALL SELECT... VJ	08-31-2009 09:09 PM Plamen Ratchev	1	35
group by and concatinate all matches into one single column commadelimited Hello. I'm stuck. I've got this stored procedure that produces a temporary table. It works great, but I need all unique emails for a given dbname... jc	08-31-2009 05:03 PM Erland Sommarskog	3	27
using EXECUTE AS for stored procedures, sql 2005 Can you define "Owner" when using EXECUTE AS Owner for a stored procedure? Does that mean the stored procedure will be executed as the owner of... msnews.microsoft.com	08-31-2009 05:01 PM Erland Sommarskog	3	28
Need a script to add a new primary key to all tables in db ( 1 2 3 4 5 ... Last Page) On Tue, 25 Aug 2009 10:37:24 -0700 (PDT), --CELKO-- wrote: Great when you have a foreign key with cascading updates, of course. But how deep is the... suslikovich	08-31-2009 03:45 PM Hugo Kornelis	59	119
SQL statement need help ( 1 2 ) Hi, I have a column called ATU in a table xyz and the values of ATU are ATU --------- AS01 AS02 AS03 AS04 Learner	08-31-2009 03:33 PM simon whale	11	59
How to UPDATE One Record From Two Records Hello, Say I have a table with columns Table1(Id, ValueA, ValueB) and I want to update its values from a subquery with columns Table2(Id, ValueID,... Ed	08-31-2009 03:30 PM Plamen Ratchev	7	20
PIVOT newbie...need a starting point Hi, I assume someone here knows the Pivot function? :) i could use some help. I've never used it before so i'm pretty lost. Could someone get me... Jason R. Soby	08-31-2009 12:09 PM Plamen Ratchev	1	26
Info on Page headers I came to know from an article that each data page has a 96bytes reserved for headers. So it means 8192 byes - 96 = 8096 bytes (for each row). Then... SqlBeginner	08-31-2009 11:41 AM Kalen Delaney	2	18

Page 67 of 1545

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off