|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
how can I put this into one query
Al Newbie -
17 Dec 2005 11:14 PM - 3 messages
I have a table (tblJobs) that has a delivery date - to this date I want to add a set amount of 'working' days I have a table of dates with columns that specify whether the date is a weekday and a holiday. ...
Ordered Insert misleading syntax
Martin -
17 Dec 2005 10:22 PM - 11 messages
Hi, I've recently read that I can't do ordered inserts, which is a shame. However the following syntax appears to be valid DECLARE @TimeLine TABLE(EventID int IDENTITY(1,1),EventType int,EventKey varchar(50),[Date] varchar(50)) ...
SQL types
GTN170777 -
17 Dec 2005 9:54 PM - 4 messages
Hi can anyone explain the diferences between the various SQL Server licences i.e - Express/Workgroup/Standard/Enterprise I'm building an ASP application and have gone for SQL instead of Access due to the number of concurrenr queries it allows. The application sits on a ...
Decimal or Float Type in Percent
Scott -
17 Dec 2005 9:42 PM - 4 messages
Below is a sniplet of a select expression that returns a decimal number like ..6153329998 The result is correct, but when I say FormatPercent(objRS("myPercent"),3) in ASP, I get a type mismatch error. Both myField1 and myField2 are integer type. I have to CONVERT myField1 into ...
Access to another database via a stored procedure
et -
17 Dec 2005 9:26 PM - 4 messages
I have a stored procedure on a database that selects information from another database, and the users running the stored procedure are not users on the 2nd database. I don't want to have to enter all users individually ...
GETDATE() to insert into a datetime field
GTN170777 -
17 Dec 2005 7:22 PM - 14 messages
Hi there, may seem like a really silly question, but i am new to SQL. I'm building as ASP application in Dreamweaver MX2004 i'm using the insert record behaviour to upload information to the SQL Server. one of the fields ...
Getting the corresponding primary key from MAX()??
Greg -
17 Dec 2005 6:35 PM - 3 messages
I think this should be easy, but maybe my brain is just not working today, can anyone offer suggestions? I have a table, Table1 (simplified): ID dollars 1 15 ...
login event in sql server ??
helmut woess -
17 Dec 2005 6:03 PM - 6 messages
Hi, is there a way in SQL 2000 to check a new login and to stop it? I want to be informed if a user makes a new connect, then i want to check the program name he uses for connect and if this is not a valid name i want ...
what is wrong with this UDF?
Al Newbie -
17 Dec 2005 6:03 PM - 16 messages
I have this UDF but it comes back with the message: The column prefix c does not match with a table name . .. what is it that I have done wrong - the query works fine by itself . . . . CREATE FUNCTION dbo.AddWorkDays ...
about CTE in SQL 2k5
congling -
17 Dec 2005 1:21 PM - 4 messages
Hi all, I tested a new feature of SQL2005 (named cte for recursive selection) and found the order of the result was weird. According to the description of help: 1. Split the CTE expression into anchor and recursive members. ...
SQLDMO:To Change Database file Location path of DBBackup file ( VC
Inthi -
17 Dec 2005 11:45 AM - 2 messages
Dear all I am creating a tool in VC7.0 for database restoration I am facing a problem while working with sql dmo objects i need to restore a database, which has database location as "C:\Program Files\Microsoft SQL ...
Create temp table
simon -
17 Dec 2005 11:35 AM - 7 messages
IF I create temp table and insert something into it: create table #temp(col1 int,col2 int,col3 int,col4 decimal(15,5),col5 decimal(15,5),col6 decimal(15,5)) INSERT INTO #temp(col1,col2,col3,col4,col5,col6) ...
Problems Concatenating Columns
Simon Harris -
17 Dec 2005 11:28 AM - 2 messages
Hi All, I am getting some rather strange results when concatenating columns. Please see my inline comments below... SELECT '[link]' + CAST(products.idProduct AS Char(4)) AS product_url, ('Replacement ' + Case When CharIndex(';',Products.description) > 0 Then ...
My Cursor Operation - Efficient?
Simon Harris -
17 Dec 2005 9:51 AM - 2 messages
Hi All, I am trying to write a query that will conditionally carry out some string manipulation on as the records are retrieved. This much I am fine with, what I'm not sure about is the most efficient way to use a cursor. ...
How can I create a unique constraint on 2 columns where one of them allows nulls?
Keith G Hicks -
17 Dec 2005 3:07 AM - 12 messages
I have table as follows: CREATE TABLE [dbo].[Table1] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [ValType] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [MainVal] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [CodeVal] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Table1] WITH NOCHECK ADD ...
SELECT DISTINCT
TicToc -
17 Dec 2005 1:47 AM - 4 messages
What could cause a SELECT DISTINCT to still show multipule items of the same item in dropdown lists? I use alot of CASE and DATEADD functions but I do not see anything worng. SELECT DISTINCT CATEGORY, DATEADD(m, - 6, DISCONTINUEDDATE) AS SUNSET, ...
Date of records
eagle -
17 Dec 2005 1:17 AM - 7 messages
Is there a way to tell when a record has been added to a table? And by whom? I have data in a database that is obviously new, as the records do not exist in any of our backups, but the user has dated them with old dates. ...
Re: DTS problem: ActiveX Script Task Properties dialog box
nelsueno -
16 Dec 2005 11:56 PM - 2 messages
Did you find out the fix for that dialog box problem?
--
nelsueno
------------------------------------------------------------------------
Posted via [link]
------------------------------------------------------------------------ ...
Merging tables - basic question
Xitch13 -
16 Dec 2005 10:46 PM - 1 message
Thanks for the help! Sorry I haven't responded before now, but I wasn't
able to get onto the site for the past 2 days. Quick question - The update and insert states do not need to loop
through the tables? In other words, will I have to code a loop to read
each line in the table2 and nest your suggested code within it?
--
Xitch13
------------------------------------------------------------------------
Posted via [link]
------------------------------------------------------------------------ ...
Determining financial year quarter
Bob -
16 Dec 2005 9:25 PM - 12 messages
The quarter function returns 1 to 4 but is based by default on a year starting jan1 and ending dec 31 as far as I can tell. I need to find a way to determine in what quarter of a year a date is when a ...
Problem with AddNew on SQL server in c++ 2003
roberta.coffman -
16 Dec 2005 9:22 PM - 5 messages
Hello, I created a very simple database with only one table (Records) and on that table only one column (Category datatype nvarchar). I am trying to use the AddNew ado example found on msnd but it always inserts a null value instead of the value I am trying to insert. ...
Trouble with a computed colume
Jim Abel -
16 Dec 2005 8:56 PM - 3 messages
I have a table that I use a DTS to insert a date and cont value each day. I add a computed column called isweekday that gets a Y or N depending in the date. I now want to add another computed column for the mean of the counts ...
session timeouts?
rmanchu -
16 Dec 2005 8:45 PM - 3 messages
hi i'm new to sql server. i'm finding that when a connection sql server is idle for sometime, it gets disconnected ??? is there a session timeout for sql server connections? what's the default value for this? currently, i'm refreshing the connection every 100 seconds with a ...
clustered Vs NonClustered indexes
jaylou -
16 Dec 2005 8:38 PM - 5 messages
I was looking for some info on the major differences between a clustered and a non-clustered index, but I couldn't find anything in the MS knowledgebase. Which is more efficient? I am creating reports on an audit table that has ...
Performance Question
mvp -
16 Dec 2005 7:53 PM - 3 messages
Hello Everybody. Not sure how sql server query optimizer works ? if i have a query like following. select * from table where field1 = 'A' or field2 = 'B' or field2 = 'C' so how the above query will execute ? if field1 = 'A' is true, the other ...
case statements
HP -
16 Dec 2005 7:47 PM - 4 messages
Can you use case statements in a where clause? if so, how? Thanks! ...
Re: SQL2005 & SQL2000 in the same text box ????
genc_ymeri -
16 Dec 2005 7:38 PM - 2 messages
Can SQL 2005 ent & SQL 2000 ent co-exist in the same testing server box ??? Thanks ...
Comparing to Resultsets
RSH -
16 Dec 2005 7:08 PM - 2 messages
I have a situation where I have two tables, one in Access and one in SQL Server. There are several hundred thousand rows and the tables should contain the exact same number of rows. They may not though and the count ...
==again== constraints with nulls
sqlster -
16 Dec 2005 6:35 PM - 8 messages
I posted this question yesterday with out good table structure and sample data [link] ...
Ok, I give up...
kdd21 -
16 Dec 2005 6:29 PM - 5 messages
Been working in Visual Studio 2005 and got to the point where I needed to build a native program that interfaces with SQL Server via the bulk copy API. So, I d/l'ed SQL Server 2005, installed it ...
Re: how to find duplicate data involving more than one field
rlassiter -
16 Dec 2005 6:16 PM - 2 messages
This is great to show what is duplicated and by adding changing Select
to count(*) I was able to see how many times it was duplicated. Are you
able to take this 1 step further and actually return all duplicated and
complete records? EG. John,Smith is duplicated 3 times but the City is
different in each case. Can you return the 3 first,last,city records? ...
Need advice on database planning. Thank You.
Miguel Dias Moura -
16 Dec 2005 5:09 PM - 2 messages
Hello, I am working on a web site which will use SQL 2005. I am planing my first SQL database and I am looking for advice. 1. There will be two types of users: students and professors. 2. Both users types will have login information. ...
Counting the number of fields that are populated in row
dmagoo22 -
16 Dec 2005 5:01 PM - 7 messages
I have 2 large tables that I'm selecting off of. part of my select is to get the number of stores visited. The table that has this information has the store names as columns. If a store wasn't visited ...
Help! Uninstall
Sandy -
16 Dec 2005 4:59 PM - 3 messages
Hello - My OS is Windows 2000 Professional. I downloaded files for MSDE and installed them. I was not able to get Sql Server running. There was no uninstall exe and it did not show up in my Add/Remove programs. I then tried installing Sql Server 2005 Express. It ...
Reacting to DB events
Laurence Breeze -
16 Dec 2005 4:27 PM - 4 messages
I'd like to build an application that will react to specific changes to data in a set of tables in a database. The application would replicate these data changes to another database. The target database won't be ...
Will this two SQL statements get the same result?
Matthew -
16 Dec 2005 4:21 PM - 4 messages
delete from OrdersAudit where OrderNbr not in ( select OrderNbr from Orders) delete OrdersAudit from OrdersAudit,Orders where OrdersAudit.OrderNbr <> Orders.OrderNbr How much do you think the performance difference will be? There's clustered ...
Trying to insert a LOT of records
David Jessee -
16 Dec 2005 4:07 PM - 5 messages
I have a table that has 3 fields..there's a clustered index on all 3 fields..... The data in this table can change a lot depending on the changing state of the system. For performance purposes, I can't have a bunch of triggers ...
Update Stored Procedured question
dbuchanan -
16 Dec 2005 4:04 PM - 5 messages
Hello, Can I put two updates withing an update strored procedure? Is my syntax correct? Why I want to do this: My datatable is a union of two tables. It currently works well except for the fact that I have to update the records of corresponding tables ...
Works in SQL 2000 but Fails in SQL 2005??
LineVoltageHalogen -
16 Dec 2005 3:24 PM - 3 messages
I would greatly appreciate any help that you can provide. I have the following dml/query (part of a stored proc) that runs perfectly in SQL 2000. However, when I run it in SQL 2005 I get the following error: ...
SQL Server 2005 and GO issue
JosephPruiett -
16 Dec 2005 3:19 PM - 5 messages
Ok gentelemen we have come accross a little issue using the 2005 platform which is a very strange occurance. We can open a stored procedure that has been saved and at the top of the SP we have the following: ...
(Non) Updatable view problem
mfan -
16 Dec 2005 2:53 PM - 8 messages
Hi there! I created this view: select pk, name, ( select count(*) from dbo.Orders ord where ord.cust_fk = cust.pk ) as order_count from dbo.Customer cust ...
SELECT does not return all on left of join when right side has lim
richardb -
16 Dec 2005 2:48 PM - 6 messages
I have learned much about SELECT from helpful replies to my posts, but am stumped on this one. First here is the DDL: SELECT f.FinanceClass, COUNT(*) AS TotalCharges, SUM(dbo.udfAgeAmount (0, 29, DATEDIFF(day, service_date, GETDATE()), ...
Dynamic pivot of resultset
Soren S. Jorgensen -
16 Dec 2005 2:11 PM - 6 messages
Hi, I need to pivot and sum a resultset (based on a particular column) but I don't know how many cols the pivot would result in. Say you got resultset: [C0] [C1] [C2] 1 100 OO ...
Copy data for reports
jkane -
16 Dec 2005 1:45 PM - 2 messages
I need to copy a significant amount of data (1-2gb) during work hours to another database for some lengthy numeric calculations and a report. Phantom rows inserted during the copy operation would be a problem but a serializable transaction would impact availability. I was ...
Displaying HTML within an Access Report
Dooza -
16 Dec 2005 1:19 PM - 2 messages
Is this possible? I have a column which has data with HTML formatting. Is it possible to remove the tags within a Stored Procedure so that it displays nicely in an Access Report? This is my SP: ALTER PROCEDURE dbo.sp_Phat_Beats ...
Stored Procedure Cache Question
Anthony Sullivan -
16 Dec 2005 1:08 PM - 3 messages
Hey Folks, I'm having a problem that confuses me. We use MSMQ to scale our database calls. We have a .NET listener that grabs items out the queue and processes them calling a stored proc. This process has backed up significantly lately ...
Changing the collation
Enric -
16 Dec 2005 12:31 PM - 3 messages
Dear gurus, I am pursuing for a statement or function which allow me change the collation at database level. Thanks in advance and regards, Enric ...
time problem
Jose G. de Jesus Jr MCP, MCDBA -
16 Dec 2005 12:21 PM - 8 messages
hi all, i have a table with two fields name, date_hired a , 2004-04-16 10:02:31.000 B , 2004-04-18 20:02:31.000 i want a select statement that returns a , 2004-04-16 00:00:00 ...
Compare feilds in seperate databases on seperate servers
Darren Savery -
16 Dec 2005 11:08 AM - 7 messages
Hi, I want to run an update script where a field in a table in a database on a server is equal to another field in a table in a database on a seperate server. Here are the details: Server 1: ...
Error executing User Defined function on another server
Suhas Vengilat -
16 Dec 2005 10:36 AM - 5 messages
Hi All, Facing a problem while executing a user defined function (UDF) which resides on another sql server ( we have access on this sql server to execute the UDF). This UDF accepts a varchar parameter with max length 8. When we ...
Language Converter
Phil -
16 Dec 2005 10:28 AM - 1 message
Hi, I dont know if this is possbile and I have done some looking around but is it at all possible to download some sofware that will convert T-SQL code into Access SQL and /or vice versa , I have had a lot more exposure to T-SQL but I ...
find all sps where a field is used
Vikram -
16 Dec 2005 10:19 AM - 5 messages
In my database i want list of all stored procedures where i have used a specific field. Is there any way to do this.. any system sp which does this ...
Quicker Cursor or Table Variable
Ben -
16 Dec 2005 9:35 AM - 3 messages
Hi I have a large update batch to make on our database which will run overnight when no users are logged in. I always use a Table Variable instead of a Cursor to conserve resources, but in this case resources are not a problem but speed is. ...
best way to log out when running the job
Ed -
16 Dec 2005 8:55 AM - 6 messages
Hi, When I run the job, I am not sure whether it could be done at the table level to log users out. I would not want to keep them out of the whole database...only the tables I are updating. Also, once the job is running, I ...
creating a function to be used in select query
Newbie -
16 Dec 2005 8:42 AM - 3 messages
I have this select query which returns a date. I would like to be able to call this from a stored procedure and have the result appear in the result set from the stored procedure. i.e. SELECT *, CalcDate ...
Is it possible to get all the column values in a single column?
KssKumar2000 -
16 Dec 2005 7:25 AM - 6 messages
Hi Is it possible to get all the column values in a single column from a table? For e.g. a1 a2 a3 == == == ...
Usage of Join Question
SQL novice -
16 Dec 2005 6:53 AM - 5 messages
I am using a query by joiing 2 tables. I know that you can join 2 tables the traditional way also ie Select * from table1, table 2 where table1.Col1 = table2.Col2 is this query any way inferior to Select * from table1JOIN table 2 ON table1.Col1 = table2.Col2 ...
Select records based on the given value
KssKumar2000 -
16 Dec 2005 5:33 AM - 5 messages
Hi Situation: A table contain 10 columns, say a1, a2, ... I want to select records based on the given value, say 'test'. The issue is I don't know the value 'test' is in which column. It could be in the column a1 or a2 or so on. ...
Design Question
Matt -
16 Dec 2005 5:17 AM - 7 messages
not sure if this would be consider "on topic" or not, but i have a design question for all the brains out there. problem: many-to-many ( with priority ). "Person" can speak many "Languages" Languages can be spoken by any number of "Persons" ...
Does SQL uses index in the following select statement
Alex via SQLMonster.com -
16 Dec 2005 5:13 AM - 4 messages
I have the following table structure: PK_Column1 PK_Column2 IndexedColumn Column_ABC Column_XYZ Does SQL Server 2005 uses the IndexedColumn index to find the MIN and MAX values in the following select statement: SELECT MIN(IndexedColumn), MAX(IndexedColumn) FROM MyTable WHERE PK_Column1=@MyParam ...
Sending a report attachment to a dynamic list of recipients
KarenM -
16 Dec 2005 4:51 AM - 2 messages
I have a report output generated for each vendor and I want to email this attachment to the appropriate vendor. The problem is how can I send a email to each vendor with a attachment for the DTS email task or the XP_SMTP procedure. ...
Help with this trigger
dbuchanan -
16 Dec 2005 1:45 AM - 8 messages
Hello, I need some help with this trigger. I am a newbie at Triggers as you will see. I have had difficulty with some of the details of the concept. My questions are within the text of my attempt at the trigger. ...
OpenQuery using parameters
myob@beatles.com -
16 Dec 2005 1:18 AM - 2 messages
I need a little help with using parameter values in the where clause with the OpenQuery statement. What would the syntax for the following be if 10 was a variable? And does the syntax change depending on the datasource? In my case I am ...
Log shipping question
Bas Groeneveld -
16 Dec 2005 12:03 AM - 2 messages
Hi This is my first post in this newsgroup and I am not sure if I have chosen the correct group. Please advise if a more appropriate group exists. I am planning to set up replication to a standby sql server using RYO log ...
Discarding an empty result set in a stored proc
Chris Dunaway -
15 Dec 2005 10:43 PM - 3 messages
I have a stored proc with code similar to this: <SQL Query 1 Here> If @@RowCount < 1 Begin <SQL Query 2 Here> End Basically, I want to execute SQL Query 1 and if I don't get any rows, ...
unique constraints with nulls
sqlster -
15 Dec 2005 10:33 PM - 6 messages
Please consider the following table: create table mytable( pkid int, d1 int c1 int null, c2 int null, c3 int null ) I want to make sure that for a given value of d1: c1, c2, and c3 are unique. How do I create unique constraints for that. I went throught this forum and ...
selecting multiple topmost based in ID
jjburka -
15 Dec 2005 10:00 PM - 4 messages
Hello all, I am trying to write an procedure that will return the topmost row of each author id that is in the table. This is what I have so far : select * from PreviousBills where [BatchDate] >= @date or [Date] >= ...
How to Group by....
JDP@Work -
15 Dec 2005 9:50 PM - 5 messages
I'm trying to get a count of salesmanagers for a selected director from a listing of Sales. This is a one of many columns that I'm returning, but I need this ONE to be right. I want to get a count for a given dos as... ...
remove or ignore one row from DTS
Lynn -
15 Dec 2005 9:46 PM - 3 messages
Hi, a client privide me a cvs file with report tile (1th row) and column name (2nd row) and following by all the corresponding data. In DTS, you only has two choice 1) Skip ## rows 2) First row have columns ...
SIMPLE Left OUTER JOIN Question
pmud -
15 Dec 2005 9:26 PM - 3 messages
Hi, I have to select a fiels from one table which is not presnt in both the other 2 tables.. What will be the query for this..? I used the following but it showes results where the field was present in ...
How To Set a Variable During an Insert Into Select From
RitaG -
15 Dec 2005 9:22 PM - 5 messages
Hello. I'm inserting rows into a table that I retrieve from another table. There's a lot of data manipulation going on during this process. For 10 columns in the Select From portion I'm using a CASE statement that ...
Stupid stored proc question
Bob -
15 Dec 2005 9:13 PM - 4 messages
Whats the syntax for assigning the return value of a select statement in a stored proc to a variable in the stored proc? In the sample below I want to look up a value in an existing table and use ...
Selecting rows with highest count value
Mark Williams -
15 Dec 2005 9:06 PM - 6 messages
I have a table that stores IIS access logs. I run SELECT username, target, COUNT(*) as "hits" FROM weblog GROUP BY username, target to show how many times each user has hit each target. I would like to find out what each users' most popular target is. In other words, for each user, I ...
how to represent very long primary key
hroussel_at_delphes.com -
15 Dec 2005 8:10 PM - 6 messages
Hi! let's say that I have a table that represent files: CREATE TABLE DocumentFiles ( name ntext not null, size bigint not null constraint filesize_check check(size >= 0), lastmodif datetime not null default GetUTCDate() ) Now I cannot use the name of the file as a primary key. ...
Store SQL BlobColumn as Attachment to MailMessage?
Scott Townsend -
15 Dec 2005 7:58 PM - 1 message
I'm looking for a way to send an email attachment from the contents of a BlobColumn. We have table with a BlobColum that contains a PDF File. I'd like to be able to send an email with that PDF file as an attachment. Is there a way I can ...
Parent-Child Hierarchy Explosion
Amos -
15 Dec 2005 7:58 PM - 5 messages
All, I'm currently suffering trying to "explode" and parent-child hierarchy for optimisation purposes. The structure is thus: PK Parent VARCHAR(8) PK Child VARCHAR(8) ...
Very strange with Cursor behavior
Patrick -
15 Dec 2005 7:44 PM - 5 messages
Hi Freinds, SQL 2000 SP3 I am running the following : ----------------------------------------------------------------------- DECLARE curMove_no CURSOR FOR SELECT top 10 lm.move_no FROM lib_movement lm with (nolock) left outer JOIN lib_shelf ls with (nolock) ON lm.shelf = ls.shelf WHERE move_no in (select move_no from lib_movement_detail where master_no in ...
dire help needed
Woody -
15 Dec 2005 7:33 PM - 2 messages
Windows based server farm, SQL 2003, client side is W2k, vb6, Access 97...(i cant upgrade now,..legacy issues), all db access is done thru daoobject. Program walks thru the database object on the server farm table by table. It checks each table for new data, if present it then executes ...
Insert from Select to remove Duplicate rows
Larry Bird -
15 Dec 2005 6:35 PM - 3 messages
I'm want to remove duplicate rows from a table by reading from a temp table and inserting the records into another table. However, I continue to get the followingerror: Server: Msg 170, Level 15, State 1, Line 4 ...
Row Level Locking
V -
15 Dec 2005 6:22 PM - 3 messages
Hello, I have been trying to figure out how to user Row Level locking feature in SQL Server 2005. Here is the scenario. 1.Open a new query window in SQL Server Management sudio. 2.Execute a Begin transaction and an Update statement that updates a row in ...
SQL and Returning unique records
Linda -
15 Dec 2005 6:07 PM - 5 messages
I have the following table structure: email A B ...
I don't remember how did I such thing...
Enric -
15 Dec 2005 5:39 PM - 2 messages
Dear fellows, I was wondering how it was for rename a database? Thanks a lot for any input, Enric ...
Sum Total Hours and Minutes in a report
sack -
15 Dec 2005 5:39 PM - 17 messages
using: Access.adp; Report usage: Campus Lab usage: how long has a student been in the lab I can get: daily hours and minutes on the report with: =HoursAndMinutes([CheckOut]-[CheckIn]) ...
Deleting matching records
Mir Khan -
15 Dec 2005 5:20 PM - 2 messages
I need your help in MS Access… There are 2 tables Table A with 50 records and Table B with 5 records (similar records), I want to delete the 5 records of table B from Table A so ...
OLE Automation and "global variable"
Dave -
15 Dec 2005 5:16 PM - 2 messages
I have an OLE automation object that I am instantiating inside of a stored proc using sp_OACreate 'myObject', @object OUT. The stored proc is called multiple times, each time instantiating a new instance of the object (and then destroying it when it is finished). ...
Access or SQL Server
Macca -
15 Dec 2005 4:56 PM - 6 messages
Hi, I am writing a Visual Studio.NET client server app that will reside on one PC, the GUI, Business Logic and Database. I am trying to decide which database to use, either SQL Server/ Express or use Access with JET engine. ...
Importing a XML doc into relational tables.
crispin.proctor -
15 Dec 2005 4:51 PM - 4 messages
HELP! This is driving me mad.... Greetings all. I am trying to import XML into SQL. I have the following ingredients: 1 X xml document with 2 levels. Parent > child 1 X xml source object ...
Pass text variable to stored proc
fleo -
15 Dec 2005 4:40 PM - 4 messages
Hi, I use a stored proc to load XML data into tables. The stored proc takes as input the XML as a text parameter: spLoadXML (@XMLText text) I have a table "tblXMLContent" with a column of text type containing the XML ...
mapping data types
guy -
15 Dec 2005 4:26 PM - 3 messages
I am building a .NET app that uses sqlDataReader.GetSchemaTable method. this returns a table which includes the column "Provider Type" which is the database data type of the column, however it is a numeric value, are the mappings between these numeric values and the textual data type names ...
SQL 2005
Jose Pablo Solis Morera -
15 Dec 2005 4:11 PM - 1 message
I have a problem with Debug StoreProcedure with Visual Studio 2003 and Sql 2005, i can't debug, the problem is with a sp_sdiDebug, but i don't find the sp. ...
Comma operator in FROM clause - what is this?
Jeremy Cowles -
15 Dec 2005 3:58 PM - 4 messages
I know how it functions, but what does this mean exactly, and where can I find it in the books online? SELECT * FROM Table1, Table2 What is the name of that Comma's function? Thanks, Jeremy ...
Help with multiple Left Joins
lytung -
15 Dec 2005 3:47 PM - 6 messages
Hi All, this is my first time posting here as i cannot find the answer myself. I have couple tables i want to join and i can't seem to get it right. I have the following tables: Part: (Part ID), PartDescription ...
Error handling problem
Jakob Lithner -
15 Dec 2005 3:40 PM - 4 messages
I am running SQL 2000. I have several procedures where I do general validation on entered values. User procedures typically call these "checkprocedures" to verify all entered values. I thought I grasped the idea of error handling but must have done something ...
Union & group by Q
__Stephen -
15 Dec 2005 3:36 PM - 3 messages
I am normalizing a sales header file for a cross tab report. I want to make a column that will describe the total in the next column. Sales, Shipping, Tax In my select statement I define the text as a column like this: ...
sql server 8.0 specific
chump1708@yahoo.com -
15 Dec 2005 3:02 PM - 6 messages
There are 2 tables - say table 1 - child table - say child table 2 - parent table - say parent Assume that each child only resides on a single parent and each parent may contain multiple children..... Can we write a query for finding how many children are on each and ...
last re-cycle of SQL Server
Kenny -
15 Dec 2005 2:28 PM - 3 messages
Hi, Is there anyone know what is the the meaning of last re-cycle of SQL Server and when does it occur? Thanks, Kenny ...
Joining two tables multiple times
matthew.larkin -
15 Dec 2005 2:19 PM - 4 messages
Hi I have two tables (in an third party application, I cannot change the data structure) as follows:- T1 - Main data Amount Ref1 Ref2 Ref3 ============================== 100 A A A ...
please check
chump1708@yahoo.com -
15 Dec 2005 2:16 PM - 2 messages
There are 2 tables - say table 1 - child table - say child table 2 - parent table - say parent Assume that each child only resides on a single parent and each parent may contain multiple children..... Can we write a query for finding how many children are on each and ...
please check
chump1708@yahoo.com -
15 Dec 2005 2:16 PM - 9 messages
There are 2 tables - say table 1 - child table - say child table 2 - parent table - say parent Assume that each child only resides on a single parent and each parent may contain multiple children..... Can we write a query for finding how many children are on each and ...
|
|||||||||||||||||||||||