SQL Server database programming

MS SQL 2000 - SQL Select with XPATH Where Clause

Bryan - 3 Jun 2006 11:56 PM - 2 messages

In MS SQL Server 2000, is there an easy way to use an XPATH statement in a WHERE clause? I have a table with a TEXT column that contains XML. I would like to query this table and select any rows where the XML data field meets ...

Another SQL Query!

simon.stockton - 3 Jun 2006 11:04 PM - 4 messages

Dear All, I have two tables in my database, part of a tennis league results and fixtures website I am putting together. Results id fixture_id home_team_rubbers away_team_rubbers ...

question on Transactions and Commit

THOMAS CONLON - 3 Jun 2006 7:49 PM - 3 messages

If you start a transaction with BEGIN TRAN and then, for some reason this is interrupted and not recovered from (in other words, no ROLLBACK or no COMMIT), what happens? Is there a time after which this will timeout? If ...

Inserting a new row through management studio express: newline problem

NightRaVeR - 3 Jun 2006 4:38 PM - 4 messages

Hi, I have been developing a new website, and untill the management part is completely finished, I'm entering some data through MS SQL Server Management studio express 2005. But, whilest in SQL 2000 Enterprise manager, I could give in a newline ...

Update Access tables from T-SQL code

Mark Paulson - 3 Jun 2006 4:11 PM - 3 messages

Hi All, I need to copy some rows and update some columns in a few Access tables based on events happening in a SQL Server database. This is not a one-time event, it needs to be an ongoing "sync" of the two databases. We have both a ...

Merging multiple rows into a single row.

Kevin Burton - 3 Jun 2006 3:46 PM - 10 messages

I have been doing some rearranging of some tables and I ran into a "legacy" stored procedure that I would like to keep the data set that it returns the same if possible. The stored procedure used what I will refer to as the ...

How to store this string

Jonah Olsson - 3 Jun 2006 9:07 AM - 9 messages

Hello, I have string that I need to store in a database, but I don't know exactly how. These strings could look like this: A001111105110416352489 I parse the string through a RegEx looking like this: ^([A])(\d{3})([0|1]{3})([0|1])(\w*) ...

SQL QUERY!

simon.stockton - 3 Jun 2006 7:59 AM - 3 messages

Dear All, I have two tables in my database, part of a tennis league results and fixtures website I am putting together. Results id fixture_id home_team_rubbers away_team_rubbers 1 229 2 2 ...

Trigger to populate database

Jchick - 3 Jun 2006 3:12 AM - 2 messages

Im a newbie with a sql table in a MSDE database that contains fields of CustName, BrokerName, Type, Status. I am trying to write a trigger that does this: 1. When a new record in a table is added, I would like the selected ...

non-identity Primary Key

Chris - 3 Jun 2006 2:45 AM - 5 messages

I need to be able to increment a Primary Key of type int without using IDENTITY. The reason is that I need to be able to Archive and restore data to this table, and maintain the Primary Key. Anyway, I setup a trigger to get the Max(MyIDfield) which works fine when ...

Split a table

Howard - 3 Jun 2006 1:28 AM - 7 messages

I would like to split a table in half and save one half for offline archive. ie. move all rows that have COL_ID < 10000 to another database and keep the structures, same index, primary key If I just use an update and delete query it would insert rows incrementally. ...

Views VS Temp Tables...which to use...or is there another solution?

stevenjho1968 - 2 Jun 2006 10:12 PM - 5 messages

I have to retreive data that is somewhat complicated. This data in the past has required two views and a final ASP SQL Query. I am in the process of updating everything to ASP.Net 2.0 (VB) and would love some ...

Question on DTS

Robert Bravery - 2 Jun 2006 9:55 PM - 4 messages

HI all, Which is better, to use DTS for CSV type file imports or to write your own import app. Considering the following that it is most likely that the structure of the import file will change a few times within the next year, and that this is ...

SELECT * in SQL 2005

Ricky - 2 Jun 2006 9:25 PM - 4 messages

Hi Just a quick question, we are thinking of moving to SQL 2005 and I heard somewhere that SELECT *, is not supported in SQL 2005, is this true? Kind Regards Ricky ...

