Database Newsgroups: SQL Server database programming

query again, again, i am sorry..

tom taol - 12 Aug 2006 9:24 PM - 4 messages

table1 ============= xx 1 ...

Can this be done? How? Or do I need an external app?

Paul Pedersen - 12 Aug 2006 8:50 PM - 3 messages

I need to have SQL Server monitor a table, and 15 minutes after the last update was made, to extract certain data to XML or other text format, then send the extract somewhere either via FTP or email. Can this be done within SQL Server? Or will I need to write an application ...

Join between SQL Query and Active Directory

Bob - 12 Aug 2006 8:47 PM - 1 message

Is it possible to specify a JOIN or WHERE clause that joins a SQL Server Query Table containing some form of Role / Group name with the current usersActive Directory / NTLM information? I need to be able to associate a potentially unique role membership with ...

How to pass a list of integers to a stored procedure ?

fniles - 12 Aug 2006 7:48 PM - 3 messages

colA is a an INT column I need to create a stored procedure that has a parameter of list of values for colA. For example, 1,2,3 When I do the following, I got an error "Syntax error converting the varchar ...

OUTER JOIN with WHERE clause fails

mavrick_101 - 12 Aug 2006 7:04 PM - 3 messages

Hi, I am frustrated with this problem. I am trying to get results from two tables and using left outer join. The results are ok util I add the WHERE clause. As soon as I add the where clause ...

deleted table, but somehow it's still there?

vtxr1300 - 12 Aug 2006 6:15 PM - 3 messages

I had a table called ClientJob. I wanted to change the name to Job. I right clicked it and selected rename and renamed it to Job. I then tried to create a diagram using that table and a few others, but when I ...

How to link foreign key of one table to Primary key of two table

prashantdoshi - 12 Aug 2006 6:01 PM - 3 messages

How to link foreign key of one table to Primary key of two table Hello Friends, Here is what I am trying to do. I have table Expense which has column shop_id, I've another two tables name L_Shopping and O_Shopping and they have ...

Global Constants

windy - 12 Aug 2006 5:36 PM - 4 messages

Hi all, I would like to know the ways to make a global constant variable (number, or nvarchar) which all my SP can use it directly. Thanks a lot. Windy ...

Debug Function in 05

Ed - 12 Aug 2006 4:43 PM - 2 messages

Do we still have the "Debug" function for stored procedure in 05? ...

dynamic or static SQL ??

ibiza - 12 Aug 2006 2:54 PM - 4 messages

Hi all, I have an application where a simple search box is used to do a powerful search on whatever the user types in. The program recognizes if it's english, a certain search type (e.g. "sc:7" is for "stroke ...

SQLExpress multiple file import Bulk insert

Dale - 12 Aug 2006 2:33 PM - 2 messages

Hello I've tried to modify some code found on the web to import multiple files into a table, where I need to include a format file in the bulk insert syntax...I've tried everything but I can't get the syntax right for the file ...

limit the number of decimals on a float field

Henry - 12 Aug 2006 12:57 PM - 5 messages

Hi Does anyone know how to limit the numbers of decimals after the point in a query? cheers Henry ...

query again

tom taol - 12 Aug 2006 12:48 PM - 2 messages

table1 have fields of 2 fld1 fld2 aa 7 bb 8 table2 have fields of 2 fld1 fldx aa 1 ...

Migration

Ed - 12 Aug 2006 12:22 PM - 3 messages

