Hello, I am scheduling a simple job to run a query. I want the result of that query written to a text file. When I am scheduling the job, in the...

Monica

07-09-2008 09:38 AM
Monica

I've spent a few hours researching the datetime comparison, and from what I understand, what I'm doing *should* be working... any help is...

Dan

07-07-2008 07:11 PM
Dan

Hi all, I'm trying to run a query that produces data from three tables, in essence these are Location, Category and BannerPeriod, They all have a...

GTN170777

07-05-2008 03:15 PM
Hugo Kornelis

Hi there Hopefully this will be an easy one for someone. I am using SQL Server 2005. I am based in the UK and our users are in the UK. We have...

Brian

06-26-2008 09:55 AM
Russell Fields

Good morning :) * Using QL Server 2005 I have created a stored procedure (first time I have done this). It worked fine when I only had 1 variable...

James Terrington

06-11-2008 01:01 PM
Russell Fields

Hi I wish to create a stored procedure that updates multiple tables. I have a table called User CREATE TABLE .( NULL, NULL, NULL, (20), ...

Robert Smith

06-10-2008 03:12 PM
Russell Fields

My C# Windows program does not recognize the COUNT command in a SQL query string using SQL Server 2005. I can use the command when I code the...

Parrot

06-03-2008 09:03 PM
Parrot

I have a mssql 2005 database dbTest with to tables tblOne and tblTwo. tblTwo.IndexID = tblOne.IndexID. tblOne and tblTwo has both got fields,...

Gert Albertse

06-02-2008 10:21 PM
Gert Albertse

Hi all, I have a table that looks like this: Acct SSN 1 5 1 7 1 10 2 20 2 55

MarkFrank

05-29-2008 04:14 PM
MarkFrank

I have run into this 2 or 3 times and have decided to post. Here is my most recent query: select distinct transportcode,freightforwarder from...

Stan

05-25-2008 11:16 PM
Nigel Rivett

SQL Server 2005. I have a view defined for a database. Part of the query is: SELECT dbo.GL7PROJECTS.PROJECTID AS JURISDICTION I have not problem...

Chaplain Doug

05-25-2008 11:09 PM
Nigel Rivett

SQL Server 2005. I want to do a query that will accomplish both a LIKE type search and an IN type search. I have a variable number of LIKE strings...

Chaplain Doug

05-25-2008 06:13 PM
Nigel Rivett

I am using a database with n tables in it. I have a set of field names with me. what I want is to find the names of the tables in which a...

Jatin Gulati

05-11-2008 05:23 PM
Hugo Kornelis

Hello, i have a table that has some informatio regarding an office building in it. It also has the building managers information in it. I want to...

Michael

05-11-2008 05:21 PM
Hugo Kornelis

As a background: 1) I am using SQL 2005 2) Reporting Services. In order to achieve certain report requirements I have created 2 VIEWS on the SQL...

James Terrington

05-06-2008 03:32 PM
Hugo Kornelis

HI Declare @a char(7) if the lenght of the inserted value in @a is less than 7. the zero's should be added on the left side to make it of lenght...

Muhammad Bilal

05-01-2008 02:38 PM
Russell Fields

I am trying to compact some of the views we have in our DB, I am turning 2 views into one, with the use of a subquery. The problem I get is that...

Access To Access

04-23-2008 02:21 PM
Hugo Kornelis

Good afternoon, I am trying to create a query. Underlying data in table is: Job No/Cost Type/$ J8000/1/3000 J8000/2/2000 J8000/2/5000 J8000/2/1000

James Terrington

04-23-2008 02:16 PM
Hugo Kornelis

Hi all, I have created a SQL query that gives me the following, but I want to build onto it: Project Manager/Job Name/Contract Revenue/Labour...

James Terrington

04-23-2008 02:13 PM
Hugo Kornelis

I apoligize in advance for a long explanation, and if this is the wrong place to post this question. Background: I have an antique mall whereby we...

SQL Brad

04-16-2008 10:02 PM
SQL Brad

I'm unable to install this update with the following error number 0x80092004. Please let me know how to debug/resolve this. Here's the summary text...

khanya

03-27-2008 03:34 PM
khanya

We have a SQL 2005 database that has the time stored as an integer. I'm assuming it is the seconds after midnight. Is there a function to...

Stan

01-23-2008 08:32 AM
Russell Fields

I have a table that has a Sales Tax Code and an Invoice Date (ex. 7/04/07) and another table that has the Sales Tax Code, Tax Rate, and Effective...

Queryless in SLC

01-09-2008 02:48 PM
Vishal Parkar

I am working on a report where the end user would like to say giving me data for quarter 1 of 2007,ect. The data in my table has the year and date...

Ryan Mcbee

12-07-2007 09:45 PM
Ryan Mcbee

