| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | This is SQL Server 2005, we have an application written in such a way
that all updates are done on all columns of a table subject to change,
even...
migurus
|
02-14-2011 04:59 PM
migurus  | 6 | 7 |
| | | Dear Fellow SQueaLers:
I am continuing with the textbook I have been studying off and
on. I found an interesting error in the date/time functions. ...
Gene Wirchenko
|
02-08-2011 03:36 PM
Gene Wirchenko | 3 | 4 |
| | | Hello
I am trying to append from Access to a SQL Server table - one record.
I am told the problem is because of the OLE datatype in the sql table.
We...
Tony
|
02-07-2011 06:09 PM
Erland Sommarskog | 1 | 2 |
| | | I'm looking for an answer to the question, if I use Aspnet_regsql.exe to reset the configuration to use a specific database (it got changed by some...
JoeyD
|
02-07-2011 05:25 PM
JoeyD | 0 | 1 |
| | | This paper has defined Social and Collaborative BI as the merging of
BI with social networking and Web 2.0 technologies.
Direct Link (No Email...
JTP PR
|
02-06-2011 06:06 PM
JTP PR | 0 | 1 |
| | | malargeetha20119159686702 (AT) gmail (DOT) com
geethu
|
02-02-2011 08:44 AM
geethu | 0 | 1 |
| | | I do all of my development work in a 64bit Windows 7 Virtual Machine
using VMWare. In order to test software in multiple versions of SQL
Server I...
Joe Cool
|
02-02-2011 03:13 AM
Erland Sommarskog | 4 | 5 |
| | | The phenomenal interest in social networking and Web 2.0 technologies
at the enterprise level is both unprecedented and growing rapidly.
But why? ...
JTP PR
|
01-27-2011 05:57 AM
JTP PR | 0 | 1 |
| | | Sorry if this is in an FAQ somewhere, but I can't seem to find an answer.
I have SQL Server 2008 "Developer Ed." (one instance) installed on a
Win7...
zmpmag3-msql@yahoo.com
|
01-25-2011 04:21 PM
zmpmag3-msql@yahoo.com | 10 | 11 |
| | | Hello,
when there is need to transfer full backup from one server to another
server, there is usually need to transfer logins too.
backup contains...
m
|
01-24-2011 04:35 PM
Erland Sommarskog | 7 | 8 |
| | | Hello,
from application owner point of view, there is an issue to protect database
logic and structure from stealing.
I'm pretty sure that was...
m
|
01-24-2011 04:13 AM
m | 2 | 3 |
| | | I have an SSIS package that uses the Row Count transformation task and puts
the row count into a variable called RowCnt.
I am passing the results to...
tshad
|
01-21-2011 04:00 PM
tshad | 0 | 1 |
| | | If I query the database select getdate I get 2010-12-23 09:08:17.330
but I have entries in the Error log like (User name and server...
Mark D Powell
|
01-20-2011 11:40 AM
Mark D Powell | 5 | 6 |
| | | Hi there,
I have to execute some .sql script files against a SQL Server 2008.
If I type in my command line:
the script is executed. If I put this...
Giulio Petrucci
|
01-19-2011 08:32 AM
Giulio Petrucci | 3 | 4 |
| | | Hello everybody,
does anybody know in case we have two instances of mssql 2008 installed on
the same machine do they need to work on different...
m
|
01-19-2011 03:37 AM
Erland Sommarskog | 5 | 6 |
| | | The major worldwide SMB community organization, SMB Nation, announced
late last year their new flagship event “MVP Nation” taking place
March 3rd-4th...
Tiara L
|
01-17-2011 07:22 PM
Tiara L | 0 | 1 |
| | | Why can I do:
SELECT PersonID = CASE WHEN o.ID IS NULL THEN o2.ID ELSE o.ID END
SELECT PersonID = CASE WHEN o.ID IS NOT NULL THEN o2.ID ELSE o.ID...
tshad
|
01-17-2011 03:44 AM
Erland Sommarskog | 10 | 11 |
| | | I have a view that returns rows from a table and would like to add an
extra row to the result set, but don't want to add that row in the
table. How...
emanning
|
01-14-2011 11:15 AM
emanning | 4 | 5 |
| | | Kaspersky Anti-Virus Personal 2011 11.0.2.556
Avira AntiVir Personal - Free Antivirus...
alagmy2030
|
01-13-2011 07:01 PM
alagmy2030 | 0 | 1 |
| | | Happy New Year:
It appears that IsDeterministic() and IsPrecise() return 1 only
when (necessary but not sufficient condition) WITH SCHEMABINDING...
Gene Wirchenko
|
01-10-2011 02:27 PM
Serge Rielau | 7 | 8 |
| | | I have data that has been captured in historian. I'm trying to create
a view that displays data captured via a Historian in a Pivot Table.
I'm...
mcolson
|
01-07-2011 05:43 PM
Erland Sommarskog | 2 | 3 |
| | |
peter kalvin
|
12-29-2010 10:15 PM
peter kalvin | 0 | 1 |
| | | Hello:
Suppose I have a statement like:
select
CustomerFirstName+' '+CustomerLastName as 'Name',
ClearedBalance Balance
from...
Gene Wirchenko
|
12-29-2010 01:23 AM
Gene Wirchenko | 4 | 5 |
| | | ANN: Database Workbench 4.1.0, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of...
Martijn Tonies
|
12-24-2010 07:09 AM
Martijn Tonies | 0 | 1 |
| | | Hello:
Is there any way to get the SET ROWCOUNT value?
No, I do not mean @@ROWCOUNT. Due to this name collision, I have
not found an answer in my...
Gene Wirchenko
|
12-24-2010 05:44 AM
Erland Sommarskog | 2 | 3 |
| | | Hello:
The text that I am studying is Robin Dewson's "Beginning SQL
Server 2008 Express for Developers From Novice to Professional"
published by...
Gene Wirchenko
|
12-20-2010 02:13 PM
Bob Barrows | 4 | 5 |
| | | I have a situation where I want to be able to send an email using
"execute msdb.dbo.sp_send_dbmail" when something has gone wrong with the
validation...
Travis Crow
|
12-17-2010 05:34 PM
Erland Sommarskog | 1 | 2 |
| | | On Thu, 16 Dec 2010 16:19:33 +0100, Toni Alfirevic wrote:
and the error returned is...
Msg 0, Level 11, State 0, Line 0
A severe error occurred...
Toni Alfirevic
|
12-17-2010 05:30 PM
Erland Sommarskog | 5 | 6 |
| | | 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 08:26 PM
tshad | 0 | 1 |
| | | 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 07:33 PM
tshad | 0 | 1 |
| | | 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 06:26 AM
JTP PR | 0 | 1 |
| | | 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 06:34 AM
JTP PR | 0 | 1 |
 | | 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 02:53 PM
tshad | 15 | 16 |
| | | 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 06:42 AM
JTP PR | 0 | 1 |
| | | 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 03:31 PM
Gene Wirchenko | 17 | 18 |
| | | 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 07:31 AM
Nitin Naresh | 0 | 1 |
| | | 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 06:00 AM
JTP PR | 0 | 1 |
| | | 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 06:44 PM
Hugo Kornelis | 1 | 2 |
| | | 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 07:14 AM
JTP PR | 0 | 1 |
| | | 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 05:11 AM
group | 0 | 1 |
| | | 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 07:36 AM
kavi | 0 | 1 |
| | | 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 09:55 AM
Bob Barrows | 5 | 6 |
| | | 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 03:43 PM
Rumeysa | 3 | 227 |
| | | 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 10:19 AM
DMSoft Technologies | 0 | 1 |
| | | 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 06:27 AM
JTP PR | 0 | 1 |
| | | 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 03:34 AM
Nitin Naresh | 0 | 1 |
| | | 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 11:47 AM
joe | 0 | 1 |
| | | 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 06:36 AM
........ | 0 | 1 |
| | | gives the same respect I give to them
http://tapurl.com/8fL0Lr
real cheating wives online for dating
hansehusen@ymail.com
|
11-12-2010 10:47 AM
hansehusen@ymail.com | 0 | 1 |
| | | 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 10:46 AM
hansehusen@ymail.com | 0 | 1 |
