I seem to find it very hard to grasp when i see something like these in the newsgroup... select .... from tableA join tableB on tableA.col1<=tableB.col1 Where can i get some good examples and explanation of that <= join condition .. I understand straighforward = pretty well but the < is a di...more >>

Hi, Any suggestions on creation of SQL Server Database Columns Cross Reference? Rao...more >>

Hi, Can anyone help me on this.. I have a table with a field - varchar(2000), eg Table CustMast with field Remarks varchar(2000). I can be able to store the data using sp properly, but when i select data from the table, it truncates the data and shows only upto 1000 char. the sp is simil...more >>

Correct or not? When I need SN_ID in @SN_ID and SN_Name in @SN_Name from the following statement: select SN_ID, SN_Name from Seniors I'm obligated to use a cursor (and use Fetch)? Or do the select 2 times. Are there any other (faster) ways? Thanks in advance, Stijn Verrept. ...more >>

has anyone used this extended stored procedure? tried executing it with: sp_addextendedproc 'srv_sendmsg', 'srv_sendmsg.dll' go declare @iret as int exec @iret = srv_sendmsg 7,SRV_MSG_INFO,6002,10,1,NULL,0,0,'test msg',SRV_NULLTERM but I get this error message: ODBC: Msg 0, Level ...more >>

I am attempting to construct a view that requires the equivalent of a CASE statement or an Access IIf type function. I realize that the IIf function is not available in SQL and that one would normally use the CASE statement instead. However a view does not recognize the CASE construct. ...more >>

I have three tables A, B and C. Table C has a Pkey "c" and two fKeys "a" and "b" (from PKey of Table A and B). If I want to build index(s) on Table C, what is the difference of the followings? 1. one index on "a" and one index on "b" 2. an index contains "a" and "b" 3. an index contains "a", ...more >>

Hi SQL Gurus, In Transaction Tables I always store > 1 Document Type. Document Type and Document Number as primary key CREATE TABLE TRHDR ( DocType CHAR(3) NOT NULL, DocNo INT Identity, DocDate DateTime ) ALTER TABLE TRHDR ADD CONSTRAINT TRHKEY1 PRIMARY KEY(DocType, DocNo) Inser...more >>

Hello, I have the following two tables. I'm trying to create a report which would look like this dbo.T1.ID, dbo.T1.C1, dbo.T1.C2, (then three more columns for T2) where dbo.T2.C1 = 1 or dbo.T1.ID, dbo.T1.C1, dbo.T1.C2, (then two more columns for T2) where dbo.T2.C1 = 2 Any help will ...more >>

I'm using the Client Network Utility and trying to create a TCPIP connection to an SQL server with no success. At present I have two machines on a local network, one running Server2000 and the one on which I am trying to connect just running Client Tools. In the Client Network Utility I can s...more >>

Has anyone figured out a way to use an extended stored procedure inside a UDF that uses Schemabinding? Thanks. Bob ...more >>

Hello someone can help me? I need the equivalent of MsAccess function LAST & FIRST under SQL SERVER. I must to write in SQL Server a query similar to this: SELECT LAST(MyField1) AS Field1 , FIRST(MyField2) AS Field2 FROM MyTable Thanks for your help in advance -------------------------...more >>

Hi SQL Gurus, I have a requirement by the system designer that many Columns must be made Case Sensitive, and I must make INDEX on those case sensitive columns. e.g : CustName & SalesName below. Will this Case Sensitive INDEX slow down the performance ?? compared to Case Insensitive Index ?...more >>

I would like to write a genric stored procedure to work on different tables with the same columns. How can I pass the table name to a stored procedure and use it? This attempt is not correct: CREATE PROCEDURE Test @TableName varchar(50) AS SELECT * FROM @TableName Is there any w...more >>

I have three tables A, B and C. Table C has a Pkey "c" and two fKeys "a" and "b" (from PKey of Table A and B). If I want to build index(s) on Table C, what is the difference of the followings? 1. one index on "a" and one index on "b" 2. an index contains "a" and "b" 3. an index contains "a", ...more >>

Hello, I am new to writing SQL Server Statements and have been trying the following line of code as I am familiar with other Databases: AND (NAME = "Dr. Jensen") I get the following error : 'Invalid Column Name 'Dr. Jensen''. Any help with what I am doing wrong is appreciated. Thank...more >>

If this is against newsgroup policy please let me know 8-(. I have need of help in producing 2 sections of code against a mssql db and am will to pay for the help. If someone has some spare time in exchange for cash please email me. Code Section 1, Export an Order/Detail xml document and HTTP...more >>

Hi Guys, one table in my sql server is locked by table lock when i checked sysprocesses table the blocking processes is running aSELECT query " select sum(value) from table A". do select query create any blocking? how i can avoid this?by including locking hints. Pls advice me biju ...more >>