I am looking at joins and was curious about why this is happening. I have 2 RIGHT Joins but only the last one seems to be happening. If I have the following: SELECT e.EmployeeID,e.EmployeeName,Department.DepartmentName,o.Name,s.Name FROM Employee e LEFT JOIN Department ON e.DepartmentID =...more >>

Hello - I have a table as follows: tblLoans LoanID PK DateEntered FileNumber LoanType etc. And another as follows: tblBorrowers BorrowerID PK BorrowerLast BorrowerFirst etc. LoanID FK These tables have a one to many relationship with tb...more >>

can you use something like ? declare @column varchar(75) select @column=('column1') select * from table where @column='mytestdata' I understand you can do it dynamicaly by building a sql query but was just wondering if this way can be used cheers mark ...more >>

Here is what i have ( just an overview ) Table: CREATE TABLE [dbo].[EmpHis]( [cid] [int] NOT NULL, [qhiscomp1] [varchar](50) NULL, [qhiscompc1] [varchar](50) NULL, [qhisrespon1] [varchar](255) NULL Procedure: ALTER PROCEDURE [dbo].[emp_insert_his] @cssn varchar(9), @qhiscomp1 ...more >>

I hope someone can explain this to me, as I am stumped. I am not a SQL Server master by any means, so I hope this is a simple fix. We are using SQL2005 Enterprise, Win 2003 server and the server is only running this database. The client app is a VB.Net 2005 using SQLClient for db interface. ...more >>

SQL Server Express allows you to "attach" directly to a database file using the AttachDBFilename property in the connection builder. When the file is connected, it can be seen in the Server Management Studio like the following: C:\myfolder\mydatabase.mdf Here's my challenge. We query m...more >>

Hi, I am converting from Access to SQL Server. I have the following where clause which worked fine in Access but does not work in SQL Server. I identified the statement ((Customer.IsActive)=-1) as being the problem. If I remove this I get results which includes records where the IsActive f...more >>

Hello, I am moving my database from Access to SQL Server. I have a query which is listed below. The date restrictor worked in Access but is not working in SQL server. It returns zero results for no error message. When I remove the date restrictor I get results. It ran fine in Access as...more >>

Hello Everyone, I have a quick question. If I have a job that defrags Clustered indexes on a nightly basis, does it help with non-clustered indexes at all? I am getting conflicting information regarding this. Some say, no, non-clustered index will remain in previous condition (fragmented if...more >>

I need help with next problem: Exist table my_rows with next columns: id - int identity name - varchar is_locked - bit I need create store procedure which will return every time diferent row for every request from different processes. the pseudo code for the procedure : 1 select statem...more >>

hi, i have the following query: CREATE TABLE #Prod ( filtItemID varchar(30), sortIndex int default 0 ) insert into #prod select 'abc123' it doesn't work. how can i get this to work without specifying the sortIndex field in the insert statement?...more >>

When attempting to get a distinct value is there a difference in performace between using DISTINCT or GROUP BY? I have looked at the execution plan for using DISTINCT OR GROUP BY in the below statements and they are identical. Am I missing something? USE [AdventureWorks] SELECT DI...more >>

Hi. I have a select that includes: "Select ... Cast( Cast( MyDate as Char(8)) as dateTime) , ..." where MyDate is a char(8) YYYYMMDD thing. The data, which I don't control, has values for MyDate that don't convert, and I get "Syntax error converting datetime from character string." ...more >>

Hello, I created a stored procedure using dynamic SQL to find records in different Tables. A part of the procedure is created by the Code of my Application and sent to the procedure as a parameter. This is the string given to the parameter: ' WHERE dbo.tbl_Kd.txtKdBGNr = N'MyValue''. The Prob...more >>

what is wrong in the following query I get the error 'Incorrect syntax near t2'. select t1.c1, (t1.c2 * t2.c2) as Estimate from table1 t1 inner join ( select it2.c1, it2.c2 from innertable2 it2 ) as table2 t2 on t1.c1= t2.c1 Thanks, Chary. ...more >>

I have Windows Vista Home Premium 32-Bit OS. I want to learn Sql Server programming. So am trying to download the trial version from the Microsoft website. What version is right for me.Is it 180-day trial of Developer edition or Express edition(Free) . What is this Express Edition about? DO i ...more >>

I run the following query in Query Analyzer while using Terminal Services (Application Server Mode) on a Windows 2003, SQL 2000 SP4 box: BACKUP DATABASE [MyTestDB] TO DISK = N'E:\Backup\TEST.bak' WITH INIT, STATS=10 I receive the following error: 10 percent backed up. [Microsoft][ODB...more >>

This query tells me how many digits to the left and to the right of the decimal point for each value: ----------------------------------------------------------- SELECT MyField, 'Ldigits' = case when charindex('.',MyField) > 0 then charindex('.',MyField) - 1 else len(MyField) end, 'Rdigi...more >>

Hello, I have a table with 5 columns [C_STYLE_STRINGS] field type msg nvarchar(50) var1 nvarchar(50) var2 nvarchar(50) var3 nvarchar(50) var4 nvarchar(50) Typically, the msg field has content with c style escape sequences with var args that match as in the follo...more >>

CREATE TABLE #tmpA (intID int, RecordID int, UniqueID varchar(50)) INSERT INTO #tmpA SELECT all 1, 31589, 'CSW1-11042004A31589' UNION SELECT ALL 2, 40876, 'CSW1-11172004A40876' UNION SELECT ALL 3, 40876, 'FreeCSAR/AR05' UNION SELECT ALL 4, 40876, '' UNION SELECT ALL 5, 45308, '' UNION SELEC...more >>

Current data model is full of this, and I don't like it, but I'm not entirely certain if it qualifies as 3NF or not. Or 2NF, or 1NF. create table person ( goodPK varchar(32) PRIMARY KEY,-- whatever, not the issue height int, weight int, height_or_weight_flag char(1) -- either...more >>

Hi SQL team, I am using Enterprise Manager (SQL2000) to check the users and the permission in every databases. I am also checking for the server roles like SA and who is in the server roles. Then I write everything on a report. My problem is that I have lots of databases and too many users s...more >>

Has anyone successfully implemented SQL endpoints using a port other than 80. I can't seem to get this to work. I can successfully create the end point, but when I try to add a web reference from within Visual Studio, I can never locate the wsdl URL. I have tried the following: http://...more >>

For example, I have a "People" table which has a column "Age". I need the result like this: Group, Count <10, 122 <5, 233 <40, 232 20 to 30, 234 >25, 2342 The key is the group criteria may create overlap subsets....more >>

Deleting undo file in a restore In my STANDBY routine when I run my SP the last line that worked Ok is : alter database DBTAL set SINGLE_USER with ROLLBACK IMMEDIATE After this, the next line below don´t works : restore log DBTAL from disk = \\smfw2k3desv01\d$\StandBy\DBTAL\b0921162.b...more >>

Hi, we had a production error this morning and the error says "Out of Disk Space XXX.LDF" (I exactly don't remember the error message). So to fix that we created a new XXX_New.LDF file and pointed it to D:/ drive on the same machine. This solved our problem and we are not getting this error...more >>

The following statement causes the server to time out. When not using "Group By" and not summing the cost field the same query takes about 3 secs. The database is about 600MB in size. Am I using the sum function incorrectly? As I didn't thing simply summing the results would cause such a pr...more >>

Hello, Can a SELECT return records and give that table a name? So instead of, in my C# code, the tables in the dataset get an index (0,1,2, ...) will get a name (TableA, TableB, ...) Thanks, Miguel ...more >>

Hello, I created a database, added several tables and defined a primary key for each (as an auto incremented counter, starting with 1). I installed this database for my cleint, but discovered that the primary keys for those new tables where not added(even if the columns were correctly cre...more >>

Hi there, My quert is as follows: I've created a website with an app pool that uses a network service account to hit the server. On the database that the website accesses, I need to be able to grant access to certain tables, like this: 1) UPDATE / INSERT / SELECT / DELETE access on Gifts ...more >>

Hi I'm trying to convert an SQL Query from Access to SQL Server. The Access Query goes like this: SELECT Format(EntryDate, 'ddd mm dd') AS [Day] FROM JournalEntries This query returns the name of the day followed by month and date (Su aug 21) What would this be like in SQL Server ? Wh...more >>

I have implemented the Transactional Replication on SQL Server 2005. right now the issue is my transactions are not replicated over subscriber. I have reinitialized the subscriber but the issue is same. gives me error : No active subscriptions were found. The publication must have active su...more >>

Hello, I am running a SQL Server 2003 on my PC, with a database nammed myBase. I'd like to compare it to another version of the same base, which seems to be out of date. I have a backup of this other version. I tried to restore the backup, but I got a message from SQL Server telling that...more >>

i have the following sql select statement: select col1, (max(col2) - min(col2)) from table1 (nolock) where TransDate> '2007-09-22 07:59:59.999' and TransDate < '2007-09-22 09:00:00.000' group by col1 This will run fine, however, I need to be able to add all the values in col2 and display t...more >>

Hi, I'm working on apps which records some data in simple table : CREATE TABLE [TABLE_A] ( T smallint NOT NULL, UID uniqueidentifier NOT NULL, C1 varchar(50) NULL, C2 varchar(50) NULL, C3 varchar(50) NULL, C4 varchar(5...more >>

Can I set the properties of a column to have a default value of 0 and not allow the number to be less than 0 in SQL 2005? Think inventory items. Thanks, ...more >>

Hello there I've heared that the using of Stadard or enterprise edition on sql server 2005 is also depend on the hardware type: Some of servers provide hardware which is compatible to sql server enterprise edition only. Is it true? and if so does microsoft have offical documentation abo...more >>

Dear All, I have uploaded one large file (Containing 2 Fields - SymbolCode and SymbolName) using bulk copy that contains 1 million records into a temp table (Say SymbolTemp). The SymbolCode is unique in this file. Now I need to insert records to the actual Symbol table validating uniquen...more >>

Hi i wrote a bat file that extract some data from tables (using bcp) and ftp these data to another pc, if i run this file from console it runs correctly, if i try to run it using mssql it returns me errors: NULL C:\WINNT\system32>echo off A subdirectory or file 22 already exists. > Perfl...more >>

Thanks! ...more >>