|
|
|
July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
query Posted by Tiffany at 10/29/2006 7:01:01 PM Hi,
i have a model column and has all sort of names.
E.g.
Model names
CRUZERCROSSFIRE00512
EXTREME512MBCF
EXTREMECF00256
EXTREMEIIISECUREDIGITAL
ULTRAIIMAGICGATEMP00512
ULTRAIIMAGICGATEMP01024
X00512
I have a new column and this new column is to differentiate the model
belongs t...more >>
query Posted by Tiffany at 10/25/2006 9:57:01 PM hi,
Have a problem and hope someone can help.
I have a column which consists of numbers such as
123
235
456
888
etc
How can i write a simple query to change them to
00123
00235
00456
00888
etc
Kindly advise.
Thank you very much
...more >>
parameter query Posted by Brian L at 10/25/2006 12:31:02 PM I have a table of doctors, each doctor is assigned a unique identifier, but
may have mulitple offices in diff cities with differnent id numbers. When
writing my paramter query to build a list of doctos, I am seeing duplicates.
query looks like this:
select rtrim(LastName) +', ' +Rtrim(Firs...more >>
Capture Before/After data on Multirow Updates Posted by Ymerejtrebor at 10/20/2006 2:57:01 PM Problem: I only get one record of before and after data when performing
multirow updates from a single update statement. I want to get before and
after data for ALL updated records from the update statement. How can I do
this? I am using sp_trace_generateevent to capture before and after ...more >>
Hierarchy Data in XML Posted by Sekhar at 10/10/2006 11:01:02 AM Hello All
I have two Table Employee and Dept
Employee Columns
EmpID
EmpName
MgrID
DeptID
EmpID(PK) MgrID (FK)
Dept COlumns
DeptID
DeptName
I need to return XMl Hierarchy when I pass DeptID as a parameter
So my final result shoudl look like this
<Dept>
<Emp ID="" Name=...more >>
Insert data Posted by BMW at 10/6/2006 3:38:01 PM Hi,
I haven't figure out why the store procedure execute withour error, but the
data doesn't on the table.
I have a store procedure which is call by the component in the exchange
server.
I saw the store procedure is compelted on SQL Server Profiler and the writer
comlun display '1'. Ho...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |