Viewing 15 posts - 136 through 150 (of 315 total)
ankushchawla03 (11/17/2008)
A B
_______
a x1
a ...
November 17, 2008 at 6:45 am
1 Use ANSI joins
2 Avoid using single quotes around alias names
3 Dont sent summay information along with detail records
November 17, 2008 at 5:38 am
Also refer
http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/truncate-all-tables-part-ii.aspx
November 17, 2008 at 5:36 am
Sudarsan Srinivasan (11/14/2008)
I want that in the backend..
That is not the correct answer to my question
Anyway
declare @val decimal(12,2)
set @val='10000.00'
select convert(varchar(15),cast(@val as money),1)
November 14, 2008 at 7:45 am
MarkusB (11/14/2008)
shiwani2002sg (11/13/2008)
aa ???
dd
jukin ???
kdf ???
dfe
de
d ???
now i wish to extract values having ??? at the end but extract them without ???
like i...
November 14, 2008 at 7:42 am
Sudarsan Srinivasan (11/14/2008)
Hi,How do i format a numeric value in 1000 separated value.
eg. 10000.00 as 10,000.00
Where...
November 14, 2008 at 7:33 am
ggraber (11/13/2008)
That's not going to work.He needs two pivots.
One for TotalPackages and one for TotalCost.
Thanks
I didnt notice OP wants it for two columns
November 14, 2008 at 7:30 am
tochaturvedi (11/13/2008)
I have a table with identity column(Only one column in that table) seed 1Write SQL code to insert a row into that table.
Please provide me the query.
insert into table_name...
November 13, 2008 at 7:20 am
dynamic_pivot
'select shipdate,TotalPackages from #ShippingInfo',
'service',
'min(TotalPackages)'
Use the procedure from http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx
November 13, 2008 at 7:10 am
mutekinohito (11/10/2008)
I am trying to load data from and excel 2000 file into its respective table, but I get the following error: "[OLE/DB provider returned message: The Microsoft Jet...
November 13, 2008 at 6:43 am
meichner (11/10/2008)
November 10, 2008 at 7:29 am
ggraber (11/7/2008)
Madhivanan (11/7/2008)
ggraber (11/7/2008)
Well. Also note that the procedure is dynamic and you can change the pivot or summary columns as you wish 🙂
Yes, I think it's very cool.
I've done...
November 10, 2008 at 6:45 am
ggraber (11/7/2008)
Madhivanan (11/7/2008)
Did you try it?It exactly works as per OP's expected result
I just tried it again, and you are correct, it works perfectly.
I don't know why I couldn't get...
November 7, 2008 at 5:55 am
Viewing 15 posts - 136 through 150 (of 315 total)