dbTalk Databases Forums  

Sponsored Links


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


Discuss in the microsoft.public.sqlserver.programming forum.



Post New Thread
Threads in Forum : microsoft.public.sqlserver.programming Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Say I have a Table A with 100,000 rows and 4 columns, and a Table B of 10,000 rows and 15 columns. Table B is a subset of Table A, and has...
Bob
08-25-2004 01:36 PM
Bob Go to last post
3 43
http://c2.com/cgi/wiki?WhatIsNull http://c2.com/cgi/wiki?NullsAndRelationalModel -- Roji. P. Thomas Net Asset...
Roji. P. Thomas
08-25-2004 12:57 PM
JMNUSS Go to last post
2 36
Bob, Even with an "association" table which has the referencing values, you could use the UPDATE CASCADE and DELETE CASCADE options in the...
Bob
08-25-2004 12:57 PM
Bob A. Go to last post
3 36
I've got an Access app that has a module that calls a SQL 2k DTS package. It works just fine on my box of course. When I try to deploy it to...
Andre
08-25-2004 12:51 PM
Andre Go to last post
2 42
Hi Ferrill, you can pass all data types, including text, ntext and image, as a parameter to a stored procedure. However, the cursor data type can...
hkvats_1999@yahoo.com
08-25-2004 11:22 AM
Russ Ferrill Go to last post
3 30
Please help me. I have to do a report on date wise. I want to pull data from 10 tables and group them by date . There is only one field common in...
Rakki
08-25-2004 11:18 AM
Adam Machanic Go to last post
1 38
Hi, Is there any way to use macro substituion in sql server ? In a stored procedure I am having some variables like var1, var2, var3, var4,var5. I...
Pramod Thewarkar
08-25-2004 11:02 AM
Adam Machanic Go to last post
3 45
(.)= 'Null') is probably the answer to where you convert a string to a date. I guess you want . IS NULL. -- Jacco Schalkwijk SQL Server MVP
Jacco Schalkwijk
08-25-2004 10:55 AM
Tamas Bojcan - bojci Go to last post
2 36
Hi, can anyone tell me how to keep trailing whitespace in an NVARCHAR field? I have an NVARCHAR column with a unique constraint, where the strings...
Stu Smith
08-25-2004 10:52 AM
Stu Smith Go to last post
2 42
"Raymond D'Anjou (raydan)" wrote Ah, merci:)
toylet
08-25-2004 09:26 AM
Pike Go to last post
3 40
yea. you can set SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED -- Roji. P. Thomas Net Asset Management https://www.netassetmanagement.com
Roji. P. Thomas
08-25-2004 09:11 AM
Aaron [SQL Server MVP] Go to last post
5 49
I have a DTS package which has an ActiveX Task. I want to add a line into the ActiveX task that will run the folowing as if it were run from...
nh
08-25-2004 09:08 AM
nh Go to last post
5 46
Hello I need to store small numbers with 2 decimals? 0.22, 0.44, 1.23, at most 2.00 which datatype would suite best? TIA /Lasse
Lasse Edsvik
08-25-2004 08:50 AM
Aaron [SQL Server MVP] Go to last post
10 63
Hello, What is the optimal way to insert multiple rows (around 1000) from a web application into a table? The user enters multiple lines into a...
Arsen V.
08-25-2004 08:41 AM
Toby Herring Go to last post
5 50
Is there any way to filter the following statement on the "Count" colunm? I try Where "Count" = 1 and I get an error, Invalid column name. select...
Mike
08-25-2004 08:39 AM
Tamas Bojcan - bojci Go to last post
15 64
In your INSERT statement, specify the column names. And in the SELECT statements, specify the column names. For both, do not specify the identity...
Tibor Karaszi
08-25-2004 08:34 AM
Toby Herring Go to last post
1 39
Hello, I want to format my float number to a precison of .5 i.e: 30.1 => 30 30.5 => 30.5 30.6 => 31 How is this possible?
Guy Brom
08-25-2004 08:21 AM
Erland Sommarskog Go to last post
5 33
Hi, I am trying to make a Resume Database. But there are some issues. I get resumes in word format. I want to store these resumes and be able to do...
student
08-25-2004 08:18 AM
Erland Sommarskog Go to last post
8 40
Hi all, I understand that when I am denied access from the table but given the right permission in a sproc accessing the table, I am still able to...
Ryu
08-25-2004 08:07 AM
Dan Guzman Go to last post
4 33
Hi, I use in my data base smalldate data type. When I use select statement the date is like 8/24/2004 12:32:56PM (m/dd/yyyy time). Is it possible to...
Viktor Popov
08-25-2004 07:53 AM
KPiszcz Go to last post
4 51
Niall, The parameters to the method are also passed as the parameter to the sp. So the call should be EXEC @hr = sp_OAMethod @QMAcc, 'MakeKeys',...
nh
08-25-2004 07:46 AM
Roji. P. Thomas Go to last post
3 52
Hi Is it possible to loop through the Files in a directory and delete certain ones based on there names. Would I use FileSystemObject for this...
Ian
08-25-2004 07:32 AM
Ian Go to last post
3 34
Hi all, I'm some combination of stupid and stuck in the DMZ between systems. I'm trying to set up a linked server in SQL Server into a Visual...
John Spiegel
08-25-2004 07:26 AM
John Spiegel Go to last post
3 48
Hi all! I have a Windows service, where I want to use a timer.. But i does not seems work?? It does not catch the Timer1.tick event ??? But the code...
Henrik H
08-25-2004 07:13 AM
Roji. P. Thomas Go to last post
1 38
Hi Why would this error stop the execution of my Stored procedure. Server: Msg 8501, Level 16, State 3, Line 1 MSDTC on server 'Server1'...
Ian
08-25-2004 06:51 AM
Ian Go to last post
3 37
Hi, Maybe you can help me with following problem: I am running a VC++ program using ODBC to connect to a MS SQL-Server2000 instance (running on a...
Andy
08-25-2004 06:37 AM
Tamas Bojcan - bojci Go to last post
1 41
Hi, How to decrypt stored procs? We are using MS SQL Server 2000. Can some one let me know please ... Many thanks in advance, Harish...
Harish Mohanbabu
08-25-2004 06:03 AM
Narayana Vyas Kondreddi Go to last post
2 40
I need to read eventlog entries looking for login/logout events so that I could update a table that tracks the worked hours of the employees in...
David Lightman Robles
08-25-2004 05:46 AM
Narayana Vyas Kondreddi Go to last post
1 42
"exBK" <exBK (AT) discussions (DOT) microsoft.com> wrote It's very difficult to pull back adjacency lists in sorted order, which is why a lot of...
David Browne
08-25-2004 05:26 AM
Harag Go to last post
4 39
Should I explicitly drop temp tables that I have granted or should I let Sql Server handle that for me? My purpose is to release resources. Thanks .
Ryu
08-25-2004 04:19 AM
Narayana Vyas Kondreddi Go to last post
2 38
declare @b datetime declare @e datetime set @b = '01/01/03' set @e = '12/31/04' select case when datediff(mm, @b, @e) = 0 then 1 else datediff(mm,...
Gregory A. Larsen
08-25-2004 04:17 AM
Roji. P. Thomas Go to last post
2 36
Hello all, What would the difference be between SQL 7.0 and SQL2000 ? The reason for my question is that I have been offered a contract to create an...
Dingus
08-25-2004 04:16 AM
Jacco Schalkwijk Go to last post
1 49
im a newbie.. i want to learn using function in a stored procedure and query analyser.. any example or url can u offer me?
Savas Ates
08-25-2004 03:59 AM
Roji. P. Thomas Go to last post
2 52
Here is the DDL of my database CREATE TABLE . ( (18, 0) NULL , (18, 0) NULL ) ON GO I have an array of proxy_key (1,2,3,4)
Yaheya Quazi
08-25-2004 01:57 AM
Uri Dimant Go to last post
10 73
Hello, I have two tables named errorstarttime and errorstoptime. Errorstarttime has columns errorid, starttime and errorstoptime has erroridoff,...
Saron
08-25-2004 01:33 AM
Saron Go to last post
7 39
Is there an easy way to retreive just the integer portion of a number without using the FLOOR or CEILING functions? Thanks for the help. Derek...
Derek Ruesch
08-25-2004 12:38 AM
Steve Kass Go to last post
4 30
Thanks but passing the params to the SP is not a Problem. SPs balk at the .... AS StaffName, 0 AS ListItems, 0 AS ListComm, etc...
Henry Craven
08-25-2004 12:04 AM
Steve Kass Go to last post
7 37
sql2k sp3 Howdy. Im trying to return the year and quarter in a string inside a UDF and having data type issues. The desired output would be...
ChrisR
08-24-2004 09:24 PM
ChrisR Go to last post
3 45
This is a report & you should use your client side programming language or a report-writer to so such transpositions. SQL resultsets are virtually...
Anith Sen
08-24-2004 09:09 PM
Pike Go to last post
4 42
Hi, I have a web site that is choking when we do a search using the query that I built. I want to be able to use the Index Search from SQL Server...
Rafael Chemtob
08-24-2004 09:01 PM
John Kane Go to last post
1 66
I have the following script that if I execute one step at a time, works fine. However, if I try to execute it all at once, it does not at...
Robert Taylor
08-24-2004 08:06 PM
Tom Moreau Go to last post
11 83
Hi, Can some people tell me how they deal with apostrophe's in varchar column's At present I have created a couple of routines in my .Net code and...
Steve Lloyd
08-24-2004 07:55 PM
John G. Go to last post
2 53
Hello, I'm a bit confused as to what's been going on with the math in SQL Server. When numbers of high precision are being divided they can come up...
Bri Gipson
08-24-2004 06:58 PM
Bri Gipson Go to last post
3 27
I am more of a programmer than a database expert. I was asked the following question at an interview that I could not answer. The question was: Say a...
Paul
08-24-2004 05:36 PM
Paul Go to last post
9 35
On Tue, 24 Aug 2004 12:43:07 -0700, "James Ma" <James Ma (AT) discussions (DOT) microsoft.com> wrote: Hi James, Do I understand you correctly that...
Hugo Kornelis
08-24-2004 04:58 PM
David Portas Go to last post
6 36
Thanks for any help. -- Requirement: -- Create check constraint that verifies that newly inserted entries are not overlapping existing -- En entry...
news.microsoft.com
08-24-2004 04:41 PM
news.microsoft.com Go to last post
4 34
Unfortunately you haven't told us which row you want from TableB. TOP without ORDER BY is meaningless and just returns an arbitrary row. Even though...
David Portas
08-24-2004 04:31 PM
David Portas Go to last post
3 53
I found a very strange situation when I was troubleshooting why one of my statements was running so slow for the Alert Service. Take a look at...
Donnie
08-24-2004 04:23 PM
Tibor Karaszi Go to last post
1 43
Hi all, I have a problem when passing back the custom Error Messages from SQL Server Stored Procedure to VB.Net or VB 6. In my stored procedure , I...
Jie
08-24-2004 04:12 PM
Tibor Karaszi Go to last post
3 37
I'm new to the windows side of things and sql server. I'm trying to move a database in msde to sql server. The sql server is a shared hosting account...
Jay Donnell
08-24-2004 03:52 PM
Partha Mandayam Go to last post
3 39
Post New Thread

Display Options
Showing threads 52751 to 52800 of 69251
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.