Not exactly a tally table as mister.magoo mentioned but somewhat equivalent.

create table #t(person varchar(100),id1 int,id2 int,id3 int)

insert #t

select 'Person1', 10, 15, 5 union

select 'Person2', 14,14,0 union

select 'Person3', 20,21,1

select person,id1,id2,isnull(T.number,0)+id1 id3

from...

My pleasure Jeff and a great honor.

I gleened what it does from Lowell's post and a couple of dozen posts that I Yabingooglehoo'd but...

Having good background with C# maybe I will try to clear that.

Cid is called ContentIdentifier.So when an image needs to be referenced in a mail basically it can be done...

geo123abram (6/22/2014)

---

My question is, in the sp_executesql's parameter section (the last one), can I define the parameters dynamically? That is, I dont want to feed all the parameters but a...

Can you post the SP code ?

Eirikur Eiriksson (6/21/2014)

---

Those would then certainly...

You can define the parameter to a default value of NULL

@YourParameter1 varchar(100)=NULL,

@YourParameter2 int=NULL

What should happen in case of trailing zero's ? Example 1000,9990 or zero's that are neither leading or trailing ex : 1001

Without sample data this is just a shot in the dark.

SELECT DISTINCT S.EnrollNo

,S.Name

,ET.Descriptions AS EventName

,T1.AttendStudent AS AttendStudent

,T2.AttendFaculty AS AttendFaculty

FROM StudentEvent SE

INNER JOIN SStudent S ON SE.PresentatorID = S.StudentID

INNER JOIN StudentEventType...

pwalter83 (6/20/2014)

---

Sachin Nandanwar (6/20/2014)

---

I dont understand the problem here.Your query seems to be achieving it.

CREATE TABLE [dbo].[GL](

[Sequence] [int] NOT NULL,

[WK NO] [int] NULL,

[AC] [nvarchar](10) NULL,

[COMP] [nvarchar](10) NULL,

[USD_AMOUNT] [numeric](16, 2)...

The deadlocks now typically involve inserts and deletes from the filter table and CRUD action against a table that has a foreign key to master table. The deadlocks are keylocks...

Couple of months back I used a VBScript in Script task component of SSIS package to change file extensions.Not sure about DTS.

I dont understand the problem here.Your query seems to be achieving it.

CREATE TABLE [dbo].[GL](

[Sequence] [int] NOT NULL,

[WK NO] [int] NULL,

[AC] [nvarchar](10) NULL,

[COMP] [nvarchar](10) NULL,

[USD_AMOUNT] [numeric](16, 2) NULL,

[SOA_TYPE] [nvarchar](20) NULL

)...

http://technet.microsoft.com/en-us/library/ms188603%28v=SQL.105%29.aspx

How do you define a quarter ? Based on financial year or Calendar year ?