Home All Groups Group Topic Archive Search About

SQL Server database programming

microsoft.public.sqlserver.programming
Score on similar tables
neilmcguigan - 5 May 2006 10:35 PM - 4 messages
hi all, so i have these tables: Company Job Resume user searches for a company, views that company. there is a list of "viewed" companies for that user. Users can attach/delete a (private to themselves) note about that company. ...
Score Handle Error
Jorge Aguilar - 5 May 2006 9:22 PM - 2 messages
Hi everybody, i do insert into client select * from client client table has pk when execute the query the follow error appear Servidor: mensaje 2627, nivel 14, estado 1, línea 2 Infracción de la restricción PRIMARY KEY 'PK__EMPLEADO__4924D839'. No se ...
Score Stored procedure with return value
Sandy - 5 May 2006 8:30 PM - 4 messages
Hello - The following code only returns 0.  What am I doing wrong?  I want a '1' returned to VB 6 if the row is inserted and if it not, because a duplicate record exists, I want a '0' returned to VB. ...
Score Cascade Delete
Derek Hart - 5 May 2006 6:28 PM - 8 messages
Is there a way to turn off cascade delete temporarily?  Yes, I want to leave orphan records in this instance.  I tried the following: ALTER TABLE tForm NOCHECK CONSTRAINT Delete From tform ...
Score Update Cursor with Sort
rmcompute - 5 May 2006 5:32 PM - 11 messages
I am in a situation where I need to use an update cursor but also have the file sorted.  The program won't run indicating that it is a read only cursor. Is there a way to get arround this ? ...
Score How to get row size
moondaddy - 5 May 2006 6:10 AM - 4 messages
using sql 2k, what's the fastest and easiest way to get the row size of a row.  I hava a number of rows I need to look at. Thanks. ...
Score Charindex to not include the delimeter question
needin4mation - 5 May 2006 2:23 AM - 3 messages
Hi, I have this: select left (mycategory, CHARINDEX( ':', mycategory) - 1) as Cat from allCats If I have a column that has no ':' colon in it I get an error about invalid string.  As long as there actually is a delimeter then all is ...
Score Insert Statement
Derek Hart - 4 May 2006 11:36 PM - 3 messages
I have an insert statement with 2 tables, such as: Insert tForm Select * From tForm2 I know that tForm has all the fields in tForm2, but tForm2 may have some additional fields not in tForm.  The insert statement will not work because ...
Score CLR Defined Types
Sean - 4 May 2006 11:36 PM - 2 messages
All read up and ready to create a database project only to find we dont have "database" as an option for a project type. Any clues why? we have SQL 2005 running as well as running SQL reporting services. Thanks ...
Score Distinct on only one column, return all columns
randy1200 - 4 May 2006 11:08 PM - 2 messages
I have a table with many columns. I want to return all columns, and I want only the first record for each distinct value in the salutation column. I come up with the following: select c1.* from complainer as c1 ...
Score Eliminate duplicates from only one column
randy1200 - 4 May 2006 11:00 PM - 2 messages
...
Score Files corrupt when retrieving BLOB data
Paul Pleasant - 4 May 2006 9:57 PM - 2 messages
I am attempting (for the last several days) to save binary files to a SQL Server 2005 database and then retrieve the files later. Have tried the new varbinary(max) and image data types and several different techniques with no ...
Score optimized name-address-zipcode-region design
hazz - 4 May 2006 8:23 PM - 3 messages
Whether thin-client with round-trip cycles to the db or a rich-client loading look-up data into memory on application startup, what is a solid optimized database design for customer location search functionality.  USPS zip data has about 75K records. ...
Score Getting Records not in both tables
Irvin McCoy - 4 May 2006 7:24 PM - 6 messages
I have 2 tables and I want to retrieve all record that are in table 1, but not in table 2. Here's my data. Table 1: EstEquipment Columns: EstEqpPK, EstimatePK, Description Table 2: CrewEquipment Columns: CrewEqpPK, EstEqpPK, quantity I need all records in EstEquipment with a certain EstimatePK that are not in ...
Score System.Data.Sql.SqlDataSourceEnumerator visible servers???
newscorrespondent - 4 May 2006 7:21 PM - 2 messages
System.Data.Sql.SqlDataSourceEnumerator is documented to return all visible SQL servers with several notes that it may not show all of them. Should this show all the servers that are shown in the SQL Server Manager connect dialog when I browse for servers? ...
Score Sql Code generation tools
helpful sql - 4 May 2006 7:07 PM - 12 messages
Hi all,     Are there any good Sql code generation tools out there in the market? If not can you please give me tips or sample code for creating one? I need to automate code generation for data integration. Here is what I ...
Score Active Directory, Terminated Employees
Pancho - 4 May 2006 6:22 PM - 3 messages
Hello, we have scheduled a nightly refresh into an Employees table in a database, that receives data from Active Directory.  AD is the "authority" of who is an active employee and frees us from manual maintenance of the Employees table in our DB.  However, we want to store information on ...
Score Date & Time formatting to sort by date and time.
Mike - 4 May 2006 6:01 PM - 7 messages
Hi, I have a Startdate and StartTime in my table, I would like to combine to the 2 columns as one column so that it can be sorted as date. startDate - smalldatetime startTime - nvarchar ( I cannot change this) my current query: ...
Score detecting Update Conflict
Tanweer - 4 May 2006 4:22 PM - 6 messages
When a user try to update the record I use timestamp field (upsize_ts) to figure out if data was modified by other user. However I found out @@DBTS may cause problem in Multi user senario and may not return correct Tiemstamp value as it is not the timestamp for the current ...
Score Returning long string in varchar using Coalesce()
Ashish - 4 May 2006 4:16 PM - 5 messages
Hi, I want to return a string of words separated by comma using coalesce() so that the client application can look for a specific word in this long string.Following is the script:- CREATE TABLE WordList ( WordId int IDENTITY, WordDesc varchar(100) ...
Score how to compare rows from oldtbl to curtbl using Like?
Rich - 4 May 2006 4:14 PM - 11 messages
oldtbl contains these CoNames 'abc' 'def' 'ghi' 'jkl' curtbl contains these CoNames 'abc inc' 'def inc' 'jkl inc' Note that curtbl does not contain 'ghi inc' I need to retrieve rows from oldtbl where CoName Like CoName in curtbl select CoName from oldTbl where CoName like '%' + curtbl.CoName + '%' ...
Score Using EXEC
Stephen K. Miyasato - 4 May 2006 4:08 PM - 5 messages
I'm a newbie still learning to use stored procedures. I have the following stored procedure @PatNo int, @Type int, @ABN int,  -- abnormal values only 0 false 1, true. @Range int AS DECLARE     @TempVS varchar(20), ...
Score Way to check logged in by week HELP!!!
KT - 4 May 2006 3:34 PM - 8 messages
In need of a way to check whether or not a person logged in every day within a week (week starts Monday through Sunday).  Does anyone know of a good way to accomplish this? In the table below, User #2 did log in each day within the week.  I would ...
Score Restrict certain characters in varchar column
hals_left - 4 May 2006 3:22 PM - 4 messages
Hi - Is it possible to restrict the domain of a varchar column to prevent certain chatracters being accepted. I want to prevent commas. Thanks ...
Score Cursor in stored procedure
Steph - 4 May 2006 3:15 PM - 2 messages
I'm trying to do something like that: CREATE PROCEDURE [dbo].[Test_Proc] (@SearchText1 nvarchar(10), @SearchText2 nvarchar(100), @SearchText3 nvarchar(100)) AS DECLARE @SQLString NVARCHAR(4000) DECLARE @SQLSelect NVARCHAR(3000) DECLARE @SQLWhere NVARCHAR(1000) SET @SQLSelect = 'SELECT  dbo.View_Clients.Client_id, ...
Score Getting Most Recent Date for Many IDs
mgabig - 4 May 2006 3:06 PM - 15 messages
Hello, Like the subject says, I'm trying to get the most recend End Date for multiple customer IDs in a table. The table, Rate, has multiple customer IDs and each ID may have multiple data in the endDate column. ...
Score Table Joins on more than one field
adi - 4 May 2006 3:04 PM - 3 messages
Hello all,     Can someone help me with this SQL? 1) EMPLOYEE table has columns 'employee_id' and 'emp_sid' and other columns 2) EMPLOYEE_BENEFITS table has a column called employee_entity, this column can be joined to either  'employee_id' OR 'emp_sid' but not both ...
Score Update Statement
marcmc - 4 May 2006 2:28 PM - 8 messages
If you run the followingDDL you will see my issue. CREATE TABLE FAt_bse_events_marc( dim_one_id int, dim_two_id int, ev_event_id int, ev_type_id tinyint, cur_trn_dt smalldatetime, f_ev_date smalldatetime, f_ev_count tinyint, f_ev_num1 float                                            ...
Score hello
m00nm0nkey - 4 May 2006 2:09 PM - 8 messages
i've been alone with you inside my mind, and in my dreams i've improved performance a thousand times, i sometimes see you in the server room, Hello.... can you query your tables? I can see it in your transactions, ...
Score Extrapolate the size of filegroups by 12, 24 ,and 36 months.
Naana via SQLMonster.com - 4 May 2006 1:57 PM - 3 messages
Hi All, I have a large Database with two filegroups and I'm trying to extraplate the size of the filegroups for 12,24,and 36 months. I don't have historic data, but have current data as of Feb, Mar, & Apr. The days of these months are not ...
Score T-SQL help
Sam C - 4 May 2006 1:43 PM - 8 messages
Hi, Please help me with this T-SQL. I have mentioned my requirement towards the end. Thanks in advance! --DDL & DML use pubs go create table U_empl ( emp_id int identity(1,1) primary key, emp_name varchar(50) ) go create table U_tbl ...
Score UHG... Dates in SQL
SteveInBeloit - 4 May 2006 1:36 PM - 6 messages
Hello, I am having trouble searching on dates in SQL.  I have a table that has a transaction date on it, type datetime. The user types in two dates, and the sql is supposed to return all transactions between those dates.  So I say  WHERE TranDate >= @FromDt AND ...
Score Problem using "AS" to add 2 numbers
friedman30 - 4 May 2006 1:18 PM - 4 messages
i need to add 2 results from a query  to get this string: 2.2006 (that represents the number of the week, and the year) i have a table that holds these 2 columns ("week" , "year") as integers (i can't change it to string) ...
Score UPDATETEXT with Transactional Replication
Yan - 4 May 2006 1:06 PM - 3 messages
Hi, The bellow Update works fine but does not replicate and this is because it is treated as a single transaction regardless the fact that an explicit transaction is being opened inside the cursor. I need each UPDATETEXT statment to be a single transaction, any idea? ...
Score compare 2 strings
henk - 4 May 2006 12:27 PM - 7 messages
i have a Company table . one of the column is EmailAdres. now i want to compare a string(a emaiadres) agains this column. the problem is that the string is different every time. e.g. search Parameter2.: <testu***@yahoo.com> ...
Score Multipart Identifier???
Phill - 4 May 2006 12:02 PM - 7 messages
I am getting an error: Multi-part identifier Ad.IPCode could not be bound.  What does that mean?  This is my query: SELECT Ad.ObjectID, ObjectTypeCode               FROM dbo.ClassifiedAd Ad, dbo.Objects O ...
Score @@servername returns NULL
Yan - 4 May 2006 11:53 AM - 5 messages
Hi, sql server 2000 sp3a select @@servername returns null  but select * from sysservers shows the correct servername. This causes problems to set up replication. Any idea how to resolve apart of reinstalling? Thanks Yan ...
Score What's wrong in my Select Statment
Islamegy® - 4 May 2006 11:45 AM - 11 messages
I'm try to run this procedure to implement Custom paging so i pass 2 paramters @PageIndex, @PageSize so if i @PageSize = 5 and PageIndex =2 (0 based index) then i want to ignore first 10 Rows right?? I wrote the following select statment: ...
Score What's wrong in my Select Statment
Islamegy® - 4 May 2006 11:45 AM - 4 messages
I'm try to run this procedure to implement Custom paging so i pass 2 paramters @PageIndex, @PageSize so if i @PageSize = 5 and PageIndex =2 (0 based index) then i want to ignore first 10 Rows right?? I wrote the following select statment: ...
Score Using a DB name as a variable
Simon - 4 May 2006 10:54 AM - 5 messages
I am scripting database views to allow us to easily build a new server. However I would like to be able to have a variable containing the DB name that allows me to script views that look at other databases. ...
Score How to write 'update' statement to update top "n" records using Sql server 2000?
ABC - 4 May 2006 10:44 AM - 10 messages
How to write 'update' statement to update top "n" records using Sql server 2000?  "n" is unknown and inputted by user. ...
Score Using max function
Roy Goldhammer - 4 May 2006 9:59 AM - 4 messages
Hello there I have table1 with Fld1, fld2, fld3. Fld1 is Identity and the unique primary key clustered. Fld2 and fld3 are indexed and don't unique. I need to build fast query that returns from table1 all the records with ...
Score How to make the database execute query faster PLEASE HELP
Fairy239 - 4 May 2006 9:52 AM - 25 messages
i got a very big problem help i need my database to execute one query in less than a min but it executes for 8 mins is there any way i can shorten the period of time execution? this is the codei am excuting some of the tables have 1-3gb big in size ...
Score Small exists problem
Lasse Edsvik - 4 May 2006 9:40 AM - 2 messages
Hello I'm trying to get this to work, i dont get the exists/join thing to work at all.... CREATE TABLE #Threads (   MsgID int,   RootMsgID int,   Foo char(1) ) CREATE TABLE #Test (   MsgID int,   UserID int ...
Score How to make the database execute query faster?
Fairy239 - 4 May 2006 9:34 AM - 2 messages
i got a very big problem help i need my database to execute one query in less than a min but it executes for 8 mins is there any way i can shorten the period of time execution? ...
Score Find in SPs option for SQL
Will - 4 May 2006 9:33 AM - 3 messages
Hi All, Just a quick question, is there any option to search in all stored procedures in a database for a particular string, without scripting out the whole lot? Thanks Will ...
Score Not able to open Query Analyser...
Shahul - 4 May 2006 8:58 AM - 5 messages
hi pals, Iam not able to open the Query Analyser in my machine. When I am clicking the QueryAnalyser, isqlw.exe is present in the Process Tab of  TaskManager, but it is not running in the Machine. Any idea? ...
Score Database mirroring
Craig HB - 4 May 2006 8:28 AM - 3 messages
I have a database that I want to split up so that I separate the transactional side from the reporting side. It seems that database mirroring (or something similiar) is what I should do. So I'll a have Transaction database that mirrors with a Reporting database. ...
Score Loading DLL in SQL 2005
Woo - 4 May 2006 8:05 AM - 2 messages
I am trying to register a dll in SQL 2005.  I am running the following: EXEC sys.sp_addextendedproc 'XP_FILE', 'XP_FILE.dll' After doing this the extended stored procedure appears in the master database but I cant use it.  I then ran this, as per the Books online: ...
Score booking db design help
sammy - 4 May 2006 4:52 AM - 4 messages
Hey Guys, I am trying to create a web app that uses an SQL db to handle employee scheduling. I can design a table to hold the appointments with no problems but I need to be able to search for free time for the employees. ...
Score Renaming Foreign Key
Anchi - 4 May 2006 4:40 AM - 5 messages
Hi, Does anyone know if there's a way of renaming a foreign key? Or even name the foreign key on key creation? Thanks ...
Score DBCC CHECKDB
nate.vu - 4 May 2006 4:27 AM - 3 messages
Hi, Just got a question about the way DBCC CHECKDB works.... When I run a DBCC CHECKDB statement against a database, are all the pages for that database read from the disk (i.e. if there are pages for the database in the buffer cache then these are not used)? ...
Score question
joe - 4 May 2006 1:43 AM - 3 messages
what is the meaning? set ANSI_NULLS ON set QUOTED_IDENTIFIER ON and can i know the stored procedure create/modify date? ...
Score Multiple Records Subquery..
den 2005 - 4 May 2006 1:21 AM - 9 messages
Hi everybody,    I like to display the records for AccountNo = 221 from table records shown below, how would I do this? I am display this results in a crystal report. What is sql statement to do this? Thanks. ...
Score User Defined DataType
Lianne Kwock - 4 May 2006 12:52 AM - 4 messages
Hello, I received the following error when I was trying to use one of User Defined DataType in creating a table on remote database server. The error message is as follow: Server: Msg 2715, Level 16, State 7, Line 1 ...
Score Using SQL Server and C# to make simple version control system
bob_jeffcoat - 3 May 2006 11:33 PM - 2 messages
Hello, I make a CAD program and I'm planning on creating a simple product database to control the versions of my customers CAD files.  The database will only have a couple of tables, the main one having these ...
Score WHERE performance issue
Brandon Lunt - 3 May 2006 11:18 PM - 8 messages
I saw two previous posts on this topic with no answers.  I run identical queries, one using a literal value, the other using a variable.  The query that runs using a variable in the WHERE clause takes 30-40 seconds to run as ...
Score Differences in error handling between 2000 & 2005
Nick - 3 May 2006 11:01 PM - 2 messages
The following code is executed within a stored procedure, written for SQL Server 2000: SET @BI = "BULK INSERT "  + @TableName2 + " FROM '" + @path + "\"+ @TableName1 + "' WITH ( FORMATFILE = '"+@formatPath + "\"+ @TableName + ".fmt' , MAXERRORS=0, BATCHSIZE=500000,CHECK_CONSTRAINTS, ERRORFILE='"+@formatPath+"\"+@TableName + ".bad')" EXEC (@BI) SELECT @err = @@error ...
Score Appending text to a text field type
wnfisba - 3 May 2006 10:05 PM - 2 messages
I have the following code which properly appends text to exisiting text, but I also need a carriage control line feed so that the appended text will appear all the way to the left when we view it through the application. ...
Score Email address in stored Procedure parameters
Pantano Antonio - 3 May 2006 9:59 PM - 4 messages
Hi, i'm writing a simple sp that check if an email address already exist in an AddressBook table. This sp expect a parameters called @Address. When i call this sp and pass to it an email address which contains an at ...
Score Accessing data in a different database?
Linn Kubler - 3 May 2006 9:38 PM - 4 messages
Hi, I'm using SQL Server 2000 and I would like to make a view in one database that returns data from a second database on the same server/instance of SQL Server.  Is this possible?  If so, how? ...
Score Update field based on previous record (incremental)
curtmorrisonemail - 3 May 2006 9:12 PM - 3 messages
I have the following table that I want to update: COL1    COL2 ====    ==== 0          8 1          12 ...
Score Can CTE be used inside a FROM subquery?
Deepak Puri - 3 May 2006 9:12 PM - 4 messages
This issue came up in the MSDN Analysis Services Forum, so I was wondering if there's any workaround: [link] When a Named Query is used in lieu of a table in an SSAS Data Source ...
Score Newbie - Query with loop?
kat - 3 May 2006 9:12 PM - 7 messages
Howdy, I am relatively new to Transact SQL and need some help on what should be a simple query... I have a table with * Item * Cost * MonthEndingDate (e.g. 1/31/2006, 2/28/2006) I need a query to return the Cost for a given month, but if the cost is null ...
Score Date question, Can I get Q1, of 2006 begin and end dates?
TallMike - 3 May 2006 8:36 PM - 5 messages
I would like to get the first and last day of a quarter by passing in todays date.  I can get the quarter were in with select (DATEPART(Quarter,GetDate())) Now I want to get the day the quarter started  (Min day of the quarter) and ...
Score Need to do the following...any suggestions?
Ben - 3 May 2006 7:30 PM - 4 messages
i need to be able to run the following code SELECT NULL, 'N/A', 0 UNION EXEC spListSubgroupsByGroupID @param Basically, I need to add an additonal row to the results that enters a null value.  I cannot change the spListSubgroupsByGroupID stored procedure. ...
Score Simple but useful technique - is it possible?
Uday - 3 May 2006 6:52 PM - 6 messages
Lets say, I have two groups of numbers (1,2,3,4,5...) and (1,8,3,6,1,4,...) [doesnt matter what the numbers are, as long as they are numbers] If I want to get a list of matching/non-matching numbers using a query, ...
Score Update Conflict
Tanweer - 3 May 2006 6:02 PM - 3 messages
Appreciate if you guys can resolve my issues I am trying to write a store procedure that can handle Update Conflict Senario to be handled --Row was deleted --Row was modified by other user --Row is locked What is the best way to do it in Stored Procedure also is Timestamp field is ...
Score How can I print column name only from table?
coke - 3 May 2006 5:55 PM - 3 messages
Is there some Sp out there? ...
Score Let me rephrease the question.
Justin - 3 May 2006 5:43 PM - 3 messages
I hope I can better explain. I have a column that stores unicode (nvarchar).  I am well aware that unicode equivalent for ascii characters. Now if the data does contain non-asii characters, I want to retreive it and ...
Score Multiple WHERE replacement???
Vito D - 3 May 2006 5:28 PM - 3 messages
Hello, I have a table relationship that connects a list of Amenities provided by each Property, such as: Properties --------------- PropertyID int PropertyName nvarchar(100) Amenities --------------- AmenityID int AmenityName nvarchar(50) PropertyAmenities --------------- PropertyID int, AmenityID int I want to be able to pull a list of Properties that have a certiain ...
Score Select List question.
hazz - 3 May 2006 5:26 PM - 6 messages
I would like the 'select list' in a select statement to be generated as follows; Query A  -  select  (output from Query B)  from sometable. Query B  -  select Column_Name  from ColumnsToSelect where Include_in_Report = 1 ...
Score Fill in missing date ranges
Terri - 3 May 2006 5:12 PM - 5 messages
I have a table AssetValues that contains several rows of data for a particular date. The table has missing dates and I need to populate these missing dates one-time to create historical data and then daily to populate missing data on an ongoing basis. The missing dates are not related to the ...
Score BCP with Windows authentication?
Rick Charnes - 3 May 2006 4:44 PM - 3 messages
We've been using BCP.EXE for ages, but are now connecting to our databases via Windows authentication rather than SQL ID's.  How can I get BCP to connect via Windows authentication?  Thanks. ...
Score Group by and Case Statements
Red2 - 3 May 2006 4:25 PM - 5 messages
Hi,    I have a query where I am using a case statement and a group by e.g.    Select Field1, Field2, Field3, Max(Field4),      CASE          WHEN <something> THEN ' ' ...
Score Using EXEC in a WHERE clause of a SELECT statement
agschwantes - 3 May 2006 4:17 PM - 5 messages
Is it possible to do something like: Select field1 from table1 where [ID] = (exec sp1 '1234567') I've never seen the exec used in this fashion and I've tried to find a direct answer to the question, thanks for any info and I apologize if ...
Score Returning two values from Case statement
VMI - 3 May 2006 4:09 PM - 3 messages
I want to write a query that looks something like this. I get an error running this: select id_1 =     case [ID]         WHEN 1 then 'test' , 'test2'  -- error     end ...
Score Opendatasource
bhorwitz - 3 May 2006 3:34 PM - 3 messages
I was able to use the following select qry with an OpenDataSource, but I recieve and error when I change it to an Update qry. SELECT   * FROM  OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="\\Posiden\apps\Access\MsData\holdbk.mdb"; ...
Score Float vs Decimal
Bassam - 3 May 2006 2:51 PM - 14 messages
Hello, sorry if this question is silly I'm confused about difference between Decimal and Float data types , if im writing accounting application and use 10:4 as precision/scale in all numbers , does it matters if i choose fields as Decimal or Float in that ...
Score Archive Strategy
Craig HB - 3 May 2006 2:27 PM - 4 messages
In our Inventory Control database we have tables that grow and grow and grow as the database gets used. Tables like StockResults, Deliveries, StockCount etc. I want to archive the data into archive tables, which I can later moved to ...
Score Line item query
CJEN - 3 May 2006 2:12 PM - 7 messages
I have a query that I am trying to write that will get demographic information from one table and then get journal entries from another table.  However, I want all the journal entries to be concatenated together so in the end I only have one record for each person. ...
Score Which data types for currency?
Alex Clark - 3 May 2006 1:47 PM - 5 messages
Hi, I know to many of you this will sound like a daft question, but what are the best data types for storing currency values (assuming I'm going to be performing arithmetic operations on them and don't want crazy rounding ...
Score How would I filter?
Justin - 3 May 2006 1:35 PM - 5 messages
I have a column that uses nvarchar(50). Of course it contains both unicode and standard ascii character. Now if the data contains unicode, I want to see it in.  Can you do this with single select statement?  How would I filter out rows that does not contain ...
Score Using a trigger for Veritical Partitioning with a calculated table name...
William Holmes - 3 May 2006 1:34 PM - 14 messages
Hello, I have an application that requires table partitioning. I have no control over the query that is sent to the SQL server. I want to send the data to individual tables depending on the day of the month. What I have setup is ...
Score user defined function question?
nick - 3 May 2006 1:33 PM - 8 messages
for example: create function f(c int, ...) returns table @ret (....) as begin ..... set @v = select max(m) from B .... return end select * from a cross apply f(a.c, ...) Will the SQL statement "select max(m) from B" be executed 1000000 times if ...
Score How do I get count to issue a 0???
sunshinevaldes - 3 May 2006 1:17 PM - 7 messages
Hello all and thank you for your time. Table 1: Johnny     BallTypeId= 1 Debbie     BallTypeId= 2 Kurt         BallTypeId=1 Table 2: 1     Baseballs ...
Score PIcture values for a column
Robert Bravery - 3 May 2006 1:16 PM - 3 messages
HI all, Is there any way to represent picture values for a column. SO that when viewing the data is presented slightly diferently than stored. Phone numbers for example might be (011)654-123654. But we would'nt wnat to store ()-, ...
Score Small Stored Procedure Help
manmit.walia - 3 May 2006 12:26 PM - 4 messages
Hello All, I am stuck on a particular Stored Procedure. Basically I am trying to fill a asp.net dropdownlist from a DataSet. The DataSet is being filled from my Stored Procedure. What I want to do is retrieve 4 columns from ...
Score Query Performance
Leila - 3 May 2006 12:02 PM - 5 messages
Hi, I have one query for two groups of tables(3 tables). These two groups of tables have the same data and schema but second group has been partitioned based on OrderDate Column. By setting "Statistics IO On" I see very less IO ...
Score a query that doesnt work
Bardanca - 3 May 2006 11:24 AM - 4 messages
Hi, im programming to a Database over Access2000, and i had done this query: SELECT Sum(Importe) As SumaDia FROM [Diario Caja] WHERE Fecha between #03/05/2006 10:57:45# and  #03/05/2006 12:57:45# the answer is null, but if i use a query like that ...
Score CS1595: 'Sanghi.Global' is defined in multiple
Mahesh - 3 May 2006 10:47 AM - 2 messages
hi when i try to run my c#.net web application i m getting following error if any one know the solution pls let me know Compiler Error Message: *CS1595: 'Sanghi.Global' is defined in multiple places; using definition from ...
Score control-m and sql25k
Enric - 3 May 2006 9:44 AM - 2 messages
Hi everyone, Does anyone know if control-m environment is be able to get in touch with SSIS packages? Thanks in advance, ...
Score CRL return table function using dataadapter
Alphonse - 3 May 2006 9:37 AM - 4 messages
Hi, can we use dataadapter in CLR TVF? I try this code, but it failed with errors in sql when exec the  function [Microsoft.SqlServer.Server.SqlFunction        (FillRowMethodName = "Fill",        DataAccess = DataAccessKind.None, ...
Score Insert or update depending on existence of record
Denise - 3 May 2006 9:31 AM - 5 messages
Hello I'm using SQL Server 2000, Windows 2000. I'm writing a SP to check for the existence of records in a table, and to insert or update based on this existence.  In other words, I have 2 tables ...
Score Inserting data
Macca - 3 May 2006 9:30 AM - 2 messages
Hi, I have a table, Alert, that is made up of three entries as shown belowwhich come from other tables. Table Alert ------------- RoomID            -  (int)PK. This a foreign key from room table  ...
Score T-SQL- comparing NULLs
champ.supernova - 3 May 2006 9:25 AM - 13 messages
hope this is the correct forum for this question, guys. I'm using the following statement in a DDQ query to compare two values (asterisks obviously are normally 'real' values)- SELECT ID FROM tblEmployees WHERE NINumber = **** AND TitleRefno <> ? ...
Score How to loop through a recordset in an SP
Mark - 3 May 2006 9:19 AM - 10 messages
Hi - could anyone please give me guidance, samples, for how to write a stored procedure, which will run a select statement, to get all records where a reminder date (remdate field) is today, and send an email to the (usr_email) account from the selected records?  I can write the select ...
Score Count and top
simonZ - 3 May 2006 8:42 AM - 5 messages
I have complicated select statement which returns a lot of rows. I would like to show only top 50 rows on client, but also notice the client with the number of all rows of his search statement, like Showing top 50 of 1000 rows. ...
Score String comparison
simonZ - 3 May 2006 8:28 AM - 6 messages
I have column with data: "A,B" ID    column1 -------------- 1        A,B 2        B,C 3          A ...
Score (a,b) not in ( select c,d from ... ) , is it possible ?
Hasan O. - 3 May 2006 7:56 AM - 4 messages
...
Combining XQuery and data paging in SQL Server 2005
SSIS and DTS
Query Problem
Problem with Group by and having using alias
How to loop through each row in table?
Joining multiple tables
ALTER SP if exists in all databases
deleting hyphens in a phone field
Strangest thing in my life (well, almost)
Is my beloved TSEQUAL() officially dead in 2005?
Foreign Key Question
max memory for SSIS?
rundll
create secondary for getting property set extention failed
Poor query performance with: set statistics time on (SQL2K5)
Helpful suggestions...
carriage return in a text field
grouping and ordering in OUTER JOIN
T-SQL
Combining two rows into one
Table Partitioning (SQL Server 2005)
Bulk Insert not importing all records
What is non-deterministic or imprecise in this code
NOT LIKE '%' difference on SQL 2000 and 2005
Question about design practice - Address table
Optional Query with in a Query
Need help with Complicated Sort-by-value-groups-if-... confused.
Help with combining two queries
Help with counting query
Transform column headings to a character variable
I really need help with this one.
Bad Practice: Calling Views From w/in Stored Procs
prob w cursor for checking nulls in a table
Help with datetime field
Sorting efficiency
Function with local parameters
Insert Table Lock - Various connections inserting into one table
table lock on insert (multiple inserts at one time)
Cursors only fetching about 200 records?
need a simple query
Erroneous EOF's from Simple Queries
Can I use SqlBulkCopy to copy from a non-SQL Server database TO a SQL Server database? (VB.NET 2005)
Query over name/value table
selecting from more than one table
Searching on unicode characters
Indexes On Filegroups
IS THIS GOOD DESIGN?
Help with date query
High CPU utilization after SQL Server reboot.
Sql server to oracle conversion
Data Imprort scripts
Database Snapshots question
other possibilities than cursor
Error: 1203
Treating Null value as 0
2005 Directory Tree
how to set multiple local variable from single select statement
Finding displaying and deleteing dulpicate records
Returning Date Formats in Stored Procedures?
TSQL ELSE IF
How do I design for categories, subcategories, subsubcategories and so on?
Data translation
Help! Processing Hard Coded vs. Stored Procedure
Display multiple rows as one record
debugger
Text change management
CAN'T FULLY UNINSTALL SQL SERVER 2005 STANDARD
SQL help please
Sorting Numeric Strings
Query Optimization NOT IN vs LEFT JOIN
DECIMAL datatype
too many connections with .NET
Alter table - add default value
How to read the content of a flat file in Stored procedure
write conflict problem with InsteadOf Update Trigger
update qry
Select the users in a database
listing columns in view and stored procedures
Viewing table variables when debugging
Stored procedure
HELP! - SQL Mail
Do i need primary key?
Delete Data from a Column
ExecuteNonQuery in SQL 2005
too many connections with .NET
TSQL Error
Converting to crosstab table
Scalar Functions Re-Revisited - Doesn't Concantenate
Is there anything similar in TSQL to oracle code "SEQUENCE.NEXTVAL
Order by question, pls help
Help with query! Ranking of Sum() column
Getting size of table
BCP : Format File : Second Question
BCP : Format File : Export Table
Running the Genereate sql script by code
looking value in table
US-CA-LOS ANGELES SQL Server DBA/Developer
UNICODE question
Best Practices - SQL Transactions
SQL Server 2005: error: 26 - Error Locating Server/Instance Specified
Splitting a String
How do I make a field automatically get its values from another fi
Calculating Hours, Mins over 24 hour periods
how to prevent 2 users from running the same front end process at the same time
COPY to a .txt file
how to ALTER COLUMN ?
bug in string processing if the GO keyword is inside the string
sqlite current_timestamp
Next » 2 3 4 5 6 7 8 9 10