|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
Keeping DB schemas synched
querylous -
18 Feb 2006 10:41 PM - 8 messages
Hi - what's the best (preferably open source or inexpensive) tool for identifying differences (tables, columns, types, etc) between a development database and a production one, and applying dev changes to production automatically? Thanks, Chris ...
Using a CASE statement in a View
Debra Smith -
18 Feb 2006 10:25 PM - 7 messages
Using SQL Server 2000 to create the view. Microsoft SQL Enterprise Manager, Microsoft Corporation. Version: 8.0 I have a table that has the following types of columns all in a single row: Cr_Unit_01, Db_Unit_01, Cr_Unit_02, Db_Unit_02, Cr_Unit_03, Db_Unit_03, ...
Access ADP integration?
The Cornjerker -
18 Feb 2006 9:27 PM - 4 messages
I'm sorry but Management Studio is slow, cumbersome and difficult to quickly make changes while designing a new system. It is directly and very visibly impacting my teams production. The same can be said for developing databases though the Visual Studio IDE. ...
Query question
Dodo Lurker -
18 Feb 2006 9:26 PM - 6 messages
I have 2 tables. One table (sales) has a salesid and sales amount. The other table (salesrep) has a salesid and name. I want to write a query that will return the max sales amount and the name ...
Updating a column in SQL Server (text field validation)
David Patrick -
18 Feb 2006 8:49 PM - 4 messages
Hello All, I'm looking for a way to update a column in SQL Server and the only techniques available to me are VB Script of SQL Server tools. The problem is I need a way to remove some text within a column, e.g. ...
Do I need a cursor here
rocky20 -
18 Feb 2006 6:59 PM - 5 messages
I have a web page where users can change information about themselves and submitted to a database. The database holds these changes in the table UserChanges. When the user completes the changes the database for the website is updated and changes are reflected right away. The user ...
Databasepropertyex problem
Amish Shah -
18 Feb 2006 3:32 PM - 3 messages
Hi when I run this query SELECT * FROM OPENROWSET('MSDASQL', 'DRIVER={SQL Server};SERVER=test;UID=sa;PWD=amish;','select name, databasepropertyex(name,''status'') as status from master..sysdatabases') AS a Result is Name Status ...
Databasepropertyex problem
Amish Shah -
18 Feb 2006 3:32 PM - 1 message
Hi when I run this query SELECT * FROM OPENROWSET('MSDASQL', 'DRIVER={SQL Server};SERVER=test;UID=sa;PWD=amish;','select name, databasepropertyex(name,''status'') as status from master..sysdatabases') AS a It gives status in varbinary format. ...
Update is super slow 'coz of huge data and too many indexes
Rock -
18 Feb 2006 12:18 PM - 6 messages
I hv a table with 1. >30 lac records 2. >30 indexes need to update a few columns.. it works super slow. Pls suggest if there exists a way to make it work faster. If I drop the indexes, run the update statement, followed by creating the ...
Toughy Normalization Problem
Justin Weinberg -
18 Feb 2006 8:29 AM - 12 messages
Figure this out without using a cursor or loop that hits each record, and I'll gladly give you a free source license of GDI+ Architect (if you want one). See mrgsoft dot com for more info about that. I receive a data feed into my SQL Server with the bizarre property that the ...
Programming Source !
Mid -
18 Feb 2006 7:31 AM - 1 message
Hello, Good Source for Programming .... [link] ...
Query Design
Bill Bob -
18 Feb 2006 7:18 AM - 2 messages
I am going mad with this Query. I need to join 3 Tables. Their Formats are Vouchers [VoucherID] [uniqueidentifier] NOT NULL , [VoucherTypeID] [int] NOT NULL , [VoucherNo] [int] NULL , ...
SQL Query
cash pat -
18 Feb 2006 7:13 AM - 6 messages
I am going mad with this Query. I need to join 3 Tables. Their Formats are Vouchers [VoucherID] [uniqueidentifier] NOT NULL , [VoucherTypeID] [int] NOT NULL , [VoucherNo] [int] NULL , ...
Consuming raw data from UDTs in ADO.NET
Leila -
18 Feb 2006 7:12 AM - 1 message
Hi, I have used the implementation of Point UDT exactly from MSDN: ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/denet9/html/1e5b43b3-4971-45ee-a591-3f535e2ac722.htm I have attached Type1.vb to this post. I have problem with binding UDTs as ...
Timeout expired - on a simple SqlDataReader:Read() call
CuriousGeorge -
18 Feb 2006 1:15 AM - 10 messages
I have a very simple .Net 1.1 app that I'm writing to upgrade our applications database for a new version. This app has a pretty tight loop where I'm using a SqlDataReader to walk through all records in a fairly ...
Primary Key Question
Jeff S -
18 Feb 2006 12:57 AM - 16 messages
I'm planning to keep track of many [types of people], including patients, doctors, and referrals. Additional types will likely be added in the future (possibly "employees" or "staff") I plan to have a People table in which common attributes are stored, and ...
Error in SQL 2005 Maintenance Plan
The Cornjerker -
17 Feb 2006 11:25 PM - 5 messages
I'm trying to setup a nightly backup to a remote computer using an SQL Server 2005 Maintenance Plan. It keeps giving an error. I've narrowed the cause down to an execute command... EXECUTE master.dbo.xp_create_subdir ...
Is it possible to join two tables in a View/Query where the Second Table is based on a Name in the F
james -
17 Feb 2006 11:08 PM - 7 messages
How can I do this?? <TableA.tableName> is my psuedo for the TABLE I want to JOIN to but I can't figure out how SELECT TableA.tableName, <TableA.tableName>.someData ...
Having a hard time with a Query for total + most recent Pass/Fail
Lucas Graf -
17 Feb 2006 10:14 PM - 5 messages
Here is a watered down DDL of my tables. CREATE TABLE Apps ( AppID smallint, AppName varchar(32), PRIMARY KEY (AppID) ) CREATE TABLE TestCases ( TestCaseID smallint, AppID smallint, TestCase varchar(32), PRIMARY KEY (TestCaseID) ) CREATE TABLE Reports ( ReportID smallint, TestCaseID smallint, ...
Code and diff sql servers
mikeb -
17 Feb 2006 9:55 PM - 7 messages
I'm running out of ideas... Given the following example of code: set @partialname = 'u' SELECT col1, col2, col3 FROM tbl1 WHERE col1 LIKE @partialName + '%' ORDER BY col1 Why would two different sql servers, having exactly the same data, give ...
Databasepropertyex problem
Amish Shah -
17 Feb 2006 9:02 PM - 2 messages
Hi when I run this query SELECT * FROM OPENROWSET('MSDASQL', 'DRIVER={SQL Server};SERVER=test;UID=sa;PWD=amish;','select name, databasepropertyex(name,''status'') as status from master..sysdatabases') AS a Result is Name Status ...
Update record need self join problem
Rich -
17 Feb 2006 8:45 PM - 8 messages
Hello, My detail table has a subID column and a CompanyName column. For each subID there needs to be a corresponding CompanyName. subID CompanName a-01 JoneCo a-01 JoneCo a-01 Null ...
ADO.NET 1.x, How to mimick Query Analyzer Batch Execute??
Crash -
17 Feb 2006 8:26 PM - 2 messages
Hi, ..NET v1.x SP1 VS 2003 SQL Server 2000 SP3 Server 2000, XP, Server 2003 I would like to programmatically execute {possibly many} SQL Server batch scripts. Aka I have many scripts that drop/add stored procedure definitions, alter table definitions & constraints, etc... and I would ...
Export many users to new database
AkAlan -
17 Feb 2006 8:13 PM - 4 messages
Is there a system stored procedure or other method for mass exporting all users from one database to another on the same server? ...
Automaticaly popluating Current Date in a Db Field
pmud -
17 Feb 2006 7:56 PM - 9 messages
Hi, I have a field in he db called LogDate. I have made it a timestamp type. Is there a formula or a default value i can set for this field in the table design view so that everytime a record is added, this field is automaticallly ...
Can't figure out how to write query
ninel g via SQLMonster.com -
17 Feb 2006 7:48 PM - 3 messages
I have a table TABLE1. My company has 2 sites. This table contains employees with the amount of hours they worked on which project at which sites. [CODE] CREATE TABLE #TABLE1 ( Calldate varchar(10) NULL, Employee varchar(10) NULL, ...
find out which tables used a specific field
js -
17 Feb 2006 7:36 PM - 3 messages
hi, how to find out which tables used a specific field in one database? Thanks. ...
Data Access components with MSSQL 2000
MedioYMedio -
17 Feb 2006 7:30 PM - 2 messages
Can I use an application developed with DAO, ADO or RDO with MSSQL 2000? (I'm migrating the server) Are there compatibility issues? Greetings, ...
SP_DATABASES on SQL Server 2005 problem
Brian Henry -
17 Feb 2006 7:19 PM - 4 messages
In sql server 2000 we used sp_databases for users to return a list of databases (the users were not admins and had no special permissions besides had rights to a database or two) but in 2005 the non admins when they ...
nText in Triggers
Steph -
17 Feb 2006 7:06 PM - 4 messages
I want to do something like this Select @MyText = LongDescription From MyTable Where id = inserted.[ID] I get an error message telling me that nText is invalid for a local variable how can I do this? ...
Table-Value Functions in SQL 2005
Paul Rausch -
17 Feb 2006 6:01 PM - 2 messages
I have a multi-statement table function that works great in SQL 2000, but in SQL 2005 it will work great for awhile then after you call that function a bunch of times it goes from taking 2 seconds to run to 60 seconds to run ...
MSSQL Mistake
juokaz -
17 Feb 2006 5:53 PM - 1 message
Bad thing - it's excercie, i have only this piece of code, and in
excercise it is said that to complete you mustnt have mssql
knowledge... ML wrote: ...
problem restoring backup of DB
Rich -
17 Feb 2006 5:12 PM - 10 messages
Hello, I copied a backup file of a production DB on a production server to another location on a Development server. When I try to restore this backup on the Dev server - from Enterprise Manager, I am getting an error message that ...
Determine security access to stored procedure through ASP
webJose -
17 Feb 2006 4:33 PM - 6 messages
I have an ASP application running in a MS Windows Server 2003 computer joined to a Windows 2000 Active Directory domain. Different users have different roles, and the security in the SQL database is based on Active Directory security groups (SQL server is ...
MSDataShape no longer works in SQL Server 2005, please help!
Andreas1974 -
17 Feb 2006 4:30 PM - 1 message
Hi! Something is wrong with SHAPED recordsets retrieved from SQL Server 2005. I have a disconnected hierarchical recordset. I can assign values to the MAIN or TOP level of the recordset, but I am not allowed to add or changes field values of the subrecordsets. ...
Called Web Services from a stored prcedure
Martin Waller -
17 Feb 2006 4:17 PM - 4 messages
Hello, Does anyone know if it is possible to call a web service from a stored procedure? Failing that is it possible to use exterbal object? I'm thinking along the lines of: @obj = CreateObject("xyzzy.f") ...
separate columns
perspolis -
17 Feb 2006 4:09 PM - 10 messages
Hi all I have a tables like this.. fCode Number 1 10 2 -3 ...
Scheduled Backup for SQL Server Express
BCS -
17 Feb 2006 3:50 PM - 5 messages
Not sure if this is the right forum, so please correct me if I'm in error. I've written a Timeclock application in VB6 for our small chain of retail stores and storing the data in a SQL Server Express database. All is ...
Failure running aspnet_regsql on SQL Server 2000
AAOMTim -
17 Feb 2006 3:31 PM - 1 message
When running aspnet_regsql I getthe following error: Setup failed. Exception: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 515 and the SqlException message is: Cannot insert the value NULL into column 'Column', table ...
Extract Phone Number String - Please Help!
Tom -
17 Feb 2006 3:26 PM - 4 messages
Hello Experts: I am a newbie to T-SQL, and I wonder if this is possible. I have the following possible phone number strings coming in: 1. 8882223333 2. 18882223333 3. +8882223333 4. 888 222 3333 What the expected end result is case #1: 8882223333. Is it efficient for ...
Help with Stored Prcoedure
star -
17 Feb 2006 3:03 PM - 4 messages
Hello I have written this stored procedure but I am getting following error. Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '1'. Server: Msg 50000, Level 16, State 1, Procedure CopyDataArchive, Line 24 Error occured while copying data to December ...
general questions
KBuser -
17 Feb 2006 2:52 PM - 4 messages
I guess I'll just post as much about my situation which I feel is pertinent, and hope I get the feedback I'm looking for. I'm not exactly sure what it is I am trying to figure out here, but I think I'll get ...
Help with Stored Prcoedure
star -
17 Feb 2006 2:46 PM - 5 messages
Hello I have written this stored procedure but I am getting following error. Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near '1'. Server: Msg 50000, Level 16, State 1, Procedure CopyDataArchive, Line 24 Error occured while copying data to December ...
Join Query Problem
angjbs -
17 Feb 2006 2:29 PM - 1 message
I have this: T-1 T-2 T-3 pkID pkID pkID ...
Novice needs help with search
dtw -
17 Feb 2006 2:16 PM - 4 messages
I am a novice who hasn't mastered the SQL language yet. Your help will be appreciated. I need a query to search a table for records matching one or more of four conditions and then return them with the most matches first. ...
tool for creating documentation for stored procs
Dirk Theune -
17 Feb 2006 2:15 PM - 2 messages
Hi, I am looking for a tool to automatically create documentation for stored procedures. I am thinking of something similar to ndoc in .NET, which creates doc from the comments in the stored procedure. Does anybody know of such a tool? ...
OBJECTPROPERTY problem
drink.the.koolaid@gmail.com -
17 Feb 2006 2:06 PM - 19 messages
Why does the first query work properly and return 1 for the IsMsShipped column when the second and third query do not? use Northwind go SELECT convert(varchar,name) as ObjectName, id, OBJECTPROPERTY(id, N'IsMSShipped') as IsMSShipped FROM sysobjects ...
delete contraint
Robert Bravery -
17 Feb 2006 2:03 PM - 2 messages
HI all, Hope I have the correct terminology. I have related tables, with cascading deletes off. In otherwords, you cannot delete a parent row if there are related child row. Now when this happens a correct error is produced. Is there any way to have a single return statement stipulation which child ...
How to order???
Daviso -
17 Feb 2006 1:44 PM - 7 messages
Hi. I have a table with 2 fields (personalName, companyName). I can insert person Names or company Names and one field tells me about what kind of field is. I want to retrieve the data, but ordered by person and company. ...
optimize queries with unexpected results
Tristan -
17 Feb 2006 12:54 PM - 6 messages
Hi, This is one for the MVP’s. I am trying to optimize queries but I am finding un-expected results. I am using sql 2000. For example, I have read in several sites that referencing objects with qualified owner names is faster. The truth is that I am experiencing all the ...
XACT_ABORT AND char insert in INT datatype
verbani -
17 Feb 2006 12:45 PM - 5 messages
Hi, I have a series of insert statements and if it fails he has to rollback the transaction, do logging and set the current row in status 99. So after each insert statement I check @@ERROR to see if it failed. If the ...
Stored Procedure Perfornance
John McDonald -
17 Feb 2006 12:45 PM - 4 messages
In a recent discussion a statement was made that stored procedures perform better than dynamic SQL statements execution. This assertion was challenged and it there has been a remark that in SQL Server 2000 that stored procs are not faster although it is not sure if ths holds for SQL Server 2005. ...
Custom labels for DTS steps
Joe Gass -
17 Feb 2006 12:43 PM - 4 messages
Hi, we have DTS packages which call other DTS packages, sometimes a few levels deep. In our error logs out DTS steps are labelled like "DTSStep_DTSExecutePackageTask_4" Is there a way to give our DTS steps custom labels so that it'll be easier ...
T-SQL: How to loop through the resultset from another procedure?
Ronald Kloverod -
17 Feb 2006 10:25 AM - 11 messages
This is a SqlServer 2000 question. In my Transact SQL-code (actually a procedure called proc2) I'm calling a procedure called proc1. proc1 is returning a resultset, typically 1-3 rows. There is only one column in the resultset. In my T-SQL code in proc2 I want to loop through the ...
link server with case expression
soonyu -
17 Feb 2006 10:16 AM - 3 messages
anybody know how many case expression can be in linked server query? when i have more then 10 "case" expression witjh linked server, sql query give this message : Server: Msg 8180, Level 16, State 1, Line 1 Statement(s) could not be prepared. ...
best bulk insert command
Sammy -
17 Feb 2006 10:01 AM - 2 messages
I have a 5 million row table that gets truncated and new values get imported. The new values are obtained by values that have changed in other tables. Does anyone know the quickest way this can be acheived. I have tried this took around 34mins ...
MSSQL Mistake
juokaz -
17 Feb 2006 9:41 AM - 3 messages
I have only this piece of code and its said that there is mistake, it's
excercise, so i dont have full code. SQL wrote: ...
Qty - decimal, money, or ...
Rock -
17 Feb 2006 9:30 AM - 4 messages
which data type will be the best for the qty column? - R ...
DROP DATABASE Question
chris -
17 Feb 2006 9:25 AM - 5 messages
Hello, in our project i have to drop an existing sql server database and immediately create a new (and empty) one with exactly the same name. MSDN says that in case of dropping a database also the physical files on the ...
Most basic transaction?
Lasse Edsvik -
17 Feb 2006 9:14 AM - 4 messages
Hello I was wondering if you could show me the most basic transaction in code? And rollback if error :) ...
"Where date" problem
גלעד -
17 Feb 2006 9:04 AM - 8 messages
Hi all, I bumped into this issue: If I run the following statement : "select sum(total) from sales where date>=dateadd(m,-14,getdate())" I get the result in 2-3 seconds, but if I run the following: "select sum(total) from sales where date>='2005-01-01 00:00'" ...
Backup error
Lasse Edsvik -
17 Feb 2006 8:02 AM - 4 messages
Hello I was told by email someone got an backup error and I gotta reply something to him, what reasons can there be for this error? All services are running and disk isnt full SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan ...
Regarding OPENXML to get the values
Herbert -
17 Feb 2006 7:55 AM - 3 messages
Hi All, Am using the following XML String. I want to get all the values from the XML. but i dont know how to get it. Can any one please help me ASAP. Eg: '<?xml version="1.0" ?> ...
Regular Expression Support
Jeff S -
17 Feb 2006 7:21 AM - 2 messages
Is there any Reg Ex support in any recent version of SQL Server; like for use with check constraints? -Thanks ...
Database Properties
Prasad -
17 Feb 2006 6:47 AM - 3 messages
Hi, From where can I get SpaceAvailableInMB and KB for a database for SQL 2000 and SQL 2005. sp_spaceused gives the Size of the Database, Data Space Used, Index Space Used. SQL-DMO gives it. ...
VS2005, SQL2005 integration: Synchronize Stored Procs, UDFs?
suranga.suranga -
17 Feb 2006 6:34 AM - 1 message
I maintain SQL scripts for Stored Procs and UDFs in a VS2005 "Database Projects" ("Other Project Types"). The Database project was added to VSS for source control. 1) When Stored Procs, UDFs are edited outside this project (ie. From SQL Management Studio), is there a way to synchronize updates into the ...
Problem when conncet to SQL Server 2005 (SQL Native Client + Named instance)
ski blue -
17 Feb 2006 5:54 AM - 1 message
Hi, I have an application which previous connect to SQL Server 2000. Now, I installed SQL Server 2005, and try to conncet to it. The previous connection string is: sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword); ...
Problem when conncet to SQL Server 2005 (SQL Native Client + Named instance)
ski blue -
17 Feb 2006 5:54 AM - 1 message
Hi, I have an application which previous connect to SQL Server 2000. Now, I installed SQL Server 2005, and try to conncet to it. The previous connection string is: sString.Format("DSN=%s;uid=%s;pwd=%s", sDb, sUser, sPassword); ...
1, 2, or 3 Tables (Data Modeling Question)
Jeff S -
17 Feb 2006 5:50 AM - 6 messages
I'm modeling some entity that could reasonably be considered to be [one entity] or [two entities] --- people which are customers and employees. AFAIK, these are my three basic options: OPTION 1: Have one table, People, with some "flag column" that tells us which kind of ...
Re: Who has the highest bid?
Mayte -
17 Feb 2006 5:50 AM - 6 messages
This is exactly the kind of comment I've been getting from everyone here. No one can help the simple guy get a simple answer ...
case
ichor -
17 Feb 2006 5:27 AM - 2 messages
can i use case in an update statement? UPDATE pn SET pn.payg_tax = pn.witholdingtax, pn.witholdingtax = 0 FROM @PaymentNotification pn where witholdingtax > 0 and ato_payment_id is null UPDATE pn SET pn.witholdingtax = pn.payg_tax, pn.payg_tax = 0 FROM @PaymentNotification pn ...
SQL & ASP
DNKMCA -
17 Feb 2006 4:20 AM - 2 messages
Hi, Im using ASP and SQL Server. The processed values from ASP are stored in the SQL Server When there is concurrent users say about more than 10 then only 3/5 users only getting updated to SQL Server immediately and remaining users takes approx 30 min to update ...
Calculate integral of time series
Ami Einav -
17 Feb 2006 3:48 AM - 3 messages
Hello, I want to compute an integral of values in a table that has 2 columns: Column A: Time-stamp (T) Column B: value (KWH) I need to compute the sum of (KWH*(T(n)-T(n-1))) Could you suggest a way to do it in T-SQL? ...
Pull if matches 2nd to end of text field
Dan -
17 Feb 2006 2:35 AM - 4 messages
I have 2 tables in a database. Table 1 has a field (1a) that contains a customer part number. It also has a field (1b) that contains just a manufacturer part number. Table 2 contains 2 fields. Field (2a) has the description that might have a ...
project server
Frank Dulk -
17 Feb 2006 12:56 AM - 2 messages
I installed SP4 of SQL SERVER 2000 and even so I don't get to install project server. Somebody knows how I can solve that.. the error message says that I have to install the sp3 or superior of the sql server 2000. ...
Comparing two databases
AkAlan -
17 Feb 2006 12:56 AM - 4 messages
Is there a way to compare the strored procedure,views and UDF's between two databases to see if there are any differences. I use one database for developement and the other is online. I would like to be able to run a ...
search a value string in entire database
culam -
17 Feb 2006 12:33 AM - 3 messages
Is there a way to search entire database for a value "HTML" that stored on any given columns? Thanks, Culam ...
Function to find character in string
Kayda -
17 Feb 2006 12:13 AM - 3 messages
Hi: I was looking through BOL for a function that would return the numerical place where a string first occurs (similar to Crystal Report's 'instr' function): so FUNKYFUNCTION('abcdefgd','d',1) would return 4, the first occurrence of the 2nd argument: 'd'. The 3rd ...
Comparing 2 dbs for differences in column definitions
MittyKom -
16 Feb 2006 11:23 PM - 3 messages
Hi All I have 2 dbs, one for prodcution and the other one for development environment. They are meant to be the same. Is there a script/way to compare the dbs for any difference in column datatypes, length. ...
Storing an HTML page
tshad -
16 Feb 2006 11:03 PM - 3 messages
I am trying to store an html page in a table that I want to email from my Stored procedure, but have run into a couple of problems. I originally stored it as a Text field (to take care of the 8000 varchar ...
Creating Indexes on Views
pmud -
16 Feb 2006 10:34 PM - 5 messages
Hi, I have a view which uses 2 other views.I need to create an index on this view. But one of the two other views has Union statements. Is there any way that an index can be created on this final view ( which is made of the other ...
Count Occurances in a column
laurenq uantrell -
16 Feb 2006 10:11 PM - 12 messages
Is there a way to count the number of times a character or string appears in a column in a table row/column? Example, tblTable has column StringData varchar(1000) StringData contains the value "Mary Had A Little Lamb Lamb and Then It ...
Who has the highest bid?
Mayte -
16 Feb 2006 9:58 PM - 58 messages
Hi I have a table with items and bidders Bob Mike Sally Lamp 10 30 40 ...
Select Incremental..
jrmann1999 -
16 Feb 2006 9:46 PM - 3 messages
I have a Join that's creating identical rows except for an incremental column. I want to only return the row with the highest incremental number, how can I accomplish this? DB structure is like EP_KEY(INT), PAT_KEY(INT), PAT_NAME(VARCHAR), EPISODE(INT) ...
SQL 2005 T-SQL Reference
The Cornjerker -
16 Feb 2006 9:39 PM - 5 messages
I have a book that came with SQL Server 7.0 called the "Microsoft SQL Server Transact-SQL and Utilities Reference, Volume 1." It basically lists the T-SQL statements with common examples for each. Nothing else, no programming techniques, no tutorial, etc. I use it ...
Execute Package Task Not Working
Andre -
16 Feb 2006 9:25 PM - 2 messages
I am trying to run two execute package tasks. I want the second task NOT to execute if the first one fails, but I cant seem to get this working. I have put the workflow in place and check fail package on first error in every ...
Need Help Please...
JonB -
16 Feb 2006 9:23 PM - 10 messages
ok i want to say first off i'm really bad at explaining problems so people can understand them but i will try my hardest. i need to write a query for our apparel department that shows total revenue per retailer. this report ...
Updating Table with data from another table
StaarTech -
16 Feb 2006 9:15 PM - 7 messages
Hi All: I am a newbie at SQL, and I have a two-part question, that I am hoping you can help me with. Please bear with me. Original Issue: We have a non-MS-SQL database that exports data into many text files on a ...
Help with a loop sending e-mail in SQL
Matthew -
16 Feb 2006 8:25 PM - 1 message
I have a script that collects drive information. Now what I need it to do is to send one e-mail message to per critical error reported. So I need the query to loop through the temp table and for each instance ...
Timeout expired
SQLCodder -
16 Feb 2006 8:20 PM - 7 messages
I'm having trouble finding the cause of the following error message: [Error#: -2147217871 Description: Timeout expired (Source: Microsoft OLE DB Provider for SQL Server)] The error is occuring when trying to execute a simple update query: UPDATE merchant_billing SET billing_last_billing_date = '2/15/2006' WHERE ...
ANN: ObjectMagix Persistency Framework
Roman Bobik -
16 Feb 2006 8:20 PM - 1 message
ObjectMagix Framework Beta has been released. ObjectMagix provides persistency services (including an O/R mapper) for your business objects. It's based on .NET 2.0 and targets .NET 2.0 applications. Check out the official website at [link] ...
GetDate not working if passed
tshad -
16 Feb 2006 8:01 PM - 10 messages
I am calling a SP that is expecting a datetime. If I pass '02/15/06/, it works fine. If I do it like: ****************************************************** Declare @DateToSend VarChar(20) Select @DateToSend = GetDate() Exec COM_INSERT_MESSAGE_TO_QUEUE_SP 1,@DateToSend ********************************************************** This works. ...
Syntax to read/pull data in one server from another server?
Rich -
16 Feb 2006 7:58 PM - 2 messages
Hello, I have a production server and a development server (which I just installed last night), called serv1 and serv1\dev, respectively. I am trying to read data from a table in a DB on serv1 but from serv1\dev. I have linked serv1 ...
Using aliases in SELECT DISTINCT clause and ORDER BY
Juan DarÃo Tempesta -
16 Feb 2006 7:41 PM - 5 messages
Hello, I'm having a problem when using aliases for columns in the select list and using the DISTINCT keyword. This is a simplified version of the real problem. CREATE TABLE #Authors ( [AuthorId] INT, [Name] VARCHAR(50) ...
Incrementing field value by one
Kayda -
16 Feb 2006 7:18 PM - 5 messages
Hi: I have a field in a table that is NULL for all records. I want to set it to increment by 1 so if I have 30 records, the values in this field will be 1 for the first record, 2 for the next record etc. ...
Extra xml node
Hyper -
16 Feb 2006 7:11 PM - 2 messages
This is in sql 2005 I have a query that is returning a set of rows each with one xml field row1 -<apple></apple> row3 -<orange></orange> row2-<grape></grape> ...
Attach and ODBC Database in Enterprise Manger (I think)
Michael Kintner -
16 Feb 2006 7:04 PM - 4 messages
I have created an SQL database and would like to attach an ODBC database so I can query its data along with data from the SQL database. How can I attached this table in the Enterprise manager? Or maybe my thinking is ...
Help with flags in Query
Matthew -
16 Feb 2006 6:51 PM - 1 message
Here is a fun one. This code does work but I am looking to improve it. One of the ways to improve it is to send different e-mail messages with different subject lines and/or header. The big trick for me will be ...
SELECT query help
DC Gringo -
16 Feb 2006 5:27 PM - 10 messages
I have a SELECT query SELECT date_registered, COUNT(*) AS registrations FROM individuals GROUP BY date_registered ORDER BY date_registered ASC The resultset shows something like this: date_registered, registrations ...
|
|||||||||||||||||||||||