float vs decimal - computation time

CP Developer - 2 Jun 2006 9:16 PM - 3 messages

I have heard that using floats in calculated fields are much faster than using decimals. Is this true? What is the role of the floating-point processor in these computations? Jason ...

Get unique sequential number- best practice

Ronj - 2 Jun 2006 9:00 PM - 4 messages

I need a number generator. (e.g. for Receipt number, or transaction number, etc.) in a multiuser high volume envoironment. What is the best way to get one from SQLserver2005? (no duplicates allowed) 1) I've seen a StoredProc that will get value, value++, then save back, ...

BULK INSERT errors

tobinlim@gmail.com - 2 Jun 2006 8:44 PM - 8 messages

I'm writing a .NET component that will bulk insert a file into a table. I also have a string array inside the class whose purpose is to capture the errors during the bulk insert process. Can this be done? ...

Remove Comma from rows in table

Lontae Jones - 2 Jun 2006 8:13 PM - 3 messages

Hello, My schema is as follows: Create table Test (Emailaddress varchar(50)) I have numerous rows that have a comma after the emailaddress and I need to remove the comma. Example jonsamu***@aol.com, Any help would be great. ...

Cascaded SELECT for multiple fields

Stephen Howe - 2 Jun 2006 8:05 PM - 6 messages

Consider 2 tables Tabe1, Table2 which both have int fields fld1, fld2. I can do a Cascaded Select on 1 field: SELECT fld1 FROM Table1 WHERE fld1 IN (SELECT fld1 FROM Table2) or SELECT fld1 FROM Table1 WHERE fld1 NOT IN (SELECT fld1 FROM Table2) ...

Client tools

Fabri - 2 Jun 2006 7:44 PM - 5 messages

I have installed sql server 2005 express. I would like to administer it as I did with sql server 2000: - Enterprise Manager - Sql Query Analyzer Are there soem tools out there to download? Any help appreciated. Best Regards. Fabri ...

unique row identifier

ciprian - 2 Jun 2006 7:40 PM - 6 messages

hi there. please let me know if any of you found a way to set/get an unique row identifier without creating a new column in sql server. i'm in a hurry ... so please help if you can. even with alternative ...

Duplicate Information with Different IDs

JDArsenault - 2 Jun 2006 7:12 PM - 7 messages

Duplicate Information with Different IDs I am trying to sum monthly hours for weekly timecards which have multiple line items as tasks, but I am retrieving duplicate entries. This is because a timecard can have a timecard_type of "r" (regular), or a ...

BULK INSERT file with quoted strings, but no quotes when NULL

Aardvark - 2 Jun 2006 6:55 PM - 4 messages

Hello, I've put together a format file for a text file that I need to import using ",\"" and "\",\"", etc. as column delimiters. This would normally cover the whole problem with quoted strings. However, in this particular file if a string value is NULL then that column doesn't have ...

SQL Server Express and Query Notification (Service Broker)?

Marcus - 2 Jun 2006 5:54 PM - 2 messages

I would like to utilize "query notification" (part of Service Broker in 2005) to inform my client app when a database table has been updated. I am using only SQL Server 2005 Express. BOL says: "Microsoft SQL Server 2005 Express Edition (SQL Server Express) ...

I'm Stumped - Adding values of two columns

ehorde - 2 Jun 2006 5:47 PM - 5 messages

I am at a loss...I have tried everything.. Hopefull this is so easy I'm missing it all together. I have a very simple data entry table that is going to be used in other areas (asp, etc.) ...

Trigger question

Bob - 2 Jun 2006 5:46 PM - 2 messages

I have a field LastUpdatedBy in a table as well as LastModifiedOn. I need to have an insert edit trigger to puts today's date time in the LastModifiedOn and I need to retrieve the currently logged in domain user name and put that ...

The Domain www.bestwaypay.eu is now for selling. The Domain for OVER 450 Million People in Europe.

TAKE a LOOK !!! - 2 Jun 2006 5:38 PM - 2 messages

The Domain [link] is now for selling. The Domain for OVER 450 Million People in Europe. ...

