Lynn Pettis (8/17/2012)

---

cphite (8/17/2012)

---

I've been tasked with trying to set up log shipping in a blind scenario... that is, the source server and the target server cannot communicate with...

Canazei65 (8/15/2012)

---

Hi

Thanks for the replies - I shall take a look now. However, I should have made it clear in my post the financial year in the UK runs from...

Canazei65 (8/15/2012)

---

Sorry my previous post was incomplete (pressed some key combination that submitted).

Here's what I meant to say:

Hi

I have 3 parameters in my report:

[FinancialYr] in text format: '2011/12', '2012/13' etc

[FromDate]...

Was just wondering if anyone has found a fix to this issue... I am getting the following error when I open Activity Monitor. My account is a sysadmin...

rummings (7/25/2012)

---

A developer showed me a very small sql server t-sql script he wrote (5 SQL lines). It loads information into a SQL Server 2005 table. If he runs the...

Lucky9 (7/11/2012)

---

I have to create a SSIS package.

Where the data gets loaded from excel to Sql server database table....

excel file name gets updated every 1 hour...so after every 1 hour...

Steve-443559 (7/9/2012)

---

I'm using SQL 2008 R2 Reporting Services enterprise edition. I have a report which needs to be sent out to 500 or so different email addresses. The...

ELLEN-610393 (6/22/2012)

---

I thought that BIDS was basically opening VS with the SSRS Templates as a default project/solution type? We have a user now that has Visual Studio but does...

Correct.

In fact, aside from the lack of a preview feature and the different file extension,...

joshd 1807 (5/31/2012)

---

I wasn't aware you could put the case statements into the GROUP BY clause...that's interesting! I need to be more daring in writing code 🙂

Unfortunately the query doesn't...

I still have to disagree. We don't have the full picture here. How do we know if the individuals ssn is stored anywhere else in the database? Personally, it shouldn't...

Lynn Pettis (5/25/2012)

---

cphite (5/25/2012)

---

blampe (5/25/2012)

---

The countSSN procedure runs fine, but what I am trying to do is actually physically replace the values in the table with these count values generated...

blampe (5/25/2012)

---

The countSSN procedure runs fine, but what I am trying to do is actually physically replace the values in the table with these count values generated by the countSSN...

No cursor; a simple way to do this is as follows:

;with list as

(

select

ssn,

row_number() over (order by ssn) + 1000 as ID

from

person

)

update p

set p.ssn = l.ID

from

person p

inner join list...

Putts (5/9/2012)

---

SQLKnowItAll (5/9/2012)

---

I think the "real" problem here, that you are avoiding, is that the database schema keeps changing. If it was designed properly to begin with, you would...