Viewing 15 posts - 1,111 through 1,125 (of 2,463 total)
i got solution for this but this is not nice one 🙁
select * from
(
select
english as [john_english],
social as [john_social]
from @t where name = 'john') a
,
(select english as [Mary_english],
...
February 24, 2011 at 12:08 am
Another requirement
declare @t table
(
name nvarchar(10),
English int,
Social int
)
insert into @t
select 'John' , 100, 90
union
select 'Mary' , 35, 87
select * from @t
--Output Needed
NOw there column will be 4...
February 23, 2011 at 5:57 am
Thanks Srikant . i saw your reply today only but i had the same approach yesterday to fulfill the objective.
February 23, 2011 at 12:10 am
Thanks Steveb but it means if i have 100 columns i need to do 100 union.That would not be a nice approach
February 22, 2011 at 2:33 am
GilaMonster (1/24/2011)
Why is this query a problem?
the usage of resources if fine as per the query design.but i want to avoid Clus index scan or its cost %. i...
January 24, 2011 at 6:10 am
GilaMonster (1/24/2011)
The msdb job tables are not system tables.
Should i add some required indexes ? and how these table got populated ?
January 24, 2011 at 5:36 am
sag999 (1/7/2011)
You can also consider Change Tracking or Change Data Capture. Both functionalities come with SQL 2008.
Change data capture is available only on the Enterprise, Developer, and Evaluation editions of...
January 7, 2011 at 7:03 am
TST1 (1/7/2011)
Msg 1934, Level 16, State 1, Procedure Log_DDL_Database_Events, Line 20
can you post its definition ?
January 7, 2011 at 7:00 am
GSquared (1/6/2011)
I haven't used it in a while (I use CLR procs instead)
i am also using sysadmin credential for xp_cmdshell.
can you help me out how you are using CLR...
January 7, 2011 at 6:53 am
Nils Gustav Stråbø (1/6/2011)
You are not by any chance running the reindex maintenance plan between your full backup and differential backup?
maintenance plan just within 1 min interval ..strange for...
January 6, 2011 at 9:49 pm
yes i always do that but my question is why the results is varying
January 6, 2011 at 5:15 am
can you try to reproduce it ? Size of differential can be only if there is some heavy DML operation within that 1 min interval.
January 5, 2011 at 6:32 am
akhandels (12/31/2010)
In SQL Server 2008 management studio, DDL & DML can be scripted using the wizard like this:http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx
This is the fastest way to script DDL and data.
Thank You.
Cracker hint...
January 3, 2011 at 6:19 am
See if this can help you http://msdn.microsoft.com/en-us/library/cc280663.aspx though i dont have concrete reply for your post
January 3, 2011 at 5:46 am
Viewing 15 posts - 1,111 through 1,125 (of 2,463 total)