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

You really just need to get a connection to the SQL Server from your Unix box. A quick search for SQL Server Linux Client got me to http://richbs.org/post/43142767072/connecting-to-microsoft-sql-server-from-unix-linux-mac

That page will...

When you have a situation like this, there are a lot of places that have tools that will automatically run through all the diagnostic information for you.

One of my favorite...

I would take a look at the BCP utility.

If you use -c it will convert everything to a char type and use a tab as a separator so you...