Search results for query: *

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, 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) >=...

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

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

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, I have 5 column in a table, however one column is updated with recored and rest Null value. Tabletest:- ONE TWO THREE four five 1 2 3 4 5 My condition is, if record value of column one is 2 then i want to Update column TWO with 'True' if value of column two is 3 then i want to Update...

Hi, I have two NTEXT field. Field length is not constant. I wanted to read only last 5 records from right side. ie, 90021 id={E80D4A7B-C8FF-DB11-A6FC-00188B2E03D9}&etc=90021 cr=FromType=ateFromId={W780D8A7-F99D-DB11-8303-00188B2E03D9}&etc=90021 Can any body help ? Thanks you in advance -Mac