Programming SQL

' – ' what is this ?
i have SQL File distict.sql like this CREATE VIEW [dbo].[vFM_11023_CAPropertyStatement] AS SELECT CAST(tTS_District.District AS VARCHAR(10)) + ' – ' + RTRIM(LTRIM(tTS_District.Description)) AS District FROM tTS_District i have executed thruogh SQLCMD it is created like this CREATE VIEW [dbo].[... 9 Jul 2008 10:37

Output to text file for Quark Xpress
Hi I'm breaking some new ground (for me) by trying to output a Quark Tags file from my sql 2k db. This is to create a classified directory. A Quark Tags file is just a plain text file which has the text to be formatted marked up with proprietary Quark tags. The text file contains line breaks and tabs, so th... 11 Jul 2008 03:48

Tricky question about joins
Martin If I understood you, change INNER JOIN to LEFT JOIN "Martin Arvidsson, Visual Systems AB" <martin.arvidsson(a)vsab.net> wrote in message news:OnIxVba4IHA.4492(a)TK2MSFTNGP04.phx.gbl... Hi! I have a question about joining tables and return data. Below i have a simple query that returns data f... 9 Jul 2008 07:32

"domain error" in scalar function - How do I trap?
Your problem is the ACOS function which will throw this error when it's inputs are outside allowable values (-1 to 1). I had a similar problem but using floats instead of decimals and with decimal places over a certain point the maths just breaks down. So I just broke out the math that goes into the ACOS func... 9 Jul 2008 06:31

Q: Tricky question about joins
Hi! I have a question about joining tables and return data. Below i have a simple query that returns data from lredd0010 where the number 2440 exists in the redd0020 table. Now for the tricky part, for every record in lred0010 there must exist a 2440 number in the redd0020 table. So what i want to do ... 9 Jul 2008 08:34

varbinary -- convert to varchar and create index key
Hi dear all experts: i have a quick question for this varbinary data type, i m doing some project for this datatype because of MD5 (SQL2k5), however the function HashBytes only return as varbinary data type when i save into my table. question 1: is any way we can conver this MD5 value to varchar? becau... 12 Jul 2008 11:32

XML Bulk Load and illegal (foreign language) characters
I'm wondering what easiest method is to deal with foreign (Spanish) characters in xml data file when loading into database. My vbscript load fails with element values like "Dímelo" - because of the accented i. The files are labeled as encoding="utf-8". Do I need to parse through the file and wrap the problem ... 10 Jul 2008 04:09

What is wrong with the construction of this function
First some context Here is a stored procedrue (SP) that attempts to exercise the function we will see further down: ==== ALTER PROCEDURE dbo.TempGetEntityInfo @EntityID varchar(50) AS select * from dbo.rptOrgHierarchy where baseEntityID in (dbo.rfn_getHierarchyEntities(@EntityID)) ===== Here is the e... 9 Jul 2008 11:39

Select Query with Joins
[I know thw subject isn't descriptive, but I couldn't think of what to call this] The following is the base setup -- if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Product]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Product] GO if exists (select * from dbo.syso... 9 Jul 2008 01:25

Linked server passing parameters
I found one example of passing parameters and got the following results. Given the below example stored procedure: alter PROCEDURE [dbo].[InsertAS400] @FIELDA decimal(5,0), @FIELDB decimal(8,0), @FIELDCP varChar(40), AS EXEC ('INSERT INTO TESTDATA.COMMB (FIELDA,FIELDB, FIELDC) VALUES (?,?... 9 Jul 2008 20:56