Hello, I log all actions of the users in a table. Each day, I create this 'logtable'. It looks something like this: Tablename: 20071207 (for logs of...

Raf

12-07-2007 06:00 PM
Hugo Kornelis

How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?

DR

11-21-2007 03:42 PM
DR

I am working on creating a Report using SRS but first have to get the correct information out of my database with a query. What I am attempting to do...

Wayne

11-15-2007 05:56 PM
Hugo Kornelis

Hello, Setting parameter ranges for a query is very useful. How can I specify : begins with ...... and make that a parameter (in this case first 5...

Texas Tonie

11-15-2007 05:47 PM
Hugo Kornelis

I'm trying trying to build a crosstab query using a Case statement to count the number of records in one column with the DateDiff >=0 and the...

Geoff

11-15-2007 03:28 PM
Russell Fields

I am trying to write a query that returns all suppliers within a given range that either do not have any insurance (appear only in Suppliers table)...

Newbie

11-15-2007 10:48 AM
Anith Sen

Thank you in advance for any and all assistance. I am trying to do a comparison of 2 tables and I am expecting the result to be what ever is not in...

elittle

11-02-2007 12:02 PM
Russell Fields

I have a table that has the following three fields and values that I am trying to build a query on; Column name-FEDERAL, FICA1, FICA2 Values- 1 ...

Ryan Mcbee

10-30-2007 09:01 AM
Russell Fields

Note: I am using this to create a report with SRS I need to pull some data that could possibly be sitting in one of two tables. Table1 is the...

Matt M

10-26-2007 05:21 PM
Hugo Kornelis

Hi, I have a text column in a table and data stored in it contains formatted text (with carriage returns, tabs, and spaces). When I perform a select...

Tsheth

10-25-2007 02:58 PM
Hugo Kornelis

I am trying to build a query that will return what quarter the data is in. How would I begin to build this logic? In my table, all I have is a...

Ryan Mcbee

10-23-2007 10:18 AM
Ryan Mcbee

Im trying to figure out the best way and/or fastest way to Match some data comming in....example below the below is all the incomming information i...

analizer1

10-19-2007 02:39 PM
MikeJ

Hi, I have a Table with rows as below A 1 10 B 1 15 A 2 3 A 1 5 A 3 10

Sasikumar

10-17-2007 04:44 PM
Hugo Kornelis

I am writing a query in which I want to select a field and not have the trailing blank spaces. Here is my query: select employid, lastname + ','...

Ryan Mcbee

10-15-2007 01:51 PM
Russell Fields

We have a password protected split Access database on our company domain, this database contains a particular report that one of the company...

Peter

10-11-2007 05:13 PM
Peter

We have a stored procedure that removes old data from a very large (millions of rows) table and puts it into an archive table. It grabs the top 5000...

Gordon

10-09-2007 03:58 PM
Hugo Kornelis

I have a table (we'll call it table A) with two fields in it; one is an ID, and the other (named "State") currently only contains null values. I'd...

Dan

10-05-2007 08:57 AM
Russell Fields

I do I convert a field that is "smalldatetime" to "datetime"? I am doing a select statement from a table and need my output to...

Ryan Mcbee

09-24-2007 12:29 PM
Hugo Kornelis

Hi all, Is there a way to quickly run an sql query against all the tables in a database? or will I have to simply write a line for each table? I...

Gav

09-11-2007 02:52 AM
Gav

Hello, I have a table that lists my bank transactions. I have a uniqueid in the first field and several other fields....one of which is DATE.......

SQL Brad

09-10-2007 12:15 PM
Russell Fields

Hi, I have a query who returns different result for different user. This query is just a "SELECT" from a view (or a function), like this: Select *...

=?Utf-8?B?QW5odHE=?=

09-05-2007 01:59 PM
Russell Fields

Hi, what is the correct syntax to execute a query to a table on another SQL-Server-Instance. For example: dbo.table on Server1 with Instance2...

=?Utf-8?B?RmxvcmlhbiBMLg==?=

08-23-2007 05:16 PM
=?Utf-8?B?RmxvcmlhbiBMLg==?=

Hello and thanks for your efforts, I have a table with Part, MonthSold, ItemsSold i need to generate a view comparing this years sales to lastyears...

=?Utf-8?B?U0xJTVNISU0=?=

08-19-2007 11:02 AM
=?Utf-8?B?U0xJTVNISU0=?=

I think this should be easy, but I'm stuck. I have a datetime field with this format: mm/dd/yyyy. It looks exactly as that format when I opened the...

=?Utf-8?B?bHdpZGpheWE=?=

08-03-2007 02:01 PM
Hugo Kornelis

We are currently running SQL version 6.5 and are planning to install another application that requires SQL 2000 to be installed on the same server....

=?Utf-8?B?V2lsc29u?=

07-30-2007 10:09 AM
Russell Fields

Hi All I am trying to write a SQL statement to use in an automated process which will run on a SQL 2005 server and backup a remote database from...

Jojamie

07-17-2007 08:47 AM
JPD