Search results for query: *

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

...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) >= '01/01/2007' and convert(varchar,LastDate,101) <= '01/31/2007')...

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...

...multiple records from "StreetCentral" table Here Oprid is primarykey in StreetCentral table and Id is FK in Street table ---------- select name, * from StreetCentral where oprid= (Select Id From Street Group By Id Having Count(*) > 1) ------------- Here it gives error:- Subquery...

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

Hi, I have been trying to get a vbs file that would COPY my latest IIS log files to another server after the file has reached 24 hours of age. Using window 2003 server. Path = "C:\WINDOWS\system32\Logfiles\W3SVC1" Destination path: \\206.134.11.23\temp Thanks in advance!!! -mac

Hi, Got this error during Parse, Something missing ? Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'SET'. UPDATE TableTest SET Two = CASE WHEN One = 2 THEN 1 ELSE Two END, SET Three = CASE WHEN One = 3...

Ohh, its my mistake, Now the structure is like below, How we can minimize the query. i want to write single UPDATE command which will all columns update tabletest set two = case when one = 2 then 'True' end from tabletest update tabletest set three = case when one = 3 then 'True' end from...

Sure, Appreciate your prompt response. For Columns: TWO, Three, Four, Five Data Type = bit allow nulls: Yes For Column: One Data type = int allow nulls: Yes mac

Thanks for you update, This is only one time update on database. Error with Example:( update tabletest set two = case when one = 2 then 'True', case when two = 3 then 'True' end from tabletest