|
|
|
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 |
#Temp table question Posted by MichaelK at 12/31/2004 4:12:06 PM I'm not sure if I understood this correctly.
If I create a temporary table with the name #SomeTempTab,
can anybody else see this table while I'm using it and before I drop it.
So if two users at the same time trying to create the table with this name
will they be different for each user or there...more >>
Running counter Posted by MichaelK at 12/27/2004 1:37:05 PM Is it possible to make a query to have a counter which would have
a sequential number of each record in the query starting with 1?
Thanks,
Michael
...more >>
SQL 7 vs. 2000 issue -trigger and nulls Posted by Bill Polewchak at 12/22/2004 11:34:54 AM We're trying to dump our remaining v7 SQL server and update to 2000.
We're having trouble with a trigger updating some tables.
At the beginning, it has this statement:
COMMIT TRANSACTION --This unlocks the Lot table so I can update UDAs,
etc...
BEGIN TRANSACTION
This is what throws the tr...more >>
newbie SP question Posted by Miguel Salles at 12/20/2004 5:01:01 AM Hi, I'd like to create a SP like this:
SP_Table1_LOAD
Update Table1 set... (alter existing rows)
Insert Into Table1... (insert new rows)
This table is a dimension on my DW, I'm used to do this with DTS but I have
never used Stored Procedures before.
Can anyone please help me?
Thanks
...more >>
Bookmark lookup (Why) Posted by we7313 at 12/15/2004 11:55:04 AM I can't figure out why i have a bookmark lookup cost on ValidVendorPackages
on the below proc:
Select PriceViewHotelPrice.price as Totalprice, PriceViewHotelPrice.Docid
from price_view PriceViewHotelPrice Inner Join
(
select C1.Priceid as Pid,C1.VendorPackageId from
(
select distin...more >>
Help with Select statement Posted by Harry J Nathan at 12/13/2004 6:59:08 AM Help me with the following query.
I have employee table as follows
EmpID (Number)
FullName (Text)
ReportTo(Number)
ReportTo field contain number from EmpID
Sample Data from the table
EmpID FullName Reports To
1 Nancy Davolio 2
2 Andrew Fuller
3 Janet Leverling 2
4 Margaret Pe...more >>
Displaying columns from 2 independant tables Posted by Wes at 12/10/2004 9:55:41 AM I have a table as follows:
Code Quantity Status
ACC1 50 Dispatched
ACC2 31 Dispatched
ACC3 62 Dispatched
ACC4 11 Awaiting Dispatch
ACC5 13 Dispatched
ACC5 5 Awaiting Dispatch
A...more >>
how to insert characters in existing field Posted by Tiffany at 12/7/2004 6:55:04 PM Hi,
I have a sql table with a field name model. In the model column, i have
model number that start with FX%.
I want to add WM before FX%. After FX can be anything, characters or
numbers. The model data type is varchar.
How can i do it. I tried using the syntax below but not successful....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
NULL = NULL not working Posted by we7313 at 12/4/2004 3:53:05 PM I have a proc that can specify a price range if its passed in.
my and where clause looks like this:
where ((PriceViewHotelPrice.price + PriceViewAirPrice.price)between 500 and
600) or(NULL = NULL))
I have removed the parameters & replaced them with the values passed in
running it throug...more >>
select query Posted by shif at 12/1/2004 7:35:07 AM Hi
I am having a table ,
acct dramt cr_amt
101 5
103 5
101 10
how can i make a select stmt which gives the net bal,if sum(dr_amt ) - sum(
cr_amt) > 0 group by acct,it must come in dr_amt column else in cr_amt.
in select result. result looks like this...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |