dianerstein 8713 (12/7/2016)

---

I only want 1 parameter value that can be obtained from the query where the parameter value = '16-17'. However I want to include logic that will also...

Can you use something like this?

IF NOT EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME ='indexname')

--Do stuff

dianerstein 8713 (12/7/2016)

---

In a t-sql 2012 column I have a column called test1 defines as (varchar(10),not null) in a table called tab. The values in this column look like '16-17'...

wendy elizabeth (12/7/2016)

---

In an existing sql server 2012 database, there are lots of columns defined as (bit,null). When the value is checked to be = 0, the results are returned...

paul 69259 (12/7/2016)

---

Thank you Thom,

That appears to be nearly there the only problem now is if a job doesn't have any additional drops it doesnt show the collection and...

You had the same idea as me, though STUFF is not doing much here other than removing an unwanted character;...

So ... a single row in the Jobs table can have multiple related rows in the Drops table, is that correct?

If so, you could make use of the FOR XML...

clucasi (12/7/2016)

---

i am trying to convert xlsx to xls using DTS script task,but because the server hasn't got excel installed its throwing an error..Would it be ok to load MS...

Brandon Groom (12/5/2016)

---

I had this error also and it turned out to be a source code promotion merge issue with the project file. After the merge, the parameter ID in...

swarun999 (12/5/2016)

---

create procedure spgetuserdetails

(

@UserId nvarchar(255),

@Password nvarchar(255)

)

as

begin

declare @count int

select @count = count(*) from UsersTable where UserId = @UserId and [Password] = @Password

if(@count = 0)

begin

Print...

One thing you could also try is putting the results of the entire source query into a temp table, then indexing the temp table, then merging from only the temp...

TheBI (12/5/2016)

---

Hello,

I want to optimise the following query that is running so slowly.

Please help or gimme an advice.

MERGE dbo.LocalizedCategories AS T

USING (SELECT L.LanguageID,SC.CategoryID,BC.Value

FROM (SELECT...

It's difficult to diagnose without looking into what the package is doing. Is there an error handler configured on the component which is failing inside the FEL?

You wrote an error to job history? What problem do you think this is?

kpmandani (12/4/2016)

---

Not only just to determine the number of rows in the text file but based on the count, it should determine (and send) that same text file as an...