Recent content by macsql1

Thanks A lot.

One more update BookCollection_ID is VARCHAR2 NOT integer. CREATE TABLE BookPart ( BookPart_ID INTEGER NOT NULL, LIMIT_MAX VARCHAR2 (255), BookCollection_ID VARCHAR2 (255), PRIMARY KEY (BookPart_ID )

one more update I have replaced ` to ,(comma) then try to render "1,2" as "ToyBook,FunBook" in result replace('BOOKCOLLECTION_ID', '`', ',')

Yeah. I want to render BookCollection_ID (1,2) value as (ToyBook,FunBook). BookCollection_ID is manually enter by user like 1,2 or 2 or 1,2,3 BookPart BookName_ID----Book_NAME-------BookPart_ID 1---------------ToyBook---------88 2---------------FunBook---------99...

Hello- I have two tables. How I can cast BookCollection_ID number to Book_Name? Please help Select A.BookCollection_ID from Bookpart A, BookName B where A.BookPart_ID = B.BookPart_ID OutPut 1,2 Expected OutPut ToyBook,FunBook We need to separate 1,2 and extract Book_NAME from BookPart table...

Good Morning, Using SQL server 2005. I have 200 records and want to update ALL field with URL along with GUID where GUID is unique for every record Here '<a href=https://testlog.com/main.aspx?id={926849y2-K6Y4-D11-L692-80927B2M03E2}>GroupOne</a>'is constant and would like to insert GUID...

Hi Dian, huh i was missing :) well when i hit save as got following dialog box. Is there any way to export both the data and the VB code to XML? Thank again ====================================================================== The following features from your workbook will not be saved in...

Hi, How to convert .xls file to XML. I have office 2003 and want to convert bookslog.xls file XML format, here bookslog.xls file contain 3 worksheets. Thanks in advance. mac

Hi, I want records for only one month, between 1st January 2007 till 31st January 2007. I written following query, but output also gives for January 2008 and 2009 using sql server 2005. Kindly help.. select convert(varchar,LastDate,101), * from Table1 where (convert(varchar,LastDate,101) >=...

Hey whosrdaddy, You are also a Star. why am not able to mark you as Star.

I have 2 tables Division Table DivisionId (Pk, uniqueidentifier,not null) DivisionName (nvarchar) DivisionLocation(nvarchar) Region Table RegionId (Pk, uniqueidentifier) RegionName (nvarchar) RegionManager(nvarchar) RegiondivisionID (FK,uniqueidentifier,null) Here i need the name of division...

Thanks George, I got expected result: Name ID ---------------- Lina 111 BOb 124 I have an another table where i have to map the id, pull multiple records from "StreetCentral" table Here Oprid is primarykey in StreetCentral table and Id is FK in Street table ---------- select...

Hi, I have three columns. however i would like to list common records. i.e.111 and 124 which appears in multiple time. How to figure out the name/id which is > 1. Using sql server 2005. Table : Street Name ID Street Name -------------------------------- Lina 111 Randolp Rosy 123 Lake BOb...

Hi All, I have a question. Using sql server 2005. A table with 3 column, where column1 contains data in numeric(1234)then one space followed by alphabets(Book). I need to separate Column1 value to Column2 and Column3. eg1. Column1: 1234 Book (Output ) Column2: 1234 Column3: Book eg2...

Thanks for reference. Daily ONE new log file is created, and i want to copy new file to another server which is in same domain. -mac