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. all bookings are based on 30 minutes blocks. So far I managed to create ...more >>

Hi, Does anyone know if there's a way of renaming a foreign key? Or even name the foreign key on key creation? Thanks ...more >>

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)? Thanks ...more >>

what is the meaning? set ANSI_NULLS ON set QUOTED_IDENTIFIER ON and can i know the stored procedure create/modify date?...more >>

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. Sql Statement: (this statement is not allowed) Select AccountNo, RecordID, (Sele...more >>

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 Column or parameter #4: Cannot find data type test. However, I can cre...more >>

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 case ? in BOL its says about floa...more >>

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? Thanks in advance, Linn ...more >>

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 fields: id name manufacturer XML of CAD data (which can be loaded by m...more >>

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 opposed to the literal that runs in under 1 second. I checked the ex...more >>

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...more >>

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. Can anyone help me with appending text to a text field type and also p...more >>

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 character (@) the stored procedure will return no values. i think the @ alt...more >>

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 issues)? Obviously 'float' & 'real' are out of the question, but I...more >>

I have the following table that I want to update: COL1 COL2 ==== ==== 0 8 1 12 3 20 15 10 etc... For the first record, COL1 starts at 0. For each record thereafter, I need COL1 to increase by adding the value of COL2 from the previous record, plu...more >>

This issue came up in the MSDN Analysis Services Forum, so I was wondering if there's any workaround: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=380689&SiteID=1 When a Named Query is used in lieu of a table in an SSAS Data Source View (DSV), the generated SQL query apparently emb...more >>

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 or there is no record, I nee...more >>

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 if the data is nothing but ascii characters, I want to filter out. Here...more >>

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 the Last day of the quarter (Max day of the quarter) i...more >>

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 --------------- P...more >>

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....more >>

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. any suggestions? thanks....more >>

Hi. I could use some help troubleshooting an error in a stored procedure. The SP was developed some time ago and recently started thowing this error: Arithmetic overflow error converting numeric to data type numeric. This error doesn't seem to make much sense since it happens when inserti...more >>

Can anyone tell me what needs to be done so that the following code, which works successfully for SQL Server 2005 systems, will work with SQL Server 2000 systems. The documentation says that SMO works with SQL Server 2000 systems, but I haven't found any information about any components tha...more >>

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, without creating any tables.... like: -- all numbers in g2 that match with ...more >>

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 par...more >>

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 good c...more >>

Is there some Sp out there?...more >>

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 How can I 1. add commas between the columns values which are deri...more >>

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 unicode in that column? Thanks ...more >>

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 one master table. On the master table I have configured an Ins...more >>

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 ' ' WHEN <something> THEN 1 END as Field4 WHERE <something> GROUP BY Field1, Field2, Field3, Field4 T...more >>

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 this is a dumb question that requires a dumb answer ...more >>

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 from myTable where id = 1 That way, I don't have to run the same query twice. I'll then insert those two values in another table...more >>

Hi, I am quite new to SQL 2005. I've just loaded a file called .sp within the Management studio and I can't get it to connect to a database. If I change the file ext to .sql then no probs it works. I've tried to set an option in the options Window in Management Studio where you can add ...more >>

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"; User ID=Admin;Password=' )...[HoldOrderDetai...more >>

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 another database, or even another server. This way I'll ha...more >>

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. Any ideas? Thanks!! ...more >>

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 table a has a million rows? ...more >>

Hello all and thank you for your time. Table 1: Johnny BallTypeId= 1 Debbie BallTypeId= 2 Kurt BallTypeId=1 Table 2: 1 Baseballs 2 Footballs 3 Golf Balls Desired Output: Baseballs 2 Footballs 1 Golf Balls 0 NULL 23 SQL: select...more >>

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 my table but 'CONCAT' 3 columns and use those as the DropDownList Text ...more >>

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 SELECT Sum(Importe) As SumaDia FROM [Diario ...more >>

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 'c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NETFiles\s...more >>

Hi, I try this query: ---------------------- use AdventureWorks go select c.*,o.* from sales.salesorderheader o join sales.customer c on o.customerid=c.customerid go set statistics time on go -- try the query again select c.*,o.* from sales.salesorderheader o join sales.customer c on o.c...more >>

Hi everyone, Does anyone know if control-m environment is be able to get in touch with SSIS packages? Thanks in advance, ...more >>

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, SystemDataAccess = SystemDataAccessKind.Read)] public...more >>

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 EventTypeID - (int)PK. This is foreighn key from EventType table RegionID - ...more >>

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 <> ? this works fine, except that the value I'm co...more >>

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 statement...more >>

Dear all, I am looking for any way to launch SSIS packages through a job. How do I such thing? Something very alike when we ran Sql2k: DTSRun /~Z0xB2A214993E843 And at the same time be able to load them by Visual Basic: objdts.LoadFromSQLServer server, login, Password, , , , , strN...more >>

I have column with data: "A,B" ID column1 -------------- 1 A,B 2 B,C 3 A 4 D 5 B,C 6 C,D Now, I have variable: declare @test varchar(20) SET @test='A,B' Now, I would like to get all rows from table where any of letter in column1 ...more >>

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 - source and destination. If a record from the source table already exists in the destination ...more >>

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. How can I get count of all rows, something like: SELECT to...more >>

...more >>

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 ()-, only 011654123654, but when view we would like to view it as above...more >>

Folks, I have a table in SQL Server 2005 that contains a row of type "XML" (for now untyped - no schema behind it). I can easily query that table and retrieve values from the XML - way cool! I can also easily query that table and use the data paging mechanism based on the ROW_NUMBER() fun...more >>