Can someone please tell me how to migrate system DBs from 00 to 05? I unstand I can use detach / attach or backup / restore for all user databases. I am now sure to to do the Master and MSDB (Including all the Jobs and DTS ...

rowguid : Merge Replication

Russell Mangel - 12 Aug 2006 7:54 AM - 5 messages

Question: How do I get the rowguid value after an insert operation? I would like to return this guid to the client. I simply have a stored procedure that inserts a row into a table, just after the insert statement, ...

SQL Server Help Needed

gold.study@gmail.com - 12 Aug 2006 7:05 AM - 4 messages

Hi everybody. I have 2 tables named daily, executive Structure of Executive : exe_code - nvarchar(20) exe_name - nvarchar(100) Structures of Daily: fileno - int identity(1,1) name - nvarchar(20) resiexecode - nvarchar(20) offexecode - nvarchar(20) Records in Executive : exe01 - Ram ...

**sum of field**

M - 12 Aug 2006 6:05 AM - 3 messages

hi I want to add the value of f3 field step by step in each row like below: f2 f3 --- ----- b 4 c 5 d 3 ...

test3

M - 12 Aug 2006 5:55 AM - 1 message

...

Stored Procedure Help

Mike Voissem - 12 Aug 2006 5:01 AM - 16 messages

I'm trying to attempt to tie promotion information to orders based on dates. So, if someone received an e-mail promotion of 1/1/2006, 2/1/2006, and 3/1/2006 and ordered something on 2/5/2006, I want to apply the e-mail ...

Deadlock at trigger

alex121 - 12 Aug 2006 4:28 AM - 2 messages

Deadlock at trigger a trigger need to insert or update record at the other table in high traffic environments however, the deadlock happens; ie, a trigger running twice at the same time want to need to insert record at the table. ...

How to analyze SQLProfiler trace result ?

krislioe - 12 Aug 2006 3:37 AM - 3 messages

Hi All, I plan to run SQL Profiler because my SQL Server 2000 get the users timed out after running some time, and happen every day. (see [link]) ...

insert identity and master/detail within t-sql transaction

miapjp - 12 Aug 2006 12:55 AM - 3 messages

I've looked and looked and can't find the answer (except for ADO). This has to have been asked before but I can't find the answer. I need to insert a row, grab the PK (identity column) and then use that ...

query

tom taol - 12 Aug 2006 12:10 AM - 2 messages

table1 have fields of 1 fld1 aa bb table2 have fields of 2 fld1 fldx aa 1 aa 3 aa 8 bb 1 ...

identity not for replication

Liannekwock - 11 Aug 2006 11:29 PM - 2 messages

Hello, Does any one know how to alter the column propterty from identity (yes) to identity(not for replication) via TSQL. Many thanks, Lianne ...

Hide Result Panel in 05

Ed - 11 Aug 2006 11:22 PM - 2 messages

Hi, This could be a very stupid question. How can I hide/close the result panel in SQL 05 after running the query. e.g. Select * from ErrorLog I see the result in Result Panel but I could not find any Tool/Button to ...

date comparison

Samuel Shulman - 11 Aug 2006 10:15 PM - 7 messages

Hi In order to retrieve records with a specified date but without a specified time I find that the '=' character will return only records with the same time as well, so if I compare '2006-08-09' to '2006-08-09 10:12:55' that ...

Accounting work days

zzx375 - 11 Aug 2006 10:10 PM - 5 messages

If anyone is familiar with the accounting concept of work days, that is what I am trying to accomplish. As an example of what I am mean, 9/1/06 is work day 1, 9/2, and 9/3 would both be work day 1 (weekend), 9/4 would still be work day 1 ...

Saving a word document to a table and retreiving it

Merdaad - 11 Aug 2006 10:05 PM - 3 messages

Hi, I am using SQL 2000. I have a web application (asp file using VB Script) I am trying to find a way to save a word document in a sql table and then later retrieve the document and display it in a web browser. ...

subquery or cursor needed here?

Steve Hershoff - 11 Aug 2006 10:02 PM - 3 messages

Hi everybody, I have a table with three columns-- empno (int, primary key), transtype (int) and transdate (datetime). I'd like a listing of all empnos that have identical transtype/transdate pairs, along with the count of how many times ...

how to specify criteria for update value of Update query?

Rich - 11 Aug 2006 9:27 PM - 3 messages

Hello, I need to update the following table. ID2 is updated to the value of ID1 except if ID1 has a Prefix of 'TCC' that must be replaced with 'SEC'. If ID1 does not have a prefix of 'TCC', then 'SEC' must be added to the ID2 value ...

EXEC Function........

Tam OShanter - 11 Aug 2006 9:12 PM - 4 messages

Hello All, I'm looking to use the EXEC function to execute an SQL Command made up of concatenated varchar(8000) variables. I was of the belief that the EXEC function could handle upwards of an 8000 character SQL Statement, however, my statement keeps getting truncated at ...

Pull a range of records from a char(8) field

TCHolzer - 11 Aug 2006 8:59 PM - 5 messages

I need to pull a range of records based on the street number. The number field is char(8). The problem occurs when a letter was entered in the number field as well as in 300A, 3505B, etc. Both of the examples below return an ...

ODBC insert of SQL_TYPE_TIMESTAMP

LDJ - 11 Aug 2006 8:16 PM - 5 messages

Hi, I'm trying to insert a time stamp into SQL Server (2005) and can't figure out the right combination of column type and arguments to SQLBindParameter(). My C code currently looks like this: rc = SQLBindParameter(hstmt, 7, SQL_PARAM_INPUT, ...

Conversion failed when converting datetime from character string.

Kyle Thering - 11 Aug 2006 8:09 PM - 8 messages

i am having some problems with a stored procedure that i created its giving me an Msg 241, Level 16, State 1, Procedure AS400ImportCSSCT, Line 19 Conversion failed when converting datetime from character string. error any information would be helpfull, what the SP is sposed to do is ...

Daily Partitioning

pqrsuresh - 11 Aug 2006 7:24 PM - 1 message

Guys, Please help me out in this. I am new to this SQL Server 2005 Partitioning. Here is the scenario, there is Log table which consists of 1 million rows to be inserted in a day. I would like to partition this table into ...

is there a ' combination join' of left outer and right outer join

SQLken@gmail.com - 11 Aug 2006 6:52 PM - 8 messages

I have two tables as follow: Table1 Table2 ...

Dynamic Where Clause using COALESCE() question

glen - 11 Aug 2006 6:26 PM - 4 messages

I have a stored proc with 6 input paramaters, 4 of which I want to build the where clause. The first 2 work fine, the second 2 when used cause an empty recodset to be returned. There are no NULL values in any of the fields ...

Rowcount

Rob - 11 Aug 2006 5:56 PM - 6 messages

SQL newbii here. I am working with Reporting Services with an Oracle DB. I want to know how to determine how many rows are returned in a query. For example: select * from company How do I get a parameter or something that shows me how many rows the query ...

annoying behavior of Log File Viewer in sql2k5

=== Steve L === - 11 Aug 2006 5:23 PM - 1 message

is there a way to modify the behavior of this new 'future'? when viewing the different types (windows, Database Mail, SQL Agent and so on) of event in the Log File Viewer using check box (under 'select log' panel'), the 'progress' panel kept spinning thru the whole record ...

Merge tables

joseph.chewning - 11 Aug 2006 4:48 PM - 2 messages

I am trying to merge 12 tables that have 6 columns in common and the rest are unique to that table. I want to merge them into a table that has all the common and unique columns. Is there a script or product ...

Cross tab

Ric - 11 Aug 2006 4:26 PM - 4 messages

I have two tables: Task and TaskType. One Task always has three TaskTypes: create table task (taskID uniqueidentifier,taskname varchar(20)) create table tasktype (taskID uniqueidentifier,tasktypename varchar(20)) insert into task values ('EC02ED43-265C-47BC-9575-4C62F55A24E3','Documentation') ...

Dynamic SQL > 4000 Characters Issue

RitaG - 11 Aug 2006 4:11 PM - 6 messages

Hello. I have a Stored Procedure that has a required argument passed to it. This argument is then used to create dynamic SQL which is then exectued via the EXEC statement. I'm using an nVarChar(4000) since nVarChar has a limitation of ...

ID Column Question

robken - 11 Aug 2006 3:47 PM - 6 messages

Hi all, Does anyone know if theres a way to add an identity column into a SELECT...INTO Query? Either that or can you add one into an existing table. Thanks Alot! Rob. ...

security loophole for the TargetServerRole ?!

=== Steve L === - 11 Aug 2006 3:41 PM - 3 messages

I'm really surprised not hearing anything back about this. to me, this is a serious security loophole, it allows users to hop servers and access the databases and info restricted to them and went unnoticed. is microsoft even monitoing this newsgroup?! ...

DBC to SQL Server

Nick - 11 Aug 2006 3:35 PM - 3 messages

I have a database in VFP. How to generate a database in Sql Server with same structure? Is there any tools? ...

Need Query help with JOIN

mavrick_101 - 11 Aug 2006 3:11 PM - 4 messages

Hi, I am trying to get rid of an old query which used *= to fetch results from three tables. Here is the problem Table 1 -------- NewsCatid NewsCatTitle NewsCatDesc Table 2 -------- NewsId NewsCatId NewsTitle NewsUrl Table 3 --------- UserId NewsId I am trying to get all the news. If the user has read a particular news ...

Variable table name in a cursor declaration

joseph.chewning - 11 Aug 2006 3:06 PM - 6 messages

Hi all, I have been trying to get this to work but keep getting an error. Can you use a variable table name in a cursor declaration? Like so: declare mysub cursor for select SUBJID from @SubTable If not how can I get around this problem??? ...

Connection options

simonZ - 11 Aug 2006 3:01 PM - 2 messages

When I create some stored procedure in enterprise manager and then edit the syntax in sql query analyzer, I always get the folloewing 2 lines in front of procedure: SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER PROCEDURE ..... ...

SSAS - Can it do this?

Andy - 11 Aug 2006 2:31 PM - 3 messages

Sorry of this is an odd question, but Iâ€™m trying to see if SQL Server Analysis Services can help us out. Basically we want to recommend products to customers based on Three random titles that they have rated highly themselves in the last 3 ...

Comparing two tables

gv - 11 Aug 2006 2:05 PM - 5 messages

Hi all, Trying to compare two tables for Changes and new rows. I keep getting an error near Where? And is this a correct way of doing this? SELECT old.* FROM (SELECT * FROM table1 old LEFT OUTER JOIN ...

Insertion into IBM DB2 from SSIS task

Faiza Ashraf - 11 Aug 2006 2:00 PM - 2 messages

Hi , I am trying to insert data from SQL server 2005 source into DB2 table. I am using OLEDB command transformation with a connection(successfull) on DB2 This is the Syntax i am using inside OLEDB command task: Insert into MMTSTLIB.INTIIF ...

HOST_NAME() oddness

CyberDwarf - 11 Aug 2006 12:44 PM - 4 messages

Hi y'all Does this make any sense?? SELECT HOST_NAME() gives correct workstation name when run within QueryAnalyzer on my workstation, BUT.... We have a stored proc which uses HOST_NAME() to store a logon record. When the stored proc is called from VBA code (we have to pass it a User ID), ...

SQL Server 2005 cause system to stop responding

Programatix - 11 Aug 2006 12:12 PM - 1 message

Hi, I'm having problem with SQL Server 2005 (with or without SP1) on my Windows 2003 Server SP1. It causes the server to stop responding. When clients tries to connect to it (by file sharing or print sharing), the clients will also ...

4 key as primary key.then can't link up to another table as foreign key ?

calvin - 11 Aug 2006 11:54 AM - 2 messages

bug is studio expess ? ...

Querying from and xls file all format of data in one field (date,

pontitt - 11 Aug 2006 11:36 AM - 6 messages

Hello, I would like to ask how it is possible to make a query in MSQuery that can retrieve all format of data from an Excel file, ie: In a spreadsheet I have the following data: A B C ...

tree sort??

dave@bigcompany.com - 11 Aug 2006 11:00 AM - 5 messages

I am unfortunately limited in what i can control in this case. At best i will be accessing this data using msde with the data imported from an xml dump from another program... other possibilities are from the same xml ...

Merge dateranges ?

KL - 11 Aug 2006 10:34 AM - 4 messages

Is there an easy way to merge overlapping dateranges from several tables ? Thank you KL. ...

Is there an eval() function in sql server 2000?

Steve'o - 11 Aug 2006 10:25 AM - 6 messages

SQL Server 2000 SP4 I would really like to allow users (admin only) to create custom calcuilation columns by entering the calculation in a field as text eg calc_1 varchar(100) calc_1 = ((([col1]+[col2])/[col3])*100) So the actual calculation is stored as plain text, then the views are simply ...

11 Aug 2006 : Custom Sequencing/auto increment for SQL server db/table

Sham Yemul - 11 Aug 2006 9:09 AM - 4 messages

Hello , I am new to SQL server news group, not sure its a right place for my question. We need a custom sequencing solution for Patient's OPD no, the number has two parts Unique Number in financial year and year tag for e.g. 1200/06 ...

what is the difference between truncate and delete

SQLken@gmail.com - 11 Aug 2006 7:03 AM - 6 messages

Hi, i've been using both delete and truncate a table, but don't know exactly the differences between them. Thanks Ken ...

Finding "invalid" characters in a string

Jim Coyne - 11 Aug 2006 6:40 AM - 4 messages

We have a column whose data is suppose to start with a "P" and then contain 7 other digits to make up the entire code. There was no checking on insert to make sure the code followed these rules. So in order to clean up the ...

data base info

Mukut - 11 Aug 2006 6:38 AM - 2 messages

Hi all, we have restored a database, and then by runing an upgrade utility we have upgrated the database. Now , we need to test the upgrated database i.e all old tables are present in the correct scema...space used in the current ...

SQl Server Business intelligence Development Studio

Santhosh - 11 Aug 2006 6:32 AM - 3 messages

Hi, Please let me know how to install the "SQl Server Business intelligence Development Studio". Does it get distributed as part of SQl server 2005 Enterprise edition etc. Please pass on any useful information. Thanks Santhosh ...

Stored procedure problem

Sid - 11 Aug 2006 6:28 AM - 4 messages

How can I write a procedure where I want the following scenario I have a field called "suburb' create someProcedure ( suburb1 varchar(50), suburb2 varchar(50), suburb3 varchar(50) ) AS BEGIN .... ... END GO I want to check in a table if records exists such that suburb matches ...

How to return the auto increment fields?

Cylix - 11 Aug 2006 4:54 AM - 3 messages

Sorry for newbie question, I am going to create a stored procedure for two task: Inset a row to a table, and return the Identity field(which is auto-increment) to the program. Thanks. ...

Primary Keys : Distributed Database : Not using GUID or Indentity columns

Russell Mangel - 11 Aug 2006 4:52 AM - 1 message

Question: I would like to generate Primary Keys for tables in a *distributed* database. How has this been done before? I can't imagine that this problem has not been solved a million times, but I have been unable to find good information ...

dynamic SQL versus a huge IF structure

ibiza - 11 Aug 2006 4:04 AM - 5 messages

Hi, I have a stored proc intented to search a table on different fields, depending on the search type. Up until now, I have implemented 3 options, which is by kanji, kana and english. I'll add many others, like strokes count, radical # and so on. ...

Query: update based on aggregate

Dave - 11 Aug 2006 1:05 AM - 3 messages

I need to write a a query to update col3 to 9 for each unique id _but_ only the record for that id that has the max col2 value col1(id) col2 col3 1 2 4 ...

best practices for db pulling from other sources

mahalie - 11 Aug 2006 12:46 AM - 1 message

Our accounting software uses SQL (on a different server) as a backend, and I'm allowed read-only access to it. I pull a lot of data from it related to our employees, contacts and company projects using a DTS ...

Call Stack in SQL Server

kelly.harrison - 10 Aug 2006 11:24 PM - 3 messages

Is it possible to get the call stack from within a SQL statement? Specifically, I'd like to get the statement that causes a trigger to fire from within the trigger itself. Thanks, -k ...

SQLPerformance:datavolume over the network per connection?

mabra - 10 Aug 2006 10:36 PM - 3 messages

Hi All ! I am trying to find the amount of volume of data each connection is reading/writing. I initially looked into Perfmon, but it does not have such counters. I am looking for something like "sp_who/2", which give me ...

Experiencing Timeout issues updating NText field in SQL Server

Chris Asaipillai - 10 Aug 2006 9:42 PM - 2 messages

Hi there Has anybody experienced Timeout issues on updating NText fields in SQL Server 2005? Ive been using a procedure in an MS Access application, to read in the contents of an Ntext field used for notes into a local string variable. ...

isqlw.exe from a console app

Jayyde - 10 Aug 2006 9:25 PM - 3 messages

Can someone who knows a lot more about this than me please tell why, when the following code executes, I get a pop-up window telling me the usage of isqlw.exe? <code> strQueryCommandPath = "C:\\Program Files\\Microsoft SQL ...

Classic task or classic lack wth triggers ?

V T - 10 Aug 2006 9:19 PM - 2 messages

Hi, I am trying to maintain logical data integrity by using triggers. In my case I have "Item" table and "SaleTransaction" table for which item_id is a foreign key. Item record can have 0 or 1 "saletransaction" records. Now let's assume that there is Item.salestatus field and one of ...

Complex Query (atleast I think so)

Preacher Man - 10 Aug 2006 7:43 PM - 5 messages

We have a couple of Bill of Material tables in our SQL 2000 database and I need to extract information. The first table is the master table and the only relevant field is fpartno. Table two is the child table, and it contains all of the parts that make up ...

Help joining 3 different tables...

The Saint - 10 Aug 2006 7:15 PM - 5 messages

I am trying to join three different tables on common column names, with a Group by clause on the first table. This is the error I keep getting The column prefix "column name" does not match with a table name or alias ...

Partitioned view (SQL Server 2000) & Triggers

RS - 10 Aug 2006 5:16 PM - 1 message

Hi, Per SQL 2000 BOL, "A partitioned view will not be updatable if a trigger or cascading update or delete is defined on one or more member tables. " However, I'm able to update a partitioned view, and from looking at the ...

Having difficulty with Coalesce

Matty J - 10 Aug 2006 4:51 PM - 3 messages

Hi Simplified version of query: Have tried both with and without SET CONCAT NULL_YIELDS_NULL ON But my database default is set to ON anyway. SELECT Address1 + ' ' + Address2 + COALESCE(', ' + Address3, '') + ', ' + Town + COALESCE(', ' + County, '') + ', ' + Postcode AS Address From Table I'm only new to the COALESCE function, but when say Address3 is NULL, ...

random select a row based a weight column.

Guoqi Zheng - 10 Aug 2006 4:39 PM - 13 messages

Dear sir, We have a banner system which we like to show banner based on a weight assigned to it. The more weight a banner received, the higher possibility this banner will be selected. So the table is: BannerId, Content, Weight. ...

can't inser rows in partionied views

dadbhawala - 10 Aug 2006 4:20 PM - 2 messages

I cant insert new rows through the view for the following tables and view... FOR EXAMPLE THE FOLLOWING INSERT STATEMENTS give error insert into states values( '1','john','CA' ) insert into states values( '2','MARY','NY' ) Server: Msg 4436, Level 16, State 12, Line 1 ...

How to retrive rows from MS SQL server from batch script

Ian - 10 Aug 2006 4:12 PM - 4 messages

From my batch script I am able to count the number of rows that satisfy a query but not able to retrieve the rows. For example, these work: 1 - select count(*) from unsupported 2 - select count(*) from unsupported where systemname = 'tracker' ...

Dynamic SQL Question

RitaG - 10 Aug 2006 3:52 PM - 5 messages

Hello. A have a Stored Procedure that has one passed in variable. I need that variable to append to a table name that needs to be dropped if it exists. My dynamic SQL looks like this: Create Procedure MyProcedure ...

store results over network

Vito Corleone - 10 Aug 2006 3:32 PM - 7 messages

I had created a view on a sql server 2000 (BigDaddy) select * from employee and I want to schedule this view to be executed daily at 2am. The results must be saved on a workstation, AAA1009. How do I schedule so sql server can execute the view and save the results ...

Readonly Table ?

Jay - 10 Aug 2006 3:29 PM - 10 messages

In SQL Server 2005 is it possible to set a table as readonly? I know you can mark the entire database as readonly but what about just on table? ...

Self join question

burt_king - 10 Aug 2006 2:53 PM - 2 messages

We've got a self join on a table with a view of that table and two others. Off the cuff, does anyone know if this is valid / not valid / a darn bad idea. The PeopleSoft software we're using does an update based on the results of ...

Select all databases and run a select queries against each

Skeptical - 10 Aug 2006 2:31 PM - 9 messages

Hello, I was able to select all databases from master..sysdatabases, but I am not sure how to run queries against each row so I have something like: "database" "query result" "database2" "query result" .... Any ideas? PS: Each query should run against a different database ...

SQL Server 2005 Express

Prabhat - 10 Aug 2006 2:25 PM - 4 messages

Hi Friends, I have installed SQL server 2005 Express Ed. and management Studio Express. How Do i know if these are havibg SP1 Installed or not? I have the Database displayed as: MyHomePC\SQLExpress (SQL Server 9.0.2047 - as version info. ...

Timeout expire

fniles - 10 Aug 2006 12:49 PM - 25 messages

When running a query in SQL Server 2000, I got "Timeout expired" error. How can I increase the timeout time ? Thanks. ...

Oracle DBA to learn MS SQL

sandiyan - 10 Aug 2006 11:13 AM - 6 messages

Is there a materials such as the following for an Oracle DBA who would like to learn MS SQL(e.g. 2005) - Training courses - Web sites/ebooks - MS articles - etc SQL Server features and compare it with Oracle. So, it should be something of learning method for a person with DBA ...

Strange SQL query results... Help!

Masterx81 - 10 Aug 2006 10:41 AM - 5 messages

Ho to all... I'm stuk with a problem on a simple query... SELECT risorse.ID_Risorsa,risorse.CODICE,a.ID_Ordine FROM risorse LEFT JOIN (select * from lavorazioni WHERE lavorazioni.DATA_INIZIO<25/08/2006) a ...

Copy file from an SQL procedure

Rui Oliveira - 10 Aug 2006 10:00 AM - 7 messages

Is possible copy a file from a directory to another, from a SQL procedure? Thanks, Rui Oliveira ...

Rebuild indexes

simonZ - 10 Aug 2006 9:32 AM - 6 messages

I'm using this procedure to update all indexes in my database: [link] Here in procedure Kimberly created the following table: CREATE TABLE #ShowContigOutput ( ObjectName sysname, ObjectId int, ...

Optimize this query

Olivier Matrot - 10 Aug 2006 9:12 AM - 18 messages

Hello, I would like to optimize the following query. The goal is to give a record number on each row based on a row owner and a timestamp. UPDATE dbo.mytable SET rec_id = (SELECT COUNT(*) FROM dbo.mytable b WHERE owner= N'me' and ...

Is explicit ordering from subquery propagated upwards?

sugnaboris@gmail.com - 10 Aug 2006 8:36 AM - 6 messages

I've tried this with an example - but of course an example isn't definitive indication that the behaviour is required by standard (SQL-92) or is guaranteed by implementation (SQL Server 2000). Hope someone can help by pointing me in the right direction. ...

cast and convert differ?

cn.popeye - 10 Aug 2006 8:22 AM - 3 messages

this is date: 01 08 2006 declare @d_date varchar(20) set @d_date = '01 08 2006' using convert: select convert(datetime,@d_date ,120) ------ 01 08 2006 replace space to '-' select convert(datetime,replace(@d_date,' ','-') ,120) ------ 01 08 2006 replace space to '/' ...

SQL 2000 ODBC Timeout Errors

news.microsoft.com - 10 Aug 2006 6:41 AM - 3 messages

I have posted this across several newsgroups. I hope that this finds an answer in one of them. Hello, I have a client that is having this issue: Server 1 SQL Server Database FrontPage Server 2 IIS 6.0 with ODBC connection to database ...

exec master..xp_cmdshell 'net use ' resultis NULL??

cn.popeye - 10 Aug 2006 5:30 AM - 5 messages

exec master..xp_cmdshell 'net use ' result output ------ List is NULL NULL NULL cmd window C:\Documents and Settings\cn.popeye>net use status local server network ...

How can I insert a new field between existing field?

Alex AU - 10 Aug 2006 1:29 AM - 9 messages

Dear all, Is there any way can I insert a new field between existing fields through TSQL or other means, without using Enterprise Manager? Thanks a lot. Regards, Alex AU ...

Creating Percentage Discounts

stjulian - 9 Aug 2006 10:52 PM - 2 messages

In my table, I have an integer representing a discount percentage. The price of the item is stored without the discount but the view I would like to create should show the "extension" as quantity * (price - (price * (percentage/100))) AS extension ...

Forum Database Design

trini78 - 9 Aug 2006 10:21 PM - 1 message

I am looking to develop a simple forum. Can anyone give me some direction on if my design concept thus far is adequate. I'm currently thinking of using three tables. One houses the moderators information, the second is thread ...

Stored Procedure IN statement

Fractional truncation of Input Paramater in a UDF

update the record just insert into database

Setting a default value for an image column

Deleting Different Records at different Parts of the day

Extracting notes from diff tables

Select IIF Exists

fixing row summation error due to left join

can you make a trigger work on a schedule?

Change rows into columns

NULLS

altering column names

Retrieving records with maximum date

returning row when count = 0

Avoiding cursors

union join

Duplicate Query Trouble

AbS function issue

SQL 2000 Configuration

DateTime

insert date timestamp into a table

index

Storing MultiLanguage strings on English SQL Server

Parenthesis disappeared when caheck constraint created from qa

multiple OUTER JOIN-s

Problem with restoring

Need a testing database from production database

TOP 50 invoices by company

Delete using a Join

Denormalizing a database table

Cascading Deletes - Best or Recommended Practice

switch user in the session

SQL 2000 vs 2005

COALESCE & Empty Values

Query Analyzer. What settings to see the data output again?

SSIS Execute SQL Task xml mapping to varchar variable conversion e

2005, Ambiguous column name, and ORDER BY

add an apostrophe to a string in bcp command

auditing changes

How do I change user login in my scripts

How to query a keywords table for multiple matches

Inserting, updating and selecting BLOB columns

sql update query

incorrect syntax near ' '2006-6-29'

Pass Variables into SQL query

Aggregate function MAX ignores NULLs

Table Names

EspaÃ±ol

JOIN QUERY

DTS Import wizard does not show all Access tables

Best way to insert into using value from another table

'Transaction was deadlocked

(SQL Query) How to number groups of records?

Full Text Catalog and Searching

Query Question

Deadlock Key ObjectID is bigger than an integer

Select into a table name variable?

name comparisons

Query Performance on Partitioned View

Getting MAX() with subtotals?

Since I can't pass a table as a function parameter . . .

SQL Server 2000 - Invalid column name

How to define a foreign key?

Connect directly to database file using sqlcmd

Query Optimisation

Help: Exporting data from from filed to file

migration script very slow or normal?

How to Restore Distribution database

Index View Issue since Migration to SQL 2005.

A different duplicate rows headache :)

SQL Script

Need help with SQL query in ASP

SET varchar variable

back slash

Using SQL from A Text Box

What is the correct sequence of Restoring Databases in SQL server 7.0

Duplicate rows Headach

Removing letters from the end of a string in a query

HELP!!! DOGS IN CHINA

Composite primary key on temp table.

Issue With SP Using IN operator- causing deadlock message

sys.dm_exec_query_stats What is a microsecond

OPENROWSET BULK

a data model question...pls help.

sorting

How do I add foreign key to a table?

On the 15th Day of The Israeli Aggression : A total of 958 deaths since the beginning of the war....

Select where IN

sql 2005 linked servers @@identity

date query

BOL says you should not kill a SELECT statement. Why not?

rtrim

How to delete text file from within trigger code?

How do I find dependencies for a certificate?

I cannot find what ## means

SOLVING YOUR PROBLEM

Need script to replace dbo on all user SPs

Problems restoring .BAK database to SQL 2005

XP_EXECRESULTSET in SQL 2K5

Need help with my Query.

DateTime Convert UTC to Local

ntext to nvarchar conversion on Update/Set statement

Convert rows to columns

A strange phenomenon in stored procedure

Option to delete a file

Trouble with query converting from Access to SQL Server

Show all possible values not only currently available

Dynamicly maintains indexes with a stored procedure

How Sqlserver 2005 Express Edition is installed in silent mode?

SQL output and predetermined values

How to store a very long dynamic sql query?

Can 2005 mirroring be temporarily 'turned of' programatically?

Forcing connections closed before doing an smo restore

Batch Update

Stored procedures not visible in VS 2003, SQL Server 2000

Newbie needs help with Stored Procedure

query

newbie: problems in my stored procedure!

Getting File Info using GetDetailsOf

Encrypt/Decrypt Issues

Compile and run HTA

COALESCE in WHERE CLAUSE - Need help

ADODB Sort

Multiple column primary key

Trigger Help For Update

Connect directly to database file using sqlcmd

database is read only/stand by

Most used Stored Procedures

Data type summary

Problem with using BULK INSERT and privileges

Need an IF statement in a query

sys.dm_exec_sessions

Exporting the results of a stored proc to XML

Stored Procedure Column schema

Reserved Word Column Names