Using MS SQL Server

Unique Selections In Back End
I am using SQL 7 with an MS Access 2000 MDB front end, using bound forms with ODBC linked tables. In one form, the user needs to be able to check a box to select one or more records. This is accomplished with a local table containing two fields: the primary key value of the SQL table and a boolean field used fo... 20 Oct 2005 03:31

SCOPE_INDENTITY() Not Returning
Dear All, My newly insert GUID is not return from a store procedure. I turned this around and around and can't understand why. The records are inserted but no GUID is returned. I use (newid()) in the table to generate a GUID **************Store Procedure *********************** CREATE PROCEDURE heasvase.[... 14 Sep 2005 06:51

inner joins
Greetings, I like to write my inner joins as below, but someone at work tells me its not as 'performant' as using the 'inner join' statement. Is this true ? Is there a better way to write it ? thanks Mike SELECT count(*) FROM resources a, assignments b, timesheets c, timesheetpayrollitems d WHERE a.... 10 Sep 2005 12:23

Crosstab Query
I have two tables Bill and Location. Bill ( location_id int, prod_period datetime, consumption float, demand float ) Location ( location_id int, location_name varchar(45) ) I want to create a stored procedure that takes a parameter of @year. I basically want the procedure to return results... 7 Sep 2005 07:13

Bulk Insert
Sorry for the piece-by-piece nature of this post, I moved it from a dormant group to this one and it was 3 separate posts in the other group. Anyway... I'm trying to bulk insert a text file of 10 columns into a table with 12. How can I specify which columns to insert to? I think format files are what I'm suppo... 28 Jun 2005 11:23

Problem with Parallel Query Execution
I have a SQL 7 db with a union query (view), and I'm getting the error, "The query processor could not start the necessary thread resources for parallel query execution." This union query has been in place for about two years now with no problems until just now, though I haven't changed anything. Also, I have a... 14 Feb 2005 19:18

Using SQL Server (T-SQL) to parse text
In MS Access 2000 if I have a String such as: Column1 Delta CC: 123 Charley CC: 234 Foxtrot CC: 890 and I wanted to extact just the numbers in to a field called CC I could use this formula in a calculated field: CC: Mid([Column1],Instr(1,[Column1],"CC")+3,50) resulting in: CC 123 234 890 An... 14 Feb 2005 19:18

List of Logins
I want to retrieve the list of all logins in the sql server. can anyone help me in that? ... 14 Feb 2005 19:18

How do you improve SQL performance over large amount of data?
Hi, I am using SQL 2000 and has a table that contains more than 2 million rows of data (and growing). Right now, I have encountered 2 problems: 1) Sometimes, when I try to query against this table, I would get sql command time out. Hence, I did more testing with Query Analyser and to find out that the same que... 14 Feb 2005 19:18

Executing a DTS Package using an ASP (VBScript)
I'm looking for an example of how to execute an existing DTS­ package from an ASP (VB)script and would appreciate any and all response. ­I don't even know if it's possible Thanks - Chuck Gatto Dan Guzman Apr 27 2000, 12:00 am show options Newsgroups: comp.databases.ms-sqlserver From: "Dan Guzma... 14 Feb 2005 19:18