It again boil down to knowing the filename before executing the package. Is there any way where we could just simply go to the website and dynamically parse all the...

Hi Nader Sam,

Did you try using Label and goto statement .

Did that worked for you.

Below is the error

Msg 4108, Level 15, State 1, Line 2

Windowed functions can only appear in the SELECT or ORDER BY clauses.

Alvin Ramard (6/10/2015)

---

If #Temp2 had a RowNumber column, with values that reset to 1 for each grouping, then in your update statement, you can add the join on the row...

Yes, i am trying to update #temp2 , so is there a way to achieve this 🙁 ...

So Experts, which is the correct explanation. Either given by Eirikur Eiriksson or Toreador.

Melanie Peterson (12/4/2014)

---

I got the answer (from StackOverFlow, ahem). I need to fully qualify my object names. We have a mobile.Employee table and a dbo.Employee table. Three of us were...

serg-52 (12/5/2014)

---

There are many ways to do that. For example

select c1 = case when City2 > City1 then City1 else City2 end

, c2 = case when City2 > City1 then...

If you are using SSIS, then why...

Well, there is no business logic. It can be anything, i was trying out this for...

Hi Gail,

I have gone through your completed post but still cannot understand Why Covering index is updated During and update .

My update does not contain the key column of...

Hi,

I search a loot but could not find anywhere how Covering Index are stored intenally.

The reason i am trying to...

Jeff Moden (11/30/2014)

---

Shadab Shah (11/30/2014)

---

I have written an update, if i see the execution plan of that update, it is showing the Non Clustered index are updated. I am not...

For OpenQuery we need to have Linked Server and building Linked Server on this DB Server is not feasible :ermm:

Hi PB_BI,

Thanks for the reply, but i am using the following query,

SELECT top 1 lock_object_id

FROM $System.DISCOVER_LOCKS

WHERE Lock_type = 4

I googled but i found out that i cannot use, Iff in...