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 06:52 AM
Mandar Kulkarni

Hi All, I have two tables as category and product Category table as categoryid categoryname 1 Sample

SeNa

11-10-2010 12:20 PM
Bob Barrows

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 03:50 PM
Hugo Kornelis

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 09:46 AM
Mark D Powell

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 05:12 AM
Vicky Sadhu

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 02:14 PM
joshsackett

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 02:28 PM
Gert-Jan Strik

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 05:19 PM
Erland Sommarskog

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 12:15 PM
Hardy

<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 05:24 PM
Java-Jobs@NewYorkCity.CMS

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 04:32 PM
Luciano \(DOC\)

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 09:14 AM
Hugo Kornelis

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 06:47 AM
JTP PR

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 06:05 AM
Hugo Kornelis

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 05:59 AM
Hugo Kornelis

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 03:18 AM
Erland Sommarskog

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 03:02 PM
Erland Sommarskog

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 05:09 AM
Erland Sommarskog

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 06:08 AM
eteunisse

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 06:11 PM
Erland Sommarskog

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 06:04 PM
Erland Sommarskog

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 01:46 PM
Gene Wirchenko

(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 07:10 AM
JTP PR

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 07:07 AM
Tools4SQL.net

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 05:58 PM
Erland Sommarskog

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 03:14 AM
Erland Sommarskog

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 02:21 PM
Mark D Powell

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 02:24 AM
namitha

This is what I'm need to get: To get the Pending Count of COSSN I need to add the following... 1) Use T16pendall table to Count (COSSN),...

JJ297

10-08-2010 05:48 PM
Erland Sommarskog

Can someone tell me how much data can I store in a colume defined as Varchar(max). I am using SQL 2008. Thanks

Phil Hunt

10-08-2010 04:30 PM
Phil Hunt

Is the Studio Manager extensible? That is, can I write a program and "embed" it in the Manager somehow? This is what I have in mind. I want a...

Dom

10-03-2010 06:36 AM
Erland Sommarskog

Hi, I'm not sure whether this is the right group to ask ... please advise which on if not. I have a small Perl application that uses Win32::ODBC to...

Gerd Brix

10-01-2010 05:28 PM
Erland Sommarskog

Hello! I`d like to create cluster passive/active. But i dont know what about storage how to enable "disk strage" on passive site whe active goes...

hehehe

10-01-2010 07:49 AM
hehehe

Hi, I have one table with records of internet activity, one hit per row. I need to generate a report of the top 10 websites of the top 10 users on...

dontinou

09-29-2010 04:54 PM
--CELKO--

When i open up the DTS Designer i get this error message "The specified module could not be found" in one of my DTS packages. Its the Oracle...

Mitchell

09-27-2010 07:53 PM
Mitchell

Hi, I am not sure whether I am posting to the correct group; If not, please tell me which groups are better. My experience has been mainly with...

basis_consultant@hotmail.com

09-23-2010 04:40 PM
Erland Sommarskog

Yellowfin Business Intelligence have released a whitepaper on measuring data quality for successfull master data management. Download Link (No Email...

JTP PR

09-22-2010 09:04 AM
JTP PR

Yellowfin Business Intelligence have released a whitepaper detailing their technical approach to a SAAS integration and deployment. Download Link...

JTP PR

09-21-2010 07:38 AM
JTP PR

I have a stored procedure that's providing data to a different front ends (Access, VB.Net and a Postgress-based web system) for reporting. The report...

Richard Sherratt

09-21-2010 03:15 AM
Richard Sherratt

I was always told that the order of execution in T-SQL was FROM, SELECT, WHERE. This turns out to be important if you want to avoid certain errors,...

Dom

09-19-2010 04:32 PM
Dom

I have built a VB application that reads values from SQL server and uses one of the selected values to send a soap request. The application then...

Spero

09-18-2010 08:53 PM
Richard Maher

Hi, I have a linked server to an Oracle db and I want to disable a trigger before I update a record. I am able to select data from the table using...

Mounilk

09-16-2010 03:30 AM
Erland Sommarskog

Hello everyone, I am looking for a way to store the runtimes of reports or SQL statements, for trend watching. What i need is some identifier...

Helma

09-14-2010 07:00 AM
Helma

Hello - I am trying to install SQL 2005 (64-bit) server but I did not see that server components when I did the install with the downloaded...

xo

09-13-2010 04:50 PM
xo

BACKGROUND: I am using MS SQL 2000 in case that matters. I work with a fairly large database that tracks product information. There are currently...

Halgar

09-13-2010 04:19 PM
Erland Sommarskog

I have both VS2k5 and VS2k8. SQL2008 has the reporting services and the data. I must modify existing rdl files that were created in VS2k5 and...

Jake Campbell

09-12-2010 12:06 PM
Jake Campbell

Direct Link --> http://bit.ly/ceUCbQ (No Email Required) Alternative Link -->...

JTP PR

09-10-2010 07:39 AM
JTP PR

Hi, hope someone can help. Although I have been using SQL for about 10 years this problem has really got me stumped. I am using SQL Server 2000. I...

Jane TT

09-09-2010 05:21 PM
Erland Sommarskog

Does a good reference or tutorial exist for this topic?? We only need READ access from SQL 2008 to the VFP tables -- various select queries for...

tom12010

09-09-2010 02:15 PM
tom12010

Sr Developer -Data Base Analyst Location: SFO 3+ months 7-8 Years of Exp in Oracle SQL, PL/SQL please send your updated Resume to jobs (AT)...

Maple MRS

09-08-2010 02:09 PM
Maple MRS