Seems to be common today as I have had to edit quite a few of my posts :hehe:

I'm not sure what OP wants for "UNION ALL SELECT 400 ,10 ,10 " data sample, I've read his requirements as: he only want to see the record when there...

🙂 but this is indicating hw long the decNumber is. The requirement says that it...

EDIT: Misread requirements...

sunnyepgc (3/15/2012)

---

Urgent Help required in implementing below using SQL SERVER 2008.

I have a table with the following data.

Table A:

ID AMT_DIFF...

Something similar to this:

CREATE TABLE decNumber (decNumberCount tinyint, decNumber VARCHAR(3))

INSERT INTO decNumber

SELECT 2, '99'

UNION ALL

SELECT 2, 'A0'

UNION ALL

SELECT 2, 'A1'

UNION ALL

SELECT 3, '001'

UNION ALL

SELECT 3, '999'

UNION ALL

SELECT 3, 'A00'

UNION ALL

SELECT...

MyDoggieJessie (3/15/2012)

---

As you can see from the image attachment, this was done initially (again I set db mail and the jobs up the same way on all my servers (+20))....

Can you create a tally table with these values (if maximum is 2000, I would create 3000 just in case)?

You have to set a notification on the job, not an alert. It will not do any emails by default.

The first problem is that @DecNumber is a BIGINT. You cannot store characters in BIGINT. First you need to change this to CHAR(2) or something that applies. Does...

And what SP is the operating system? Windows Server SP2 is required for this.

You can use replace function to replace spaces with %:

CREATE PROCEDURE [CategoryName]

@VALUES varchar(1000)

AS

SET @VALUES = REPLACE(RTRIM(LTRIM(@VALUES)), ' ', '%' );

SELECT c.CategoryName

, CategoryId

, SB.SubCategoryName

, SB.SubCategoryId

FROM...

Taking a stab... I think the OP is asking if there is a way NOT to use a linked server to gather data from another server for the view. ...

CREATE PROCEDURE [CategoryName]

@VALUES varchar(1000)

AS

SET @VALUES = RTRIM(LTRIM(@VALUES));

SELECT c.CategoryName

, CategoryId

, SB.SubCategoryName

, SB.SubCategoryId

FROM tblAdCategory c

JOIN tblAdSubCategory SB

ON SB.CategoryId =c.CategoryId

WHERE c.CategoryName LIKE '%' + @VALUES...

IgorMi (3/14/2012)

---

Thank you Jared

I tried and succeed. I admit that my administration skills are not as good as my developing. However I'm working on it.

Actually, I can now conclude that...