covering Primary Keys.. What's too much

Chris - 2 Jun 2006 5:15 PM - 6 messages

I have a table which I'd like to create a Primary Key that would have to cover 6 fields to enforce uniqueness. My question is, is that too much. I know it's common to have tables with ...

Dynamic SQL within a function

Sandra Parra - 2 Jun 2006 4:56 PM - 2 messages

Hello, I need to create a view on a database based on tables from other databases. I'm creating a function to lookup the data in the other dbs and use the function on the view. This is the function. ...

Is there a single string or other function in SQL Server that retu

Chandler Miller - 2 Jun 2006 4:39 PM - 6 messages

Hello: Is there a single, undocumented function in SQL Server 2000 or 2005 that returns the first letter of each word in a sentence or group of words as upper case and the remaining letters in lower case? We can do this with ...

DRI across databases

Julian - 2 Jun 2006 3:58 PM - 4 messages

I know, I know. It's a bad idea and I understand why. But if DRI across databases is not an option, what are the alternatives? What do you do when you're hired to "sort out the database" and it turns out that the company that hired you has a ...

Clustered Indexes and physical order.

MAS - 2 Jun 2006 3:54 PM - 12 messages

I've got a question about how clustered indexes map to the physical order of the records in a database. I've always been under the impression that a clustered index orders the records physically in the order of the clustered ...

Update taking value from Stored Procedure result

Fabio Cavassini - 2 Jun 2006 3:00 PM - 2 messages

