Hello I'm building an SSIS package from home to be deployed at an office. The package is a simple Access to SQL Server migration. I was building...

Matthew Wells

01-04-2010 08:13 AM
Matthew Wells

Does anyone know that how I can compare structures of databases to see the differences? Thanks

Faisal

12-31-2009 08:52 AM
Faisal

Hello! I wrote a sql query I want to run in MS SQL Server: I got the errror "Incorrect syntax near the keyword GROUP, and I don`t know what...

N.M.

12-22-2009 05:54 PM
Erland Sommarskog

Hi : Recently I made a project using Visual Studio, and I save this like myproject.rdl, but when I open this file I only see xml data like...

valdemirs

12-22-2009 07:08 AM
BrianR

Hi: Please, is there any way to summarize this sql command below to show me only one data per day ? Actually it´s show me 24 data ( one per...

valdemirs

12-21-2009 04:59 PM
Erland Sommarskog

I want to convert this sample string: "Some like <X> better than <Y>. I like <Y> better than <X>, but my daughter prefers <X>." To this one: "Some...

bill

12-19-2009 12:13 AM
bill

I have an SP with a bunch of table variables used extensively throughout. Is there any reason to declare these as User Defined Table Type (new in...

adag617

12-18-2009 05:18 PM
Erland Sommarskog

How do I add the icode to this query to get the percentage of calls received / calls offered? select sum(isnull(,0)) as CO, sum(isnull(,0)) as...

JJ297

12-16-2009 08:36 AM
JJ297

Hi. I am inserting data into 3 tables. Before I insert, I am dropping some of the constrains. After inserting the data I added dropped constrains...

hayko98

12-15-2009 09:15 PM
--CELKO--

Hi, I have a table having values like below : col1,col2,col3,col4 a, b, c, d a, b, c, e a, b, c, f I need the output as follows :

raja

12-14-2009 10:24 AM
Plamen Ratchev

Hi friends need help for the following I m using SQL 2000 What I want to do is I want to create a single Text File containg data from 2 tables using...

chintu4uin@gmail.com

12-14-2009 03:46 AM
chintu4uin@gmail.com

Over the last couple of days, I have tried lots of ways to generate sequential numbers within a user defined function, including a stored proc to...

phdate

12-12-2009 03:36 PM
Erland Sommarskog

Hello everybody. I need help with my stats report.I have following query . DECLARE @DateFrom DATETIME; DECLARE @DateTo DATETIME; DECLARE @Provider...

hayko98

12-09-2009 04:40 PM
Hugo Kornelis

From SQL 2000 linked to a Oracle 10g database. Is there a setting on the SQL Server side that will limit the number of connections to the linked...

Raziq Shekha

12-09-2009 06:37 AM
Erland Sommarskog

The Yellowfin BI team have produced a new paper on "Business Intelligence on Mobile devices". Anonymous Download Link...

JTP PR

12-08-2009 06:27 AM
JTP PR

Hallo Experten, ich bekomme regelmäßig MS-SQL-Server Datenbanken zugeschickt und vermute, dass diese manchmal vor dem Kopieren nicht...

Tellie

12-06-2009 06:06 AM
Erland Sommarskog

Assume I have two databases, call them 'A' and 'B' running in the same instance of SQL Server 2008. I want to lock down 'A' so that no one, not even...

bill

12-04-2009 05:33 PM
Erland Sommarskog

why in gods name doesnt this simple sql calculation not work in a view 98/912500 = 0.0001073972603 if I do a simple view with the following...

NZDeveloper

12-03-2009 09:52 PM
Plamen Ratchev

I don't quite understand the expected behavior of the in operator when used with a list that contains the null value. The following is some short...

S.S.

12-02-2009 08:35 PM
Plamen Ratchev

Hi, I'd like to move to a full/differential backup system on our SQL servers; we currently just take full backups to disk. Before I go ahead and...

Jimbo

12-02-2009 05:41 PM
Erland Sommarskog

I have had SQL Server 2005 Express installed on another system and it appeared when running the Data source configuration wizard. Now, with 2008, it...

javelin

12-02-2009 05:38 PM
Erland Sommarskog

Plamen thanks again for your help with this query: DECLARE @listCol VARCHAR(2000) SELECT @listCol = STUFF(( SELECT DISTINCT '],,'; DECLARE @sql...

JJ297

12-02-2009 01:11 PM
JJ297

Following query ,emits error SELECT TOP 1000 total_worker_time/execution_count AS , deqp.dbid,deqp.objectid,deqp.number,deqp.encrypted FROM...

M A Srinivas

11-30-2009 05:15 PM
Erland Sommarskog

Don't want to start a long-winded discussion, just seeking some general views. . . I was trained in SQL years ago and was encouraged to use...

gargoyle60

11-29-2009 12:38 PM
--CELKO--

Just to be sure: Is it possible to login from a _remote_ machine to SQL Server using Trusted Connection _without_ a Active Directory account? The...

jh

11-26-2009 05:28 PM
Erland Sommarskog

On Nov 25, 5:34*pm, Dave <djohanns... (AT) gmail (DOT) com> wrote: are you importing data? you can do this from a data flow task and in the OLE DB...

Alen Teplitsky

11-25-2009 09:10 PM
Dave

Hey there, I need to do a lookup within SSIS, however I need to be able to reach across / join to two disparate servers / databases in my...

Dave

11-25-2009 05:34 PM
Dave

This is the error I am getting: Connectivity error: Conversion failed when converting the varchar value '4/24/' to data type int. From...

Peggy Mall

11-25-2009 04:07 AM
Andrew Morton

SQL 2000 under W2K I don't know how to deal with reptetitive results from self-join, any pointers would be appreciated. I have an order...

migurus

11-24-2009 09:43 AM
Plamen Ratchev

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...

Mia

11-23-2009 01:55 PM
Mia

Sql server 2008. it's said it's applicable without restarting the instance. but I just cannot find a way to change the password in the configuration...

Hardy

11-23-2009 09:25 AM
Plamen Ratchev

Hi I'm running SQL-server 2005, and when I try to backup, I don't see any networkdrive, only C: is available. Any suggestions ? Tanx in advance ! D

Daedalus

11-23-2009 06:51 AM
BrianR

Philippines, November 13, 2009 – leading Business intelligence (BI) firm, Yellowfin, today announced details of its exclusive...

JTP PR

11-18-2009 04:37 AM
JTP PR

Hi Friends, I have one question about bind variable cause different execution plan. When I run the query without bind variable, and hard -...

lsllcm

11-16-2009 03:45 PM
Erland Sommarskog

I'm back again and need help pivoting a table using weeks. This is what I have thus far: SELECT * FROM (SELECT doc, totovrSDW,...

JJ297

11-12-2009 02:15 PM
JJ297

Hi, I need to find records where a text (and/or varchar) field contains extended characters. If I knew particular extended characters, I could do...

HumanJHawkins

11-12-2009 01:37 PM
HumanJHawkins

How do I update a new column in a table with data from a temp table Table with added field errormsg Table1 Name char(50) clientkey...

amj1020

11-11-2009 01:17 PM
Plamen Ratchev

In a recent article in Computerworld, Monash University lecturer, Peter O’Donnell gave his opinion that; BI solutions are too sexy, contributing to...

JTP PR

11-11-2009 05:56 AM
JTP PR

Hi, I'm in the process of moving our database from SQL Server 2000 to a new server running SQL Server 2008. During the transition, I need to EXEC...

Guillaume Filion

11-11-2009 03:07 AM
Erland Sommarskog

I am trying to create new table.APPUSER_ID has AppUserPerm_AppUser_fk and there is NONCLUSTERED INDEX .What is the correct syntax to put these two...

hayko98

11-10-2009 09:55 PM
Plamen Ratchev

Hi, This is Deepthi from PRG Group Inc, based in Piscataway, NJ PRG Group Inc, provide Consulting Services, Professional Services and Managed...

Deepthi Raj

11-10-2009 05:14 PM
Deepthi Raj

Hi, I am developing an application which needs to backup data between SQL Express 2005 and SQL Server 2008. My client runs with an installation of...

auspicious

11-10-2009 08:06 AM
Plamen Ratchev

Hi All, We've written a number of (I think!) handy tools over the past few months which are available from here: http://www.sqlsoft.co.uk/ Newly...

Will

11-09-2009 05:33 PM
Will

Hi, SQL 2005 Enterprise Edition (SP2) I'm having trouble running a SQL script generated via the SQL 2005 Profiler. I've set up a very simple...

Jimbo

11-08-2009 01:49 PM
Jimbo

I have a table having classes start time and duration. So for example Create Table MyClasses ( ClassName nvarchar(15), StartTime...

Modern Benoni

11-06-2009 08:25 PM
Plamen Ratchev

QUESTON # 1 ---------------------- I'm confused about the SQL collation, what is it actually for?. I created a new database and later checked my SQL...

Althaf

11-06-2009 06:35 PM
Erland Sommarskog

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tools: " Database Workbench 3.4.2...

Martijn Tonies

11-06-2009 08:56 AM
Martijn Tonies

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

Itamar

11-06-2009 06:17 AM
Itamar

Hello, this is my first post and I looked for the newsgroup rules, but didn't find them. How can I find the rules for this group or any usenet group...

Josh Pearce

11-05-2009 11:02 PM
Josh Pearce

One solution I used was a look up tale with one DATE column and a bunch of string columns to hold various "local dialect" dates. Scrub up the raw...

--CELKO--

11-04-2009 03:56 PM
Hugo Kornelis