Hi Jeff,

But still am using the @@IDENTITY, yet no issue raised, ok will check your advice.

Hi,

Repeated post, Discussion already starts, in

http://www.sqlservercentral.com/Forums/Topic838860-392-1.aspx?Update=1

Hi,

Repeated post, Discussion already starts, in

http://www.sqlservercentral.com/Forums/Topic838860-392-1.aspx?Update=1

Hi Prakash,

Assumption of the parameter passed to table, try this

declare @fromdate datetime,@todate datetime,@amount numeric(10,2)

set @fromdate = '2009-10-05'

set @todate = '2010-10-20'

set @amount = 10000

set nocount on

/*table for month detais*/

declare

Hi Viper,

Both tell you the same concept which you not made in your code. However you got the concept that’s enough.

Hi,

you mean,

create view [ORDER]

as

SELECT [MonthYear], SUM([Total]) AS Total...

SELECT [MonthYear], SUM([Total]) AS Total

FROM

(

SELECT CAST(DATENAME(M, Date) AS varchar) + '-' + CAST(YEAR(Date) AS varchar) AS 'MonthYear',

SUM(Amount) AS 'Total'

FROM dbo.hardware

GROUP BY CAST(DATENAME(M, Date) AS varchar) + '-' +...

Hi,

Post your code

Hi Vijay,

You may already raise this in many communities and have yet didn’t have?

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c3901c09-d804-430a-bead-ed6505a80b9d/

Ok, so for what you understand, can share with us,

And refer the jack point in mentioned discussion

http://www.sqlservercentral.com/Forums/Topic630291-148-1.aspx

Hi,

--Tally TABLE

SELECT TOP 1000 IDENTITY(INT,0,1) AS N

INTO dbo.Tally

FROM Master.dbo.SysColumns

--use this statement in your trigger

select a.[ID],a.Heading,b.n

from MYTABLE a inner join

Tally b

on b.n...

Hi,

Yes, it’s possible and see the Jeff article “Cross Tabs and Pivots, Part2 – Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/

select [ID],[NAME],

max(case when [PLACE] = 'Sydney'then [DATE] else '' end)as [Sydney],

max(case when [PLACE] = 'Macau'then [DATE] else '' end)as [Macau],

max(case when [PLACE] = 'Texas'then [DATE] else '' end)as [Texas]

from MYTABLE

group...

Hi,

First, why you need to change to 2003 x32 bit? Any specific reason for this, other wise this not affects...

Hi,

See this discussion

http://www.sqlservercentral.com/Forums/Topic834904-9-1.aspx#bm835097

Hi,

Yes you can be achieved this by the JOB.

See the BOL http://msdn.microsoft.com/en-us/library/ms181153.aspx