all groups > sql server (microsoft) > january 2007 > threads for january 22 - 28, 2007
Filter by week: 1 2 3 4 5
LEFT JOIN Question
Posted by David Fabian at 1/27/2007 3:58:07 PM
TableA TableB
Name ID_A ID_A MoreData
AAA 1 1 111
BBB 2 1 222
CCC 3
SELECT * FROM TableA
LEFT JOIN TableB ON ... more >>
SQL 2005 Compact Edition
Posted by Joe Spears at 1/26/2007 7:34:59 PM
Hi
Does anyone know if SQL Server 2005 Compact edition supports T-SQL Stored
procedures??
Thanks
... more >>
large SP performance difference between identical servers
Posted by Bob Speaking at 1/25/2007 11:56:07 PM
Hi at all,
first post in this NG (i usually walk around .net programming ng :P )
I've decided to write cause I have a strange (Strange for me.. I'm a
beginner with sql server).
well...too words....i go directly to question :
I have 2 sql server installed on 2 identical machines (same cpu... more >>
URGENT:SQL SERVER conveting date to integer
Posted by Usha at 1/25/2007 1:23:45 PM
Hi
I have a date column.I want to convert this date to integer.Similarily
I want to convert current date to integer and find the difference
between these two dates
Please let me know regarding the same.
Regards
Usha
... more >>
Scheduled Job fails, but package runs successfully...
Posted by None at 1/25/2007 8:58:06 AM
Hi all,
I have a DTS Package which imports data from a different server. this
job is scheduled twice a day and at times the scheduled job fails with
an error... Not all times, only some times the failure occurs.
Description : MSHSRMNSUKP0056 (SQLSERVERAGENT[208]) - Action=Please see
Ops Doc... more >>
Text always truncated in Update Query - SQL Express 2005
Posted by cptrinse NO[at]SPAM gmail.com at 1/24/2007 8:02:07 AM
I have a very simple query:
-- =============================================
-- Author: #########
-- Create date: ########
-- Description:
-- =============================================
ALTER PROCEDURE [dbo].[###########]
-- Add the parameters for the stored procedure here
@quoteid in... more >>
2005 - BOL as CHM ?
Posted by northof40 at 1/23/2007 1:23:51 AM
Hi - I've recently installed 2005 and I would much prefer BOL etc in
the old format (CHM ?). Is this available anywhere ?
Failing that could anyone tell me :
1. How can I arrange it so that I never see anything else but the
internal help. I've tried turning off 'online' but the search functi... more >>
Problem with view
Posted by Chris at 1/22/2007 3:37:47 PM
I am trying to create a view that creates a mailing list from two
different tables. The t-sql code executes successfully but when I try
to open the view I get this error message [Microsoft][ODBC SQL Server
Driver][SQL Server]Error converting data type vchar to float.
Here is the t-sql code I ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|