Rating Thread / Thread Starter	Last Post	Replies	Views
Transaction question Hi All, There are 2 processes, say A and B, where B uses the values given by A in the transaction. A updates the value of a field, setting it to 'p'... priyanka	12-21-2004 10:23 AM Tibor Karaszi	1	62
Need help w/ SELECT statement within a SELECT statement Hi, I've included SQL scripts at the bottom of this message so that you can create the database if you need to. It only has 3 tables. I need help... Sam	12-21-2004 10:11 AM Sam	4	59
Modify Local IP in VB6 From Control Panel, LAN, TCP/IP, properties, IP Address, Gataway How do i change this properties with VB6 code without doing it manually? Thanks Roberto Lo Baido	12-21-2004 10:05 AM Roberto Lo Baido	2	59
Using COUNT() with CASE I getting an error: "Server: Msg 195, Level 15, State 10, Line 14 'Count' is not a recognized function name." How else can I correctly use the COUNT... DC Gringo	12-21-2004 09:45 AM Alejandro Mesa	3	51
Follow Up to Date Query Question If I have: Use WinPayment GO SELECT pos_condition_code, convert(char(11), retrieval_reference_number)... tarheels4025	12-21-2004 09:43 AM tarheels4025	1	50
Partitioned view - updating BOL states: "INSERT, UPDATE, and DELETE actions against a partitioned view are not allowed if there is a self-join with the same view or with any... DWalker	12-21-2004 09:41 AM DWalker	2	50
If or case? I wonder if any of you can help,if you can many thanks in advance. rule verification_date future_verification_date test Currency 6 ... Martin	12-21-2004 09:31 AM Martin	4	56
change collation of server Hello experts, Can I change the collation of the server, without rebuild the master db? Thanks in advance x-rays	12-21-2004 09:25 AM Brandon Lilly	1	54
Query Question I was wondering if someone would know how to write a query I would like to have done. I am working with credit cards and credit reversals. Say you... tarheels4025	12-21-2004 08:55 AM Bob Barrows [MVP]	6	51
Deadlock on a single "programming pattern"... Hi, This may seams a very simple (stupid) problem, but the point is that I could'n solve it yet. So I'd appreciate your help. There it is... I'd... Hugo Venancio	12-21-2004 08:47 AM Brandon Lilly	5	56
RE: How to Order by this resultset Try, select * from ( select 'h' as colA union all select 'f' as colA union all Alejandro Mesa	12-21-2004 08:34 AM Bob Barrows [MVP]	3	47
adding multiple rows into a table at the same time I've 3 Tables FIN_PurchaseVoucher(PK-PVGID), FIN_Invoice(PK-InvoiceGID) & FIN_PVInvoice(PK- PVFID,InvoiceFID) What i want to do is while inserting a... Renjith Chembakarayil	12-21-2004 08:31 AM Renjith Chembakarayil	6	52
How to find non-referenced columns in a database Hi All, We have a huge, complex, poorly designed database in Dev. and I need to find if there are non-referenced columns, which are defined on... Ada	12-21-2004 08:27 AM Ada	2	60
Long text Hi, I have written a UDF that calls itself and nests its operation. The output is a varchar value in XML format. But sometimes the XML is more than... Leila	12-21-2004 08:16 AM Adam Machanic	3	52
Storage Impact of nullable varchar column? Hi there... I have a couple quick questions. I'm making a table where there an be either a numeric value or a text value stored. So I need two... Bill Henning	12-21-2004 08:15 AM Adam Machanic	9	65
problem using If condition in select statement Hi! how can i use if condition in where clause of select statement I want the work like this but this is not working correct select * from... microsoft	12-21-2004 07:27 AM Ilya Margolin	1	52
Interesting Join Statement I have two tables that I have to join together. The first table contains what will be phone numbers and a date. The second table will contain... scuba79	12-21-2004 07:27 AM scuba79	5	48
Cross SQL Server Triggers Hello, I am trying to replicate some data to a disparate location from our current SQL server. Both locations are accessable in Enterprise Manager,... Jason Bennett	12-21-2004 07:01 AM Wayne Snyder	2	47
Geting data in record that just inserted ( 1 2 ) Hi, I am a stored procedure newbie, let me ask a stupid question, hope someone can help. I have a table with primary key pID and it is in int type... Gas	12-21-2004 06:35 AM Renjith Chembakarayil	10	83
internal server error Hi when i run this query to get a Statistical mode, i am getting "Internal server error" Pls throw some light SELECT ANNUAL_RT FROM PS_JOB J INNER... devg	12-21-2004 04:03 AM devg	0	52
Indexed partitioned views / partitioned indexed views Hi all, here is an interesting one for you: USE TempDB GO IF OBJECT_ID('m') IS NOT NULL DROP VIEW m IF OBJECT_ID('iv_m') IS NOT NULL DROP VIEW... Ami Levin	12-21-2004 03:50 AM Ami Levin	0	46
64bit multiple connections we have a dotnet webpage querying a 64bit sql table, the page will query the DB for every row produced (ed table in a table) although the... Paul Durrant	12-21-2004 03:47 AM Paul Durrant	2	58
Surogate keys? In my application I have several store-shops. Each receipt that is printed in the store needs to have the name of the company, the address of... Mario Splivalo	12-21-2004 03:15 AM Uri Dimant	8	62
Delete Data Without Log Hi, Is there any way to delete specific records from a table with out generating the transaction logs. -- Regards, Yash Yash	12-21-2004 02:57 AM mark baekdal	3	46
Automatically base64 decoding with openxml Hi! I have a xml document, created by query "select ImageObject from Picure for xml raw, binary base64". Type of ImageObject column is image. How can... Yuri Shustrov	12-21-2004 02:07 AM Yuri Shustrov	0	49
problem using If condition in select statement Hi! how can i use if condition in where clause of select statement I want the work like this but this is not working correct select * from... microsoft	12-21-2004 01:30 AM Tibor Karaszi	2	53
Comparing view structures In my environment we create a new view each month for our data. The views are created by a DTS package which calls a stored procedure. Over time... Andy	12-21-2004 12:59 AM Uri Dimant	2	51
Table row count (cardinality) Please could someone advise me how to determine the row count of the database tables, presumably stored in the system tables? this would avoid me... Phil Davy	12-21-2004 12:38 AM Uri Dimant	3	50
Search duplicated in a table hi all! I have to find ou t whether a record is duplicated in a table.. I know ia have to join with the same table using an alias but i can... milly	12-21-2004 12:10 AM Uri Dimant	4	50
SQL Server Error Hai, When I try to connect SQL Server installed in another machine. I am getting the following error. Specified driver could not be loaded due to... Sevugan	12-20-2004 11:40 PM oj	1	63
How to Limit Resultset Using Custom Sort We have a 10 digit primary key value in this format: M000123456. This order for this key is first determined by positions 3 and 4 in this example,... Ian P.	12-20-2004 11:38 PM oj	5	67
learning strategy I'm pretty new to SQL Server. I know there are a lot of SQL2000 (and 7 and even 6.5) installations out there; OTOH, I like being up to date,... Paul Pedersen	12-20-2004 11:25 PM Grant Case	1	55
What's more unique as a RAND seed? Hi, I've seen two different ways to feed SQL Server a random seed: (1) SELECT RAND( CONVERT( Int, CONVERT( VarBinary, NEWID() ) ) ) (2) From... Ben Amada	12-20-2004 06:40 PM Ben Amada	4	64
Creating an XML File Out of the mouths of newbies ... I have a view created from a "truly magnificent" UNION SELECT of multiple joined tables and case selects, each... stjulian	12-20-2004 06:14 PM stjulian	0	76
Searching Question Is it possible to search a database for certain text values? More specifically, I have a value that is in some table somewhere in a huge database... AGB	12-20-2004 05:44 PM Adam Machanic	1	48
help with aggregates I am unable to get what I want out of this query. I am looking for. It seems that I'm getting aggregates (average) from the whole view and not... DC Gringo	12-20-2004 05:18 PM DC Gringo	3	56
SQL Query I have two tables namely Student and Subject respectively Please find below the data for each table Subject --------- Physics Chemistry Biology Maths VBB	12-20-2004 04:34 PM viktor	4	50
SQL script generation dependencies Hi, I know a lot of people went throught this, but now it's my turn and I cannot find anything convinient enough for what we need. We are using... Maxime Plante [C.T. Consultants inc]	12-20-2004 04:27 PM mark baekdal	3	50
Sql order by question ( 1 2 ) Is it possible to set the starting row in an order by statement? For example, Select * from Accounts order by name where name like 'B%' The result... Andrew Pasetti	12-20-2004 03:55 PM Hugo Kornelis	10	97
2 tier vs 3 tier I am currently in the early stages of developing my 1st web app and have noticed some discussion about the advantages of a 2 tier approach as... Murphy	12-20-2004 03:38 PM Mike Epprecht \(SQL MVP\)	3	62
Changing to Fiscal Year As I see, the default values from the datepart function results in Calender Year Quarters/Months". Our business deals with Financial Year from July01... J. Joshi	12-20-2004 03:17 PM John Gilson	4	52
Attach db is readonly Hi Freinds, SQL 2000 I detached a db abd copied files to a new server. then trying to attach there. It attached readonly. when I tryo to convert to... Patrick	12-20-2004 03:09 PM Patrick	3	54
IS NULL not working in WHERE clause. ( 1 2 ) The following query returns rows where the time_id IS NOT NULL. This query seems to be breaking SQL Server(?) select bus_date, time_ordered,... Earl	12-20-2004 03:04 PM Steve Kass	17	84
Is this join possible? Ok, Heres a little bg info... I've got one table thats got phone number in this format: AreaCode \| Prefix \| Suffix -------------------------- xxx ... Weston Weems	12-20-2004 02:28 PM Max	2	55
Triggers Currentnly I have one trigger on a table in Database A that populates a table in Database B. The table in Database B also has a trigger that does... Miles Cousens II	12-20-2004 02:23 PM Miles Cousens II	2	61
Report slows down other applications Hello, I wrote a report in COBOL using embedded SQL. This report opens 5 insensitive cursors (to avoid locking) sometimes one within the other... Helen Stein	12-20-2004 02:18 PM Max	5	47
Security context used for DBPROP_MULTIPLECONNECTIONS sessions We had tried to open a second rowset while an existing rowset was open and had a problem (which is the subject of this message) which we solved by... Laszlo Szentendrei	12-20-2004 02:16 PM Laszlo Szentendrei	0	65
Security context used for DBPROP_MULTIPLECONNECTIONS sessions We had tried to open a second rowset while an existing rowset was open and had a problem (which is the subject of this message) which we solved by... Laszlo Szentendrei	12-20-2004 02:15 PM Laszlo Szentendrei	0	48
How to join two tables and only display the values on the first row? Hi all, I need to join two tables but the joined table must be displayed only in the first group's row... Table 1 FieldID Value1 Value2 ... Alfredo Becerril	12-20-2004 02:15 PM Alejandro Mesa	3	60
Updating SQL table from front-end Access I'm using Access as a front end to SQL. Our product ID (key field) in the Product Name table sometimes changes. I need all of the associated... SharonInGa	12-20-2004 02:14 PM Max	3	48

Page 1050 of 1545

1050

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off