The Yellowfin BI team have produced a new paper on "Location Intelligence", the mashup of BI with GIS Extract More than 70% of your organizational...

JTP PR

03-03-2010 05:04 AM
JTP PR

Hi: Please, I´m looking for a SQL query to get data of last 3 months. (We are in March, 2 so I need a query to show me data from Dec/01/2009 until...

valdemirs

03-02-2010 06:54 PM
Plamen Ratchev

Consider a table and a query referring to only a subset of the columns in that table. How early in the query evaluation is the projection carried...

jbdhl

03-02-2010 04:23 PM
Gert-Jan Strik

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

03-01-2010 08:50 AM
Mia

Hi: Please, could you help me with this SQL query ? I need get data from last 3 months, but it´s shows me only January's data. (Query doesn´t get...

valdemirs

02-27-2010 01:21 PM
Erland Sommarskog

On Tue, 23 Feb 2010 23:02:32 -0800, seven <s_e_v_e_n (AT) gawab (DOT) com> wrote: The way I solve this is by first finding the max rows: select...

Tom van Stiphout

02-27-2010 10:51 AM
seven

Hi all I have this query SELECT COUNT(*) FROM Pro WHERE D_TIME BETWEEN '2010-02-14 00:00:00.000' AND '2010-02-20 23:59:59.000' AND...

hayko98

02-26-2010 06:19 PM
hayko98

Suppose you were looking at widget manufacturing data, and your DB looked like...

dvestal@gmail.com

02-26-2010 05:44 PM
Gert-Jan Strik

Hi. I don't really have a problem per se but since I am not a 24/7 DB developer I'd appreciate an experienced set of eyes to provide some feedback...

pbd22

02-23-2010 07:25 PM
pbd22

I've been tasked with designing an application to capture data about sports clubs. Let's say there are four different types of club - Soccer,...

Edward

02-23-2010 09:33 AM
TheSQLGuru

Hi, I am trying to design a db schema (or rather extend existing db schema). My goal is to extend the database table so that every time a new column...

Raju_QC

02-23-2010 03:06 AM
Nilone

Is there anyone out there who can tell me how to place a simple message from within T-SQL into my Outbox of Outlook (not Outlook Express) on the same...

ab

02-23-2010 02:54 AM
ab

SQL Server 2005 SP2 9.0.3054 I would like to move my DB (with Full Recovery Model) onto a /different/ server. I would like to do this w/o losing...

aj

02-19-2010 12:47 PM
Erland Sommarskog

Hello, does the SQL Server 2005 or 2008 have an API for the programming language C? Regards, Domenic

Domenic Laritz

02-18-2010 02:34 AM
Erland Sommarskog

Hello I wonder whether you may have some hints and pointers. I'm trying to create an ODBC User/System DSN but can't see the SQL server in the ODBC...

theintrepidfox

02-18-2010 02:33 AM
Erland Sommarskog

SQL Server 2005 SP2 9.0.3054 Using the EXEC sp_dropserver '<old>' GO and EXEC sp_addserver '<new>', 'local' GO commands, I have successfully changed...

aj

02-17-2010 03:34 PM
aj

I made a web. For those people who want learn and earn by internet .please visit the...

John Smith

02-13-2010 05:07 AM
John Smith

I'm running a website with NetworkService credentials and I'm able to connect fine on one DB, but not the other. Both DBs are running SS 2008, and...

Dave

02-12-2010 05:46 PM
Erland Sommarskog

Hi, I am trying to port a set of Python programs originally working with PostgreSQL, to use SQL Server 2008 with Windows XP... and it is harder than...

Pascale Mourier

02-10-2010 05:49 PM
Erland Sommarskog

I have this wierd problem. I have created a number of login on SQL 2008 on WindowsXP without any problem. Now I start do it on Window 7, and I keep...

daicamad

02-09-2010 03:21 PM
daicamad

Hi All, If I have the following one-column table: Grade 80 100 90 60 50

SQL Learner

02-09-2010 12:11 PM
Gert-Jan Strik

Hi all, Three related questions. Q1) I tried the following code and it works with set @c = CHAR(@x + ASCII('a')) + '-' + @c but it does not work...

SQL Learner

02-08-2010 10:31 PM
SQL Learner

Somewhat noobish here with SQL. Have done some packages with DTS and MSDE. Looking for some guidance on the following project: Need to develop a...

dorkygrin

02-08-2010 05:32 PM
Erland Sommarskog

Hi all, while I work on SQL Server for some time but never being on admin tasks. I install SQL Server 2008 on Admin account of Windows 7, create...

daicamad

02-08-2010 05:21 PM
Erland Sommarskog

Hi All, Here is a more challenging question derived from my last one in...

SQL Learner

