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...

Eirikur Eiriksson (12/5/2016)

---

BOR15K (12/5/2016)

---

I have a table of several millions of records for flight ticket. One of the indices is Flight Ticket, so when user searches for ticket 1234567 or...

Well done. I compared execution plans and my version seems to have the edge. Especially if you add an index on (requestid, eventdate, eventname). Might be worth testing both on...

I have an inelegant solution to this inelegant problem 🙂 There will be better ways, but this seems to work, at least for the test data provided:

SELECT

...

If a RequestId has been 'Closed', shouldn't the next RequestId have a different value? If they're all 46444, what's the point of this number?

Please post your data in a consumable...

OK. So you want SSIS to 'interrogate' a particular file, which has already been produced by another process, get the row count and then act according to result?

If so, your...

You have more than one problem going on here. One is regarding access to an Excel spreadsheet...

kpmandani (12/2/2016)

---

I want to send a csv file using SQL Server only when it has more than 1 record present in it. Daily this file is getting cleared and updated...

drew.allen (12/2/2016)

---

Phil Parkin (12/2/2016)

---

Just having a mind warp on how to insert into the address table and get that unique int value and put it into the correct master row...

This...