We cant defined the excel sheet count . It may vary based on the record counts received from Database.

Another issue, Currently am able to create excel sheet and place the...

Hi,

declare @t1 table (SomeId int)

declare @t2 table (SomeId int)

insert into @t1

Select (1) Union all

Select (2) Union all

Select (3)

insert into @t2

Select (1) Union all

Select (2) Union...

I didnt receive any errors. I dont know, how to use case statement of @Company parameter in below query. Rest of part good as far as my concern.

Set @FNAME ='Surya'

Set...

I have tried like below to alter the dynamic query.. But i cant able produce the result. Can you please guide me.

Declare @FNAME VARCHAR(100)

Declare @LNAME VARCHAR(20)

Declare @NRIC VARCHAR(20)

Declare @Company VARCHAR(60)

Declare...

Hello crazy4sql, its very helpful to me. Nice one.

I have small doubt in this,here i can only view one month data in that report. Is there any constraints in this...

CAn you please give me, bit information about this.

Hi,

Actaully i have tried below one, but i got only last one day results only. but i need to past 25 days records.

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS...

Just i need to know what r the queries ,that we running since last month. I need to track this result

Can i get any articles or link regarding the flow of query execution.Its very helpful to me.

For eg:

Declare @t table( Id int, name varchar(50), Actions varchar(50), Active int)

Insert into @t

Select 1,'One','aabccdddee',1 Union all

Select 1,'One','abcf',1...

I have small doubt in this,

Right now sql compatibility level is 80.

But in this cross apply and CTE type are accepted. only the problem is pivot type.

...

Nice,Thanks dave.

Actually this is my actual query

Declare @Month int,@Year int

set @Month=12

SEt @Year=2010

;with cte

as

(

SELECT TOP 5 row_number() over(order by (select 0)) ID,dbo.Assets.AssetShortName,COUNT(*) AS Counts

FROM dbo.Proposals INNER JOIN dbo.Assets ON dbo.Proposals.AssetID=dbo.Assets.AssetID...

Chris Morris-439714 (10/21/2010)

---

SELECT s.*, x.*

FROM @t s

CROSS APPLY (

SELECT EmpNamePart = SUBSTRING(s.EmpName, b, e), b, e

FROM (

SELECT

n.n AS b, -- delimiter at beginning of string

ISNULL(NULLIF(CHARINDEX(',', s.EmpName, n.n+1),...

Thanx friend. i got correct result. If possible give me result for cross boundary year.It's very useful for future