sqlmaverick (1/23/2015)

---

Hi, please help me to get below logic in Derived transformation, SSIS.

Logic:ensure the Docket number is 5 digits and populate with leading zeros if not.

I have to check input...

rcharbonneau1 (1/20/2015)

---

I'm using Report Builder 2.0. I have everything working great, but the data is kind of hard to read with the lines being so close together. Each ID has...

ft55 (1/19/2015)

---

Looking on an explanation on the following if possible.

At an O/S level Windows Server 2008 R2 is configured with Region and Language as English (United Kingdom)

At a server Collation...

maxlezious (1/15/2015)

---

Hi,

I have decided to use Wufoo online forms so collect evaluation data from my clients.

Each form will have different type of data.

For example

Form 1 might have:

Client id, name,...

Skip (1/14/2015)

---

Some assistance is needed. Hopefully, I can explain what I'm trying to do and someone can help me write an update query. It's got me a bit...

You do it the other way around... You have SSRS execute the stored procedure.

For the dataset, you can have it call a stored procedure on your server.

I usually have...

If you have the SSRS report pointing to your stored procedure, then that's only one place you need to make changes.

I'm not sure if Excel would be aware of the guts of SSRS.

If I had to do something like this, I'd have Excel pointing at the stored procedure that is...

It looks like you're talking about building some dynamic SQL.

The general outline is to dynamically build a string that can be executed to build your result table. Here is ...

It also depends on where you're storing your backups.

If you backup to tape, you can run into issues with misplacing a tape from 5 years ago, or having a tape...

If you're declaring the variables and want to set them on the same line it's something like this

DECLARE @MyInt INT = 0

If the variable is already declared earlier in...

pietlinden (12/31/2014)

---

Maybe I've read too much of Ralph Kimball's stuff, so now I can't see the forest for the trees.

I have something like the standard sales data warehouse structure, but...

At a general conceptual level, here's how a system like that would work. Or at least, this is how I might tackle something like this.

Create a queue table for processing.

Create...

If you want to do it from the back end, I can think of one possibility.

Have your stored procedure add the IDs to a queuing table and process the IDs...

Another option is

SELECT *

FROM (

SELECT id

,rowid

,value

,readingdate

,ROW_NUMBER() OVER (

PARTITION BY id

,datepart(hh, readingdate)

,CASE

WHEN datepart(n, readingdate) <= 30

THEN 0

ELSE 1

END ORDER BY id ASC

,readingdate DESC

) PartID

FROM #tempreadings

) a

WHERE partid = 1