Rating Thread / Thread Starter	Last Post	Replies	Views
'System.OutOfMemoryException' ? (SQL 2005 on my PC, A table with 13 million rows) I just did select count(*) from T13M It ran for a while and I canceled it. Then I tried to see... nkw	09-10-2006 07:52 AM Dan Guzman	4	46
Formatting and returning Time from Text I'm importing a time field as datatype - char, from a text file to prevent the DTS package from erring - for some reason, if I import it into a... jonefer	09-10-2006 01:54 AM Arnie Rowland	3	47
Which function can convert number value to string with lead zero? Which function can convert number value to string with lead zero? e.g. 1 --> 00001 12 --> 00012 125 --> 00125 ABC	09-10-2006 12:30 AM Hari Prasad	1	41
Trigger question Using Sql Server 2000... We have a stored proc that is executed as a Trigger "on Insert"... If there is any error in the stored proc, then the... Rob	09-09-2006 06:40 PM Rob	0	44
Require One of 3 Columns NOT NULL ( 1 2 ) 2K5: How can I enforced the requirement that columns be NOT NULL? I don't care if 0, 1, or 2 of the 3 columns have a NULL value - I just want to... Smithers	09-09-2006 04:24 PM Hugo Kornelis	17	71
rows to column sql server 2000 Hi all, the query gives me the foll o/p as column1 column2 A 1 B 20 C 10 D 13 E ... xavier.sharon@gmail.com	09-09-2006 03:26 PM Steve Dassin	4	43
Migrate data from Access SQL 2005 hello everybody using the SSMA migration from Access 2003 to SQL 2005 is cool. then Robert Burke saved me a lot of... mikepallorad@ausi.com	09-09-2006 02:18 PM Steve Dassin	2	45
"Order By" Parameter to a Stored Procedure Can I pass a Parameter to Stored Procedure which will be the ORDER BY column to be used in a SELECT? If so, what's the syntax? Alex Alex Maghen	09-09-2006 01:19 PM Steve Kass	6	55
Copying data from 2000 to 2005. Indentity insert not working Hi: I'm at my wits end. When copying data from sql2000 to sql2005, identity columns are reseeded starting with 1. I have checked indentity insert... Charlie@CBFC	09-09-2006 01:18 PM Richard Mueller	3	45
Making Sql Server public? How can I make my SQL Server 2000 public? I'm moving a web application to another domain and I need to connect to it via my SQL Server IP Address. ... VMI	09-09-2006 12:55 PM Warren Brunk	1	54
Views Vs Stored Procedures! Hi all, Just a quick question about when to use views in contrast to stored procedures. For example, i have the following table: Subject: -... Child X	09-09-2006 11:08 AM Erland Sommarskog	3	53
ALTER TABLE HI FRENS, I WANT TO DROP PRIMARY KEY CONSTRAINT FROM A TABLE USING ALTER TABLE,PLEASE GIVE ME THE SYNYAX TO DO SO. VELMURUGAN.D velmurugan\(Internal\)	09-09-2006 09:37 AM Hari Prasad	3	52
SELECT INTO temp table - Pros and Cons We've been having a lively debate, at my office, about the pros and cons of using SELECT INTO versus CREATE TABLE/INSERT INTO when populating... John Smith	09-09-2006 05:17 AM Roy Harvey	2	58
Alter Seed value of Identity column Hi, I want to create temporary table, say "a" which has a column say "col1" which i wnt to be an identity for which I need to provide a seed... Prasad	09-09-2006 04:53 AM Prasad	2	48
Order by causing query to return very slow I have a pretty large query. It is selecting a distinct 2000 records. If the query returns 2000 records...it takes 11 seconds to run. There is a... mchi55@hotmail.com	09-09-2006 03:59 AM Erland Sommarskog	1	36
DECLARE and table strucutres We knew that we could retrieve the structure of a table via INFORMATION_SCHEMA.COLUMNS. Is there a way to convert the structure into a DECLARE... Man-wai Chang	09-08-2006 10:37 PM Man-wai Chang	5	55
UDF function ( 1 2 ) Can I create a function that can be a part of a SELECT statement and it would be capable of accepting a parameter that is a column name from one... Mark Goldin	09-08-2006 09:50 PM Kalen Delaney	14	97
Trigger testing We are currently having the following process finger-pointing issue... Assume you have the following situation... An Orders table A Shipments... Rob	09-08-2006 05:47 PM Erland Sommarskog	1	55
Exec cannot see Inserted? If I do the following withing a trigger: declare @SQLText NVarChar(4000) set @SQLText = N'select *, cast(''I'' as varchar(1)) as FlagUID into '... Michel Racicot	09-08-2006 05:38 PM Erland Sommarskog	4	66
Rounding datetime Are there any problems rounding up dates like this DECLARE @FiveDaysPrevious DATETIME SET @FiveDaysPrevious = '12/12/2006 2:12:12' SET... Sn0tters@yahoo.co.uk	09-08-2006 05:32 PM Erland Sommarskog	6	49
how to return only numeric chars from column? Hello, How can I return only the numeric chars of this data? CREATE TABLE #temp1 (col1 varchar(10)) INSERT INTO #temp1 SELECT 'abc123' union SELECT... Rich	09-08-2006 04:30 PM Rich	2	52
Is it possible to return all parent rows but only first child row of each parent for a t-sql join? Have two tables order and orderline. Is there a way in T-sql to get an inner join to return all order records but only the first orderline record of... Jia	09-08-2006 03:23 PM David Portas	1	55
error debugging in query analyzer Hi all, Is there a way in Query analyzer when selecting rows that I see the values of where an error occures? so I can see why it is failing at a... gv	09-08-2006 03:17 PM gv	0	45
Help with SELECT statement Ok, I've got two tables, Clients and History. The relevant fields look like this: Clients ----------- ClientID AccountNo History ----------- David	09-08-2006 03:17 PM David	2	50
Passing a table into a function I created a function and passing in a table however, it compains, Can we pass in a table to a function?? anhting wrong with this? can't see the... SQL Ken	09-08-2006 03:02 PM Mark Goldin	3	55
Query Works fine in Access but not in SQL Server Hello Experts, I am trying to create a Stored Procedure in SQL Server 2005 from a query that works fine in Access, but it does not work on SQL Sever... Richie	09-08-2006 02:49 PM Richie	2	54
can Case test for < or > values? Hello, SELECT CASE replace(@s,'sec','') WHEN 12345 then 'y' ELSE 'n' end returns 'y' I want to test if the numeric portion of the string is <... Rich	09-08-2006 02:30 PM Rich	3	60
Best way to insert data into tables without primary keys ( 1 2 3 4 ) I am working on a SQL Server database in which there are no primary keys set on the tables. I can tell what they are using for a key. It is usually... tomcarr1@gmail.com	09-08-2006 02:22 PM Arnie Rowland	34	179
Mdf and Ldf files Is there some sort of command that can tell me which mdf and ldf files are associated to which databases? Thanks, Ninel -- Message posted via... ngorbunov via SQLMonster.com	09-08-2006 01:46 PM Stu	2	56
SQL Guru's - please help paging with a distinct recordset Hi Guru's, I'm trying to use SQL Server 2005's new Row_Number() function to make my life paging data easier, but have run into a little propblem... PepperFleming@gmail.com	09-08-2006 01:35 PM Steve Dassin	5	49
Trigger Tricks ? I understand that if the code assiciated with a trigger fails, then the action that called the triger in the first place fails as well. Any way... Rob	09-08-2006 01:09 PM Rob	4	52
Can I create an index on a varable table I have a table defined inside a function. Can I index it? If so How? please give me a simple sample code thanks ke n SQL Ken	09-08-2006 01:00 PM SQL Ken	1	56
Check constraint script problem I am running SQL 2000 SP4. I submit the following syntax for the check constraint but when it is in SQL it is changed and all my parantheses are gone... SQLGuru_not	09-08-2006 12:47 PM SQLGuru_not	6	59
If NOT EXISTS I am working on a database generation script. In order to protect certain tables from regeneration I am checking to see if they already exist. But... Eric Cathell	09-08-2006 12:25 PM Eric Cathell	7	66
Best table structure for that? Hi all, I have a webpage where users can search for some text in a textbox. I'd like to have a feature that displays to them their last 5 or 10... ibiza	09-08-2006 12:07 PM ibiza	7	71
INSERT LOTS of values I have to INSERT Lots of Values from an Excel spreadsheet to a #temp table and then use the valus in this #temp table to update rows in our... wnfisba	09-08-2006 11:56 AM SQL Ken	3	55
query same table twice for different users in one query? How do I do the following in ONE query: I have a table, it has the structure of msgID, fromUserID, toUserID, msgContent fromUserID and toUserID are... Paul	09-08-2006 11:46 AM Paul	3	56
Update row with cursor joining to another table I have the following cursor process. My syntax joining to another table is failing. Is this possible??? Joining to another table to get a data value... wnfisba	09-08-2006 11:41 AM David Browne	1	53
How to limit date Range Dear all, I want to limit a select sql statement for specific month. e.g. for Jan it is : select * from table01 where tradedate >= '01/01/2006' and... hon123456	09-08-2006 11:41 AM newscorrespondent@charter.net	5	53
XQuery and Hierarchical Data Consider the simple XML Hierarchy below it is stripped of various attributes. 'Prop' is short for property as in a form of real-estate and each... Rob	09-08-2006 11:20 AM markc600@hotmail.com	3	45
Split zipcode + city ( 1 2 ) Hello I have a problem, I was given a table full of addresses and I found that zipcode and city were in same column, so I need to run an update... Lasse Edsvik	09-08-2006 10:59 AM SQL Menace	14	94
Query Works fine in Access but not in SQL Server Hello Experts, I am trying to create a Stored Procedure in SQL Server 2005 from a query that works fine in Access, but it does not work on SQL Sever... Richie	09-08-2006 10:00 AM Richie	0	56
pull table Schema Hi all, Is there a quick way to pull table Schema of a table? Like to see the name, datatype, size thanks gv gv	09-08-2006 09:59 AM gv	4	48
Query Analyser Debugger When I set breakpoints in the Query Analyser Debugger, they don't work. (The Stored Proc is executed but the debugger doesn't stop on... Michel Racicot	09-08-2006 09:53 AM Michel Racicot	1	55
Time difference between two values SQL SP Hi folks, i was wondering if someone could help me please. Basically i have started developing in SQL server recently - i am attempting to write a... csgraham74	09-08-2006 09:14 AM Roy Harvey	5	61
is there a ' combination join' of left outer and right outer join I have two tables as follow: Table1 Table2 StudentID StudentName 6 StudentID ... SQLken@gmail.com	09-08-2006 09:01 AM Mike C#	7	63
Update/Insert and Delete Query Optimisations Hallo NG, Consider the SQL queries attatched below. I have two versions each for two different tasks I want to perform. The one task performs either... Pieter Rautenbach	09-08-2006 08:43 AM David Browne	1	55
SQL Server 2005 - Recursive CTE Hi All: I have a table holding project information that links back to itself in a parent-child relationship. So a project can have sub projects... Chris van den Heuvel	09-08-2006 08:35 AM David Browne	3	75
working with gaps in date series I've seen some pretty creative SQL statements that locate first/last/missing elements in a series but I haven't been able to adapt any of them to... Steve	09-08-2006 08:14 AM Steve	8	69
Re: Problem tuning procedures with temporary tables Johan Sjöström wrote: Microsoft wants people using those wizards, because they can trumpet about "ease of use", trying to make SQL Server work like... Tracy McKibben	09-08-2006 07:28 AM Tracy McKibben	2	76

Page 547 of 1545

547

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