| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | We are at a company where we are changing their DataMart.
We are looking at whether to do the ETL using SSIS or just use one SQL to do
it (which is...
tshad
|
12-16-2010 07:26 PM
tshad  | 0 | 26 |
| | | I was looking at the SSIS tutorial using the samples provided by MS and
found something interesting.
For 2008, I went through the tutorial and it...
tshad
|
12-16-2010 06:33 PM
tshad | 0 | 20 |
| | | International Business Intelligence (BI) vendor, Yellowfin, has
released the new version of its BI solution – Yellowfin 5.1 Socialize,
Visualize &...
JTP PR
|
12-09-2010 05:26 AM
JTP PR | 0 | 20 |
| | | Finding the best beer by geography
We kicked-off the selection process by perusing an awesome web site
www.beerme.com , which has a great beer list...
JTP PR
|
12-06-2010 05:34 AM
JTP PR | 0 | 21 |
 | | I have a common table expression that runs VERY slow.
The CTE query definition section takes about 2 seconds to run and has 99
rows in it.
But then...
tshad
|
12-05-2010 01:53 PM
tshad | 15 | 30 |
| | | There is no ROI in Business Intelligence; unless you make a decision.
Yellowfin has launched its 5.1 release to an expectant international
audience...
JTP PR
|
12-02-2010 05:42 AM
JTP PR | 0 | 25 |
| | | I am studying "Beginning SQL Server 2008 Express for Developers
From Novice to Professional" by Robin Dewson. On pages 191 to 198, it
deals with...
Gene Wirchenko
|
12-01-2010 02:31 PM
Gene Wirchenko | 17 | 26 |
| | | Why outsource- India is the land of highly skilled IT and web
developers with the low per hour rate work in the world. If your
company want to...
Nitin Naresh
|
11-25-2010 06:31 AM
Nitin Naresh | 0 | 20 |
| | | Yellowfin is launching the latest release of its Business Intelligence
(BI) platform – Yellowfin 5.1 – and you’re invited!
Join us in an exclusive...
JTP PR
|
11-24-2010 05:00 AM
JTP PR | 0 | 19 |
| | | I have a table function that works fine except when used as a JOIN.
If I have a function that I am passing a parameter from a value I had...
tshad
|
11-22-2010 05:44 PM
Hugo Kornelis | 1 | 19 |
| | | Gartner says social computing to change the face of IT and business
Gartner has identified the impact of social media as one of four broad
trends...
JTP PR
|
11-21-2010 06:14 AM
JTP PR | 0 | 16 |
| | | This Film has got hacked before the release of the date .... Harry
Potter and the Deathly Hallows is the Seventh Film Novel Of Harry
Potter has got...
group
|
11-18-2010 04:11 AM
group | 0 | 18 |
| | | Hi
We have "Windows server 2003 for small business server service pack 2"
and it has SQL Server 2000.
But we do not have installed sql server...
kavi
|
11-17-2010 06:36 AM
kavi | 0 | 18 |
| | | I need to check to see if a record exists to determine whether to insert a
record or not.
If I have the following:
SELECT *
FROM Image
WHERE...
tshad
|
11-16-2010 08:55 AM
Bob Barrows | 5 | 20 |
| | | Hi all,
I am trying to configure SQL Server 2008 for Office 2007 Data Mining
Add-ins. And on the connection set up screen, it asks for the...
SQL Learner
|
11-14-2010 02:43 PM
Rumeysa | 3 | 286 |
| | | Since recently queries conversion became one of the most demanded
features for competing migration tools. It wouldn't be an exaggeration
to say that...
DMSoft Technologies
|
11-14-2010 09:19 AM
DMSoft Technologies | 0 | 24 |
| | | Yellowfin’s latest Business Intelligence (BI) application for the
iPhone and iPad is now available from Apple’s App Store.
BI software analyzes and...
JTP PR
|
11-14-2010 05:27 AM
JTP PR | 0 | 18 |
| | | Want to outsource web development projects, we are here for help.
Why outsource- India is the land of highly skilled IT and web
developers with the...
Nitin Naresh
|
11-14-2010 02:34 AM
Nitin Naresh | 0 | 25 |
| | | Hello,
A new Open Source tool, DiffKit, has just added support for SQL
Server.
www.diffkit.org
It allows you to compare to SQL Server tables,...
joe
|
11-13-2010 10:47 AM
joe | 0 | 23 |
| | | Dear Everyone,
as you know the price of the Oil is more and more increasing, while
the oil supply is decreasing. Moreover Oil
is causing wars,...
........
|
11-13-2010 05:36 AM
........ | 0 | 21 |
| | | gives the same respect I give to them
http://tapurl.com/8fL0Lr
real cheating wives online for dating
hansehusen@ymail.com
|
11-12-2010 09:47 AM
hansehusen@ymail.com | 0 | 18 |
| | | enjoy time with family and friends a good glass
http://tapurl.com/8fL0Lr
she is hot and husbond is far away
hansehusen@ymail.com
|
11-12-2010 09:46 AM
hansehusen@ymail.com | 0 | 16 |
| | | I have created a report using sql server reporting services. The
report title is a textbox that takes a value from "reporttitle"
parameter. I had...
Mandar Kulkarni
|
11-12-2010 05:52 AM
Mandar Kulkarni | 0 | 15 |
| | | Hi All,
I have two tables as category and product
Category table as
categoryid categoryname
1 Sample
SeNa
|
11-10-2010 11:20 AM
Bob Barrows | 3 | 22 |
| | | We are planning to implement SQL Server 2005. The question I have is
that is it possible to have the Witness and Mirror on the same box
with 2...
Anand
|
11-03-2010 02:50 PM
Hugo Kornelis | 1 | 18 |
| | | I have been away from this for a long time and seem to have forgotten
much of which I learned. This syntax will always only ever return one
record...
colin spalding
|
11-03-2010 08:46 AM
Mark D Powell | 2 | 14 |
| | | Hi ,
I am a *SQL Server DBA* with over SEVEN years of IT experience with
over SIX years of experience in SQL Server Database...
s shah
|
11-02-2010 04:12 AM
Vicky Sadhu | 1 | 17 |
| | | Hi all,
I am using SQL Report Builder 3.0. I have an archived database on SQL
2005 and a live, production database on SQL 2008 (different...
joshsackett
|
11-01-2010 01:14 PM
joshsackett | 0 | 15 |
| | | I'm trying to write an SQL Query in SQL Server 2008 to update a date
field in my table. The field is a DATETIME field type. When a record
is...
Fiaola
|
10-30-2010 01:28 PM
Gert-Jan Strik | 2 | 14 |
| | | Hello all,
I've been wrestling with this for a while and hope someone can help.
I have 2 servers - one production, one test.
Both are Win 2003 R2...
Neil Cudd
|
10-29-2010 04:19 PM
Erland Sommarskog | 1 | 18 |
| | | for t-sql,
for stored procedure,
and for architect and internals,
I just got a set of this and want to spend some time to know deeper
about sql...
Hardy
|
10-29-2010 11:15 AM
Hardy | 0 | 17 |
| | | <http://www.executivesearch.tv/html/tv_java_jobs.html>
· Full software development lifecycle in the Internet space
· Enterprise-level hands-on...
Java-Jobs@NewYorkCity.CMS
|
10-28-2010 04:24 PM
Java-Jobs@NewYorkCity.CMS | 0 | 16 |
| | | I have a table having this structure:
idrecord
nation
value
What I have to get by a query is grouping records by nation, summing and
counting the...
Luciano \(DOC\)
|
10-28-2010 03:32 PM
Luciano \(DOC\) | 2 | 13 |
| | | Hello, do we need a license to install MS Management Studio (and other
related client tools) on workstations to connect to licensed SQL
Server...
Daoud
|
10-28-2010 08:14 AM
Hugo Kornelis | 1 | 17 |
| | | In part one of our mini blog series exploring cross-industry uses and
benefits of data analysis – Data analysis for the Retail Industry – we
explored...
JTP PR
|
10-28-2010 05:47 AM
JTP PR | 0 | 14 |
| | | I am doing a pivot where the sql is dynamic as I don't know the column names
until done.
But I am trying to get totals for my rows and totals for my...
tshad
|
10-27-2010 05:05 AM
Hugo Kornelis | 3 | 37 |
| | | I am using a pivot (dynamically) and am getting NULL results for some
values.
I want to change the NULLs to 0, but keep getting errors.
In the...
tshad
|
10-27-2010 04:59 AM
Hugo Kornelis | 5 | 17 |
| | | tshad (tfs (AT) dslextreme (DOT) com) writes:
Actually, it is worth to take a look it. For this particular problem, the
query is overly complicated,...
tshad
|
10-26-2010 02:18 AM
Erland Sommarskog | 5 | 19 |
| | | Here is a SQL statement that I am currently running:
update timecard set tudef1='JP0' where tudef5='JP' and tmatter in
(select mmatter from matter...
Richard
|
10-23-2010 02:02 PM
Erland Sommarskog | 1 | 23 |
| | | I have input data with date in epoch format (seconds since the
beginning...),
I am trying to convert it to visual representation and the local...
migurus
|
10-23-2010 04:09 AM
Erland Sommarskog | 1 | 16 |
| | | I can't figure this one out. On a Windows 2003 server we have a sql
2005 installation. A dtsx package gets data from a Oracle server. The
packge...
eteunisse
|
10-22-2010 05:08 AM
eteunisse | 0 | 24 |
| | | Hello,
I am getting the following error when I tried to connect with a user
logon through SQL Query Analyzer. And this user has Database...
xo
|
10-21-2010 05:11 PM
Erland Sommarskog | 2 | 17 |
| | | Hello everybody,
does anyone know what is the best practice for setting *.mdf autogrowth
parameter?
Database is now about 4GB big and shold be...
m
|
10-21-2010 05:04 PM
Erland Sommarskog | 3 | 16 |
| | | Hello:
I installed SQL Express on my system. I uninstalled and
reinstalled it a few times. Eventually, this hosed my system to some
extent, and...
Gene Wirchenko
|
10-21-2010 12:46 PM
Gene Wirchenko | 23 | 28 |
| | | (Part 1)
1. Mobile BI
Mobile BI refers to the capability of an organization to deliver
relevant and timely data to anyone, whenever they need it,...
JTP PR
|
10-20-2010 06:10 AM
JTP PR | 0 | 16 |
| | | On Oct 6, 7:09*pm, "Tools4SQL.net" <tools4... (AT) gmail (DOT) com> wrote:
i used t4s stored procedure generator. i generated around 6 SPs...
swati
|
10-20-2010 06:07 AM
Tools4SQL.net | 1 | 15 |
| | | Hello,
I'm building a Windows Forms App with VB.NET using SQL Server 2008 R2.
I've got a search form where users can search for records from the...
M Joomun
|
10-19-2010 04:58 PM
Erland Sommarskog | 5 | 17 |
| | | SQL 2005, my connection is under default READ COMMITED level.
I'd like to know whether locks are placed atomically when I say:
select T1.Col1,...
migurus
|
10-14-2010 02:14 AM
Erland Sommarskog | 1 | 19 |
| | | Using the code provided from MS in note How to transfer logins and
passwords between instances of SQL Server...
Mark D Powell
|
10-12-2010 01:21 PM
Mark D Powell | 0 | 30 |
| | | Hi my name is sonam, i am 20 i love to F*U*C*K only 50 $ per n8
At http://fingerchips.co.cc
Due to high sex security risks,i have hidden, that...
namitha
|
10-09-2010 01:24 AM
namitha | 0 | 17 |