02-07-2010 08:07 PM
SQL Learner

Hi All, Hope someone can help to solve this SQL question. I have the following table called '#temptable' (it is a temp table) source price ...

SQL Learner

02-07-2010 07:45 PM
SQL Learner

Yellowfin Business Intelligence an entirely new dimension in Location Intelligence has provide Jet Interactive with a significant competitive...

JTP PR

02-07-2010 12:25 AM
JTP PR

I've installed SQL Server 2005 on a dozen machines before but now I'm stumped trying to install on Windows 7. I have installed the app,...

Lauren Quantrell

02-06-2010 02:45 PM
Tom van Stiphout

Our organization made a preliminary decision to store data for all new projects in a single database because there is some commonality...

Mike Husler

02-03-2010 05:52 PM
Erland Sommarskog

Hi...I need to return the Top 20 customers by 'Accounts Receivable Balance' (= FutureBal + Per1Bal + ... + Per5Bal + Misc_Creds + Unapplied) in the...

LightBulb

02-03-2010 04:35 PM
Plamen Ratchev

I am running an SSIS job manually that I am trying to automate. To automate the task the job needs to run daily and execute when a condition is...

robboll@hotmail.com

02-02-2010 10:26 PM
robboll@hotmail.com

So, I have a series of tables with different columns (but some 'common') e.g. Sales order items (oritem) Process order stock requirements...

Iain Sharp

02-01-2010 05:49 AM
Philipp Post

I much prefer examples and apologize that this question doesn't have one. I unfortunately can't post CREATE TABLE statements for this problem...

bill

01-30-2010 09:16 PM
bill

SQL Server 2005 SP2 9.0.3054 I would like to copy/restore my DB (with Full Recovery Model) onto a /different/ server. I would like to do this w/o...

aj

01-29-2010 12:56 PM
aj

Hi; I'm trying to find the number of records in a table where field_1 is not a substring in field_2. My problem with the query below is that...

steve

01-28-2010 04:11 AM
Iain Sharp

Hi All, I am trying to configure SQL Server 2008 for Office 2007 Data Mining Add-Ins, but got stuck on the very first step - Connect to an...

SQL Learner

01-27-2010 05:10 PM
SQL Learner

I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer...

Virgina Hernandez

01-27-2010 02:36 PM
Virgina Hernandez

Does anyone happen to have sample code for code for "sql server development with access 2000" by Wrox? I am trying to get the sample code on their...

SQL Learner

01-26-2010 09:23 AM
SQL Learner

Hello, I've created a simple SSIS package to migrate data from an Access 2003 mdb to SQL Server 2005. I made the package on my laptop (Windows...

Matthew Wells

01-25-2010 01:12 PM
Matthew Wells

Hi friends I m using SQL 2005 I want to concatenate multiple rows into single row with comma separated. I tried using for XML and all but what I m...

chintu4uin@gmail.com

01-25-2010 07:45 AM
Hugo Kornelis

Hello there, I have a database with positional information in it along the lines of waypoints of various journeys ('tracks'). I am currenetly using...

James Riches

01-24-2010 06:01 PM
Erland Sommarskog

Hi. I am using the following SQLHelper code: http://www.sharpdeveloper.net/source/SqlHelper-Source-Code-cs.html I am trying to use a Sql Function...

pbd22

01-22-2010 05:35 PM
Erland Sommarskog

I have been working on implementing DDL Triggers, to monitor changes in our environment. However, it doesn't seem to behave with Replication - at...

M Bourgon

01-22-2010 12:05 PM
M Bourgon

Number State 10 CA 20 CA 30 CA 10 NY 20 NY 30 NY 40 NY If I have two fields - number and state, as the above table, how can I

SQL Learner

01-21-2010 10:53 PM
SQL Learner

I have a task of finding records that have biggest values in a given attributes, where data is split between 'parent' table that holds my...

migurus

01-19-2010 10:08 PM
Plamen Ratchev

I'm not sure if this requires a cursor or not.....any help would be appreciated. I have 60,000 records sorted in the order I imported them. If...

Bobo

01-18-2010 03:25 PM
Malcolm Dew-Jones

Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards.

..

01-16-2010 09:30 AM
..

SQL 2008 Let's say I am replicating from environment A to B. The column A.database.My_Table.Some_Column is computed. i would like the replicated...

bill

01-11-2010 01:31 PM
bill

Hello, I need to provide sorting ability across multiple column. Data which would be sorted are retrieved with stored procedure. I have two...

m

01-08-2010 07:17 AM
m

Hi all, I have developed a database comparison program, Table Diff, and I would like to ask for feedback, if you have time. Table Diff runs on...

giammarco@volpet.com

01-05-2010 05:55 PM
giammarco@volpet.com