I am getting the following error when trying to access a database with a trusted connection: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." My connection string is: "Server=MyServer; Database=MyCatalog; Trusted_Connection=True;" N...more >>

Hello all, Does anyone know the SQL statement for calculating surrounding suburbs, or can point me in the right direction? I have a database of Australian postal codes and their centroids in longitude and latitude, I'd like to pass it either the long/lat or postal code to calculate from. And ...more >>

Hi, If one uses a temporary table/ table variable within a stored procedure, will it use the compiled plan each time the stored procedure is executed or will it recompile for each execution? Thanks in advance, Thyagu ...more >>

Hi We have a SQL server 2000 SP4 on a windows 2003 2x3Ghz XEON 4 GB ram. We have a table looking like this with currently 6 rows. Total data is aprox 10 kb i all row all together. CREATE TABLE [dbo].[BIOMETRICPROFILE] ( [BIOMETRICPROFILEID] [bigint] IDENTITY (1, 1) NOT NULL , [FINGERPR...more >>

I am using sp_helpindex to get the indexes of the database....... how do i pass the parameter tablename as a parameter????....and is the parameter a built-in or userdefined??? I used @TableName....which throws a exception saying "@TableName is not a parameter of the database" Thanks a L...more >>

I have a database that contains a column for UnitName , BeginDate and EndDate. I want to pass two parameters (@BeginDate and @EndDate) and retrieve a table of values that include UnitName along with Counts for each UnitName. SELECT UnitName, COUNT(BeginDate) AS Start (SELECT COUNT(EndDa...more >>

Hi, I know some SQL but not enough to write the query i'm trying to create and could do with some help! I have 2 tables (Product and ProductProgram) that are linked by a common identified 'ProductID'. Each product has 5 different price levels (1,2,3,4,5) and these are stored in the Produ...more >>

I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the other will be a web application. I have MS Visual Studio 2005 (along with the developer's edition of MS SQL Server), but not MS Access. I also have ...more >>

Hi, it's possibile to define table fields for automatic Last_Update_Date and for Creation_date using column formula?? Thanks !!! ...more >>

Is SQL server defaults to case insensitive? I am sure there are ways to install case sensitive SQL server instance but coming from Sybase (which is always case sensitive) case insensitivity is something new to me (it requires coding change etc). Besides, is there any option I can set to turn on ...more >>

Hi how to conert (number) 200611 to string 'Nov 2006' ? thanks ...more >>

How to write an equivalent SQL like this (which works on Oracle): SELECT * FROM sometable WHERE rec_id, rec_sequence IN (SELECT rec_id, MAX( rec_sequence) FROM alppremh GROUP BY rec_id) thanks ...more >>

We have an Access database with Access front-end to Access back-end. Another company has installed a separate application using SQLServer. At present certain information in the first application is entered manually into the second. We wish to automate this process. The other company is propos...more >>

How do i find indexes of the columns of all the tables of the datbase...........most importantly in SQL server 2000 Thanks a lot ...more >>

I'm trying to figure out how to this do with TSQL and preferably through joins rather than by using cursors or temp tables. I have multiple time spans for multiple individuals that I would like to rollup together where they don't actually have a gap in coverage. ID StartDate ...more >>

Hi, We are have a 5 user licenced microsoft sql server 2000 cd. We need to set this up to run two instances of the server, as we need different setups on both databases. Does anyone know if with one cd you can do this, so that the user licences installed are shared between the two instances? ...more >>

The following seems to work in SQL Server 2005, but I'm getting the error 'Incorrect syntax near xml' when I run it in SQL Server 2000. select a.accountid , (select street, city, state, zip from account b where a.accountid =b.accountid for xml auto, elements) as xmldata from account a ...more >>

Using SQL Query Analyzer how do I do something like: WHERE columnName = 'this' AND anotherColumnName IS NOT NULL I.E. SELECT * FROM CES_DATA WHERE DIV = 'MW' AND Not IsNull RO ORDER BY RO ...more >>

I have a table in SQL, that I know how to connect to using ADO, but I need help on how to read records from that table. So on a form I have a listbox where I want to populate that and i have a textbox with a userid. Here is an example of the table: USER ID TYPE PAYMENT ===============...more >>

Hello. I'm having troubles with a query that (should) return all the records between two dates. The date field is a datetime type. The db is SQL Server 2000. When I try this SELECT RESERVES.RES_ID, PAYMENTS_RECEIVED.PYR_ID, PAYMENTS_RECEIVED.PYR_VALUE, PAYMENTS_RECEIVED.PYR_DATE, ...more >>

I am working with an old version of SQL Server (6.5), but the same mechanism may exist in later versions. If there were any changes made to the database schema, would this be recorded somewhere within the database? Would there be some way of determining if there had been any schema changes ...more >>

I have an excel sheet that contain colummns as in a table in a sql data base i want to transfer this data from the sheet to the table from business logic code layer not from the enterprise manager by wizard what can i do?? ...please urgent ...more >>

How do I insert a single quote ' into a table? For example: Insert mytable values (1,''') I get an error message. Any ideas? The server does not recognize double quote (why? is this tsql, ansi?), otherwise I could have written it as: Insert mytable values (1,"'") Thanks. ...more >>

I hope someone can help me out with my problem. I have found a sql statement that basically pulls all bills filed within a certain time period and the payments made on those bills with in the same time period. I group the payments by payment year and filed year which gives me a matrix with the...more >>

Hiiiiii I want a qry which will give me the list of views which are not used in any SPs in that database. like suppose i have a view view1 and I have used that view in one of my SPs and i have a view called . View2 its just created but never called in any SPs. Somebody ll help me ? ...more >>

hi. I am having probelms with an update statement. every time i run it, "every" row updates, not just the one(s) intended. so, here is what i have. i have tried this with both AND and OR and neither seem to work. i dont know why this is elluding me, but i'd appreciate help with the solut...more >>

G'day everyone That's a space between the ticks. It's all part of a longer script but seeing as the failure occurs on line 1 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[config] GO That'...more >>