--I have this temp table: declare @CatRel TABLE ( [Category_RootAndName] varchar(200), [Category_Id] decimal, [Category_Rel_Des] varchar(200), [Category_Rel_Id] decimal, [Category_Rel_Order] int, [Language_Id] decimal ...

Disaster Recovery and Bulk Loads

Darren - 2 Jun 2006 2:06 PM - 2 messages

We are in the process of migrating our database to SQL Server 2005 Standard and I have a question regarding disaster recovery and bulk loads. We periodically do bulk loads of data from files (csv's, flat files, etc). Our ...

Table design question

Scott Lichtenberg - 2 Jun 2006 2:04 PM - 11 messages

I have a question regarding database design. Apologies in advance for the length of this post, but I'm somewhat at a loss here. I am creating an items table which will contain records for many different types of products. Each product has a number of common attributes (cost, ...

Importing data

someone - 2 Jun 2006 1:18 PM - 3 messages

Hi all, I am having hard time trying to import data from a dbf file into a Sql table. The dbf file has 700 columns. I tried using DTS, the OPENROWSET, etc. Nothing works for me. Any idea how I can import such a large file into Sql. ...

.ASP .Net on SQL2000\Win2000

Colette - 2 Jun 2006 12:48 PM - 3 messages

Can anyone tell me what the SQL requirements are regarding using APS.NET are? For example, can it work with windows only authentication? Are there articles out there I can refer to? Thanks for your help. ...

All tables under partitioned union view get locked - how to reduce?

McGeeky - 2 Jun 2006 11:52 AM - 11 messages

Hi. We are using a partitioned view across a number of tables. They are partitioned on a single column. We use the view to insert and update rows in the underlying tables. When loading all the rows for table XYZ through the view we find that SQL ...

Update based on some combinations

Rajeev - 2 Jun 2006 11:40 AM - 4 messages

Hi I have two tables First one contain TransID(Unique key) and Flag Second one contains TransID and Code There can be maximum three codes (Home, Host,Payroll) for a transid e.g TransID Code 120 Home ...

Swedish collation, 'V' = 'W' rule and different behaviour for VARCHAR and NVARCHAR

Alex Sadomov - 2 Jun 2006 8:51 AM - 3 messages

hi There is a problem with sorting in db with SQL_SwedishStd_Pref_CP1_CI_AS collation. As I'd known there is a specific rules in the swedish language, one of which is 'V' = 'W' (this rule was revoked by swedish academy since april 2006 - [link]). ...

querying a text file, waitfor issue?

steve9 - 2 Jun 2006 5:32 AM - 3 messages

Hello, I'm querying a text file after adding a directory as a linked server. Works fine when executed as separate statements: --separate statements --first this EXEC sp_addlinkedserver txtsrv, 'Jet 4.0', 'Microsoft.Jet.OLEDB.4.0', 'C:\temp', NULL, 'Text' ...

different database connection in clr stored proc

Mark - 2 Jun 2006 4:41 AM - 6 messages

Hi, Is it possible, in a CLR Stored Procedure, to connect to a different database on the same server as the database under which the current connection is for/running? In other words, within a CLR Stored Proc running on database A, is it ...

Best way to search

Jeremy Chapman - 2 Jun 2006 3:48 AM - 2 messages

I have a stored procedure declared (shown below) The intent of the stored proc is to return all records where the field values match the criteria specified in the stored proc parameters. I want to specify some or all of ...

SQL to show the number of distinct rows in tbl linked to another

eric.goforth - 2 Jun 2006 2:40 AM - 5 messages

Hello, I'm trying to figure out a SQL query that will Show the number of distinct C_O_Id's to each A_Id. Note that A_Id 18506 is tied to C_O_Id 371 twice and C_O_Id 706 once. So that would be 2 distinct C_O_Id's. ...

select statement

Peter - 2 Jun 2006 2:10 AM - 5 messages

Dear group, how do I get all authors together with their sales.qty something like this: use pubs go select au_lname, qty from authors left join titleauthor on authors.au_id = titleauthor.au_id, sales where sales.title_id = titleauthor.title_id go ...

Import queries

Mitch - 1 Jun 2006 10:48 PM - 6 messages

I am copying data from an Excel workbook/worksheet to a SQL Server 2005 data-mart database table (not previously existing) using the SQL Server 2005 Import/Export Wizard. I would like to do it using an import query that ...

Invalid Column Name in SELECT

MikeV06 - 1 Jun 2006 10:40 PM - 3 messages

This select works as I expect: SELECT exp_AcctNum, exp_Amount, CAST(Left(dbo.strat(exp_Amount),2) AS INT) AS [Strat Level], SUBSTRING(dbo.strat(exp_Amount),3, LEN(dbo.strat(exp_Amount))- 2) ...

Insert multiple records using select clause

Bill Nguyen - 1 Jun 2006 9:30 PM - 3 messages

I need to insert new records into a table based on the date range of another table (1 record for each day). for example : insert into table A (column1, column2, date1 ) select column 3, column 4, myDATERANGE from table B ...

Deadlocks problems

Richard - 1 Jun 2006 8:52 PM - 3 messages

Hi everybody, I have deadlocks problems, somebody could tell me how is the best way to handle concurrency?? Thanks in advance, RICHARD_SQL ...

Getting @@ROWCOUNT from BULK INSERT with BATCHSIZE set

Aardvark - 1 Jun 2006 8:28 PM - 3 messages

Hello! I have a stored procedure that takes a file name as a parameter and imports the data from there into the appropriate table using the correct format file. I would like to save the number of rows inserted at the end of my stored procedure. Since the file name is variable I ...

Optimizing Bulk Insert

Ellie - 1 Jun 2006 8:19 PM - 3 messages

I am trying to find the quickest way to have a bulk insert completed. What I have found from tests is: 1. I need to have the batch size set to a minimum of 4% of the source file (otherwise the command just quits with no message). ...

Dropping Indexes

Mike C# - 1 Jun 2006 8:16 PM - 3 messages

I'm doing some bulk inserting into various tables, and I'm dropping all the indexes first, and rebuilding them after the data load. One of the tables has several nonclustered indexes + a clustered index. My question is ...

Whats wrong with this query?????

JLuis Estrada - 1 Jun 2006 7:51 PM - 3 messages

SELECT exp16.parte_orig AS 'Numero de parte (Salida)', exp50.descrip AS 'Descripción de la mercancía', exp02.umc AS 'Unidad de Medida de Comercialización', sum(exp02.cant_umcom) AS 'Cantidad', sum(exp02.val_mpdlls) + sum(exp02.val_agdlls) AS 'Monto en Dólares', exp02.fr_mex_exp AS 'Fracción Arancelaria', ...

Deadlock problem

gaploid - 1 Jun 2006 7:48 PM - 3 messages

Can somebody help me. I spend 2 days on this problem, and i stuck. i`ve got this error: Transaction (Process ID ***) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the ...

Using embeded AND's in WHERE clause?

JDeats - 1 Jun 2006 7:17 PM - 3 messages

If I have a three column table, will call it AvailClasses SchoolName, Subject, NumOfClasses --------------------------------------------------------------- Emil, Biology, 3 Emil, Chemistry, 1 Emil, Calculus, 4 Prestwood, Biology, 2 Prestwood, Chemistry, 4 Prestwood, Calculus, 2 Westhaven, Biology, 1 Westhaven, Chemistry, 2 ...

Advanced Query Question

JP - 1 Jun 2006 6:45 PM - 3 messages

What I am trying to accomplish is to return a resultset that would look like this: Company.Name Table1.Column Table2.Column Table3.Column Company A y y y ...

Import DBF data to a MySQL Table

ericpoirier - 1 Jun 2006 6:32 PM - 4 messages

Hi I'm trying to sync a DBF file stored on my customer server with the MySQL table on my server. I'm still looking for an automatic way to do it, however, for now i'm trying to find a way to create a small app that will help me do it ...

Function to determine weekoftheyear.

Miguel Arenas - 1 Jun 2006 6:03 PM - 4 messages

I looking a function to determine the week of the year. In excel I use WeekNum, but I need this for sql server. thank you. ...

SQL Performance Problem

Damon - 1 Jun 2006 5:58 PM - 4 messages

I'm trying to delete 55 rows from two tables and SQL is taking 5 minutes to complete this task. Here are some of the details. The OS is Win 2003 Server with no updates or SP1. Where using SQL2000 version ...

DATETIME as Primary Key

FredG - 1 Jun 2006 5:53 PM - 10 messages

Hello All, We have a strange issue. Environment: SQL 2K SP3a TableA Definitioin: Col1 varchar(10) NOT NULL Col2 datetime NOT NULL default getdate() ...

composite indexes - a subtle question

CharlesA - 1 Jun 2006 4:31 PM - 6 messages

I have a table like so CREATE TABLE [dbo].[account] ( [pty_id] [int] NOT NULL , [sort_code] [int] NOT NULL , [account_no] [int] NOT NULL , [account_open_dt] [datetime] NULL , [account_close_dt] [datetime] NULL , ...

Convert Access Query w/IIF to SQL Server View

Holly - 1 Jun 2006 4:14 PM - 10 messages

I am brand new to SQL Server. I had to move my data tables from Access 2003 onto SQL Server 2000. I have just upsized my .mdb using the upsizing wizard and, after some minor changes, have gotten everything to work. ...

Help with triggers

Robe - 1 Jun 2006 3:53 PM - 3 messages

Hi, Iâ€™m doing a database with three tables. The project is a little complex so I will not give details about it. What I need is the following. I need to create a trigger because when a row is deleted from table 1 I need ...

Retrieve size of db

Tony - 1 Jun 2006 3:49 PM - 4 messages

Hi all, given a certain SQL Server database (2000 or 2005), I need to execute queries/commands from a .NET app in order to retrieve the following information: 1) Database size 2) List of tables 3) Each table size 4) List of indexes ...

How to convert from old style join to ANSI ?

phils - 1 Jun 2006 3:48 PM - 19 messages

Hi, I've got a query (below) that I'm trying to convert from old style "*=, =, =*" join syntax to ANSI. On the bottom is my result but it's throwing the error "Subquery returned more than 1 value. This is not ...

Standby Server... transfering dbs

JDP@Work - 1 Jun 2006 3:45 PM - 3 messages

I started originally on how or ways to get data from a primary server to a standby server. I've had wresltling matches w/replication and associates that had months of implementation and monitoring, tweaking to get it right and keep it running, so ...

Updating two tables in one Update statement

Jami - 1 Jun 2006 3:33 PM - 4 messages

Can it is possible to update more than one table update at once in SQL server, e.g i have to update three tables with same column depnding on value from one table. i have to issue three update statements to achive ...

sp4 bug views joins and constants ?

Hans - 1 Jun 2006 3:30 PM - 7 messages

After installing sp4 I have noticed strange results when joining views with constants: create table a ( a_id int ) go insert into a values (1) insert into a values (2) insert into a values (3) insert into a values (4) go ...

Get last raws from a table

Hitesh - 1 Jun 2006 3:22 PM - 2 messages

I know we can use simple command select top 20 to select top 20 raws... is there a sql command for last raws? Thank you hj ...

Consume HTTP Endpoints in Visual Studio 2005

Naana via SQLMonster.com - 1 Jun 2006 3:17 PM - 2 messages

I'm not a web developer but trying to use Sql 2005 Web Services. I tried to create a Windows Application in Visaul Studio 2005. In the New Project dialog box, I couldn't find Windows Application template to add Web Reference. Anyone has an idea where to get the template. ...

bcp from a named instance

GH - 1 Jun 2006 3:10 PM - 5 messages

The instalation has SS2K as default instance and SS2K5 as a named instance. When runing the following where the db is on the SS2K5 instance: bcp <dbname.dbo.tablename> format nul -T -n -f <filename>.fmt ...

sysdepends table issue

Mark - 1 Jun 2006 2:56 PM - 8 messages

All: I have a stored procedure that uses select statement against certain tables in the database. Stored procedure works fine however when I run sp_depeds against this procedure, I get object has no dependecies message back. When I run sp_depends agaisnt table name, I see the same message that there aer no ...

PROGRAMATICALLY ELIMINATE DUPLICATE ADDRESSES

Don - 1 Jun 2006 2:16 PM - 11 messages

I am trying to find a way to eliminate duplicate addresses from a table. I have a table that is imported from a seperate system so I have no control over it but I need to be able to design a query that brings out last name, ...

BULK INSERT from secured share

Aardvark - 1 Jun 2006 1:26 PM - 4 messages

Hello, I am trying to use BULK INSERT to import data from a file that resides on a shared drive. I've read many posts about this, but my situation has a slight wrinkle (or two). The network people here have granted one ...

remove duplicates, add PK..need help

Chris - 1 Jun 2006 1:06 PM - 4 messages

I am currently cleaning up a "loose" database, by adding primary keys on a few particular tables that currently have none. The Primary key will contain 2 fields, but before I add the pk, I need to delete any duplicates. There should be none or very few that snuck by the ...

Error 208

Luca - 1 Jun 2006 12:58 PM - 9 messages

Hi, every morning about 06.03 AM in DB PROBA there is the follow error: Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 6/1/2006 ...

Tempdb

artematico - 1 Jun 2006 12:50 PM - 8 messages

Hi, My name is Luca and I have a problem with the db tempdev (db file and not log file). Every saturday about 23.30 PM the db grow till 27 GB (normally the size of tempdev is 100 MB). ...

sql assistance needed asap! thanks

andy_e2007 - 1 Jun 2006 11:38 AM - 3 messages

i've been using asp based code to run comparisons from one dbo table to another, then update the other with the changes or additions on the original one, this through asp is time consuming as you can imagine, and causes the ...

How to write this SQL statement?

Simon Says - 1 Jun 2006 11:27 AM - 5 messages

Hi all, I've the following records: ID Language ------------------------ 1 DE 1 FR 1 EN ...

Login Function

Jose Perdigao - 1 Jun 2006 11:22 AM - 3 messages

Good afternoon I using the following function to get the login from Windows XP ALTER FUNCTION dbo.iLogin () RETURNS varchar(30) AS BEGIN /* Sql Server autentication mode */ IF CharIndex('\',system_user)=0 RETURN system_user /* Windows Autentication mode */ RETURN SUBSTRING(system_user,CharIndex('\',system_user)+1,30) ...

sprocs v functions and caching

CharlesA - 1 Jun 2006 10:52 AM - 5 messages

Hi folks, first of all, I'm using SQL server 2000 sp3 I've got a fairly complex report that using complex joins and a couple of subqueries , some Cases and GROUP BYs and the report is part of a hierarchy ...

Renumbering Invoice Nos. through query ?

Luqman - 1 Jun 2006 8:56 AM - 5 messages

How can I renumber the following Invoice Nos. through Query. After sorting by date, the 1st invoice no. to be started with 2006050001 Current Records in table Before Query InvNo Date ...

Where data = yesterday?

Joris De Groote - 1 Jun 2006 8:36 AM - 5 messages

Hi I have this query: SELECT * FROM [MIT Retours] ORDER BY [Date] However, I want to have a where in it as well, but I don't know how to write ...

urgent help needed

Michael Sander - 1 Jun 2006 8:28 AM - 18 messages

We got some sort of a weird problem here... Since a couple of days the log file of the tempdb on ours customer database is growing by about 10 - 20 gigs per day (yes, thats Gigabytes). Since we got only about 100 gigs of free space on that raid, you can count when the ...

Query which returns only every 5th Row with a Openquery

benwilliams269 - 1 Jun 2006 8:03 AM - 4 messages

Hi @all, I'm going crazy here. I need to modify this Query so that it returns only every 5th Row because I have to generate Chart with that data and it would take to long to get 50000 rows from the DB (at the moment it takes about 2 ...

Can I call stored procedure inside the case statement

Veeru - 1 Jun 2006 7:22 AM - 12 messages

Hi Can I call stored procedure inside the case statement. ...

JDBC driver question

Adrian - 1 Jun 2006 6:32 AM - 4 messages

I have installed the Snefru SQL Creator and have to specify a JDBC driver. I am using SQL Express. Could someone please tell me the file location? Many thanks, Adrian ...

virtual column. How?

Gomez, AF - 1 Jun 2006 4:45 AM - 2 messages

Hi. How do I formulate sql syntax that includes a virtual column. Actual table: TABLE1 column1 column2 column3 I want to: select * from column1, column2, column3, VirtualColumn from TABLE1. and compute something in the virtual column ...

Debugging Stored Procedure

RKNET - 1 Jun 2006 4:11 AM - 2 messages

How to Debug the Stored procedure in SQL 2005. I thnk its thru VS, pls let me know the details or any references. Thanks ...

How to write this query?

VJ - 1 Jun 2006 3:43 AM - 4 messages

I've a Bill of Material table that looks some what like this: Table BOM: Part# Component# 1 A 1 B ...

Email Trigger

panda - 1 Jun 2006 3:02 AM - 3 messages

Hi. I am trying to set a trigger to send an email notification. is this possible in SQL 2000? What i am trying to do is send an email saying that a client has been here for 12 months and would like to raise the rent. ...

Help with Dates

Harry Strybos - 1 Jun 2006 12:13 AM - 3 messages

Hi All I have a column called Expiry_Date varchar(5) e.g. 07/08 This column hold card expiry dates as a string in mm/yy format. I have added another column called CardExpiry smalldatetime and want to convert the above varchar column to smalldatetime. ...

using master..sysdatabase return an error message in MSSQL 2005

Jodie - 31 May 2006 11:38 PM - 3 messages

Hi All, I ran the following sql statement in the command line : osql /Usa /Psa /Sjpham-pc -l60 -Q"select version from master..sysdatabase where dbid=1" -o file ...

SQL2K & SQL2005, Can they coexist?

Jorge Luzarraga - 31 May 2006 11:35 PM - 3 messages

Hi, I wonder If I can have both SQL2K and SQL2005 installed on my windows XP box. TIA, Jorge Luzarraga C ...

double vs decimal in high-frequency db

CP Developer - 31 May 2006 9:46 PM - 6 messages

I am storing financial data (stock prices, profit and loss figures, etc..) in a SQL 2005 database. The database will be updated with a high frequency. I am debating whether to use decimal or double/float to store these values and I ...

Sql error not being caught within vb.net 2.0

hardingaj - 31 May 2006 9:07 PM - 4 messages

Here is a sample Stored Procedure: Create PROCEDURE spSample AS SET NOCOUNT ON DECLARE @ErrorMsg varchar(8000) BEGIN TRY --the following error will be caught and returned to vb.net 2.0 --declare @var int ...

Sub-Query

Eric Stott - 31 May 2006 9:05 PM - 3 messages

I have a requirement that I need to extract person's data from multiple tables, along with checking to see if they are twins. The 'twin' logic is if they have the indicator of 02, 03, etc. as the dependancy code and they have ...

Mobile 5.0 app can not connect to SQL 2005 Express

RedHair - 31 May 2006 7:18 PM - 6 messages

I'm using VS2005 pro to develop one windows form and one Mobile5.0 app , they are simple apps and just connect to SQL server to get data. The SQL servers include Win2K + SQL2K, Win2K3 + SQL2K5 std and Win2K3 + SQL2K5 ...

Update multiple records - SQL

Keith Kubicek - 31 May 2006 7:04 PM - 2 messages

Thanks Dan, I alread tried = and got the same error. Where would I find an update trigger (on the Inventory table)? -- Keith Kubicek ------------------------------------------------------------------------ Posted via [link] ------------------------------------------------------------------------ ...

transport-level error

none - 31 May 2006 6:53 PM - 3 messages

Hi, I'm accessing a pair of databases with ASP.NET 2.0 (ADO), and using stored procedures on the first database access. SQL server 2005 is local: Client and server are on the same box. The first access works OK - everything gets written ...

Parameter Queries

temp tables

MOD Equivalent in SQl Server?

How can I implement error handling within a SQL script that uses b

Run Script from drive location

Rounding very small negative numbers to string

sp_executesql not working

Extended Property

@return_status from SQLCLR stored procedure

Combine two int columns into one bigint column

getting null values

SQL select question - simplify my code pls

How SUSER_SNAME works?

order by day

Select - Basic Question

Pass record to user-defined function and create xml

generating DDL

Simple Question - update statment

Re: Datalength of unicode and non-unicode types?

Data type problem

Leading zero's

Using Aggregate functions in joins

Stored Procedure input string parameter

sql question

Accessing stored proc multiple return values

Random error - Insert Into Table1 Select * From Table2

word suggest

Replicating Table

Question for changing results in sql

Datalength of unicode and non-unicode types?

Queries with Dates

UDFs, Determinism and Constraints in SQL Server 2000

Changing all Int to Bigint

Need to select random records from a given query

PIVOT ISSUE

Conversion of Char to SmallDateTime

Fast Query

Checking for duplicates

quarter date

Copying a table form one database to another

SQL help please

Update multiple records - SQL

Does a cursor re-execute the select statement everytime it loops?

linked server 2005 problems

Alter Table in Stored Procedure

Problems with ER in msde.

architecture question: not representing inheritance in the data model

SSIS task

editor + VS 2005 ?

Help with Auto Notifications

Extra Trailing Whitespace Doesn't Violate Foreign Key Constraint???

Can SQL search for a .txt document

How do I returned most recently stored record with multiple records?

Sending simple email from SQL server

Can we update the table in user defined function

Global Function in 2005

Update statement for linked server

Count results in colums instead of rows

Help with error 3274

about store proc

Parameter transfer over View on linked servers

Return Last 10 records

Help Me

Obtain MCSE,MCSD,MCSA,MCDBA,CCNA,CCNP without exams(Pay after check results)100% passing gaurantee

Need help design the database for the scheduling task

error converting nvarchar to int

Select date range with no minutes

error-checking all in one place

Need help on database design for serving delayed data

How to add same user to diff DBs on diff Servers?

Rather Simple Logic - Need some advice

SP NOT INSERTING BUT INCREASING @@IDENTITY

select top row from each group w/o using cursor - how?

How can I run sp_adduser in a trigger?

Email Validation in reporting Sevices...

Parameter is null, return all?

DMO Distribution Question

How to call a stored procedure from a function

IIF

Different Query perfromance on different machines

SQL Optimization

Find similar items

transaction log full error - out of space - need help to troublesh

Variable appending

Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema i

command scripts

Need Help on update trigger

Recordset Find method vs. direct SELECT SQL statement - which is better performance-wise?

SQL99 Question : Why No Boolean Value Columns

average question