Hi experts,
I have 2 similar tables that contain records. I wanna select all the record from the table 1 that are not contained on the table 2.
for istance
table 1
firstName
LastName
...
I am trying to combine to columns in a database table in the SQL statement using to populate a combobox box as show below
SELECT Code + ' ' + Description as sCode ........
I want to use ...
I am currently backing up my SQL Database onto a drive every night. The format of the file is
DATABASE_YYYYMMDDHHMM.bak
I keep three days worth of backups on the server itself.
What I wan...
I have three tables, 1. qcBasket which contains all the products of an order, 2. qcOrders which contains the header information for an order as well as payment info, and 3. qcUserTable that ho...
In this query am gettin multiple time the same records. .. i need to display only once
Table structure
foodtable
fid
fname
cid
hid
rid
citytable
cid
city
I was trying to add timestamp to the backup transaction log within a SSIS package
declare @BkpFile varchar(50)
SET @BkpFile = convert(varchar(50),getdate(),20) + '.trn'
SET @BkpFile = REP...
I have a simple query that I have a Alias field of NoticeDate and I would like ot filter this query and only produce results if the date equals today. The data in the NoticeDate column now ap...
I have two tables, the first stores a list of users (UsersAccounts) and the second stores every attempt the users have made to login to the system (UsersLoginAttempts). The tables have the fol...
I need to find out my current login information like what is my SPID. How can I find that out in the query analyzer? I am on SQL 2005.
Thanks
Hi,
We are using SQL Server 2005.
I urgently need to find a way to find out who created some tables in one of our databases. Is this possible without purchasing some third party tool?
...
I have access code that does the following
1) I run a Make table query filtering the data based on what the users enter and create table1
2) Table1 has all the fields I need to run the repo...
Hello,
I have this:
UPDATE MONEY SET Balance = Credit - Debit + "X"
Ok, that "X" is supposed to be the prior row. I need to calculate the Balance, which is the result of the previous b...
Good Day
Experts:
Started the day off with a little challenge that I need help with. I have data in Table "A" database "Production". I would like to do a Select * from A where ID = '5...
I'm used to Access make tables and I'm trying to figure out how I do the equivalent in SQL. I found the following example but is this really what I use if I just want a temporary table? With...
Hi,
I am concatenating 3 columns as One field
Select firstname + ' | ' + lastname + '| ' + convert(char(30),date) + ' | ' + Address1 as StudentInfo from Student
I want it as equal s...
How can I create a Main sub/report with sql server 2005 reporting services? For example Customers and orders in northwind database. One to many relationship
I have an issue where the servie account used for my SQL server installtion generating a large number of failure audits in the windows security event log. The details are as follows;
Event ...
I have created one report using sql server 2000 reporting services. It is running through sql server 2000 installed on my pc. I need to run the same report from my pc but with the database of ...
I have a search form that I'm stuck on. Let me try to explain. Here's an example. Lets say we have a Clients table, States table, and a ClientsStatesCrossReference table. So in the Clients...
Using SQL, I would like to return a recordset that has only distinct values from a secondary key column and only the largest / latest value from a primary key column: Any suggestions would be...
I have three tables I would like to join the data on (with the same table fields/datatypes) to a new table.
(Data in these 3 Tables were pulled from separate DB2 Databases)
I'm using a SELEC...
i just recently added a member table to my db. i also have a table called comment.
here are the columns they have:
member
---------------------
memberID
avatarURL
comments
------...
Already have a table T1 with a Month(nvarchar(255), Null) as one of the column(value = 08).
---- ------ --------- ----------
C1 C2 Month C4
----- ------ ------- ----------
1 ...
If I delete multiple records at once, is the delete trigger called for each record or is it called once and the deleted
table contain each deleted record?
I need to know because I am fetch...
Hello to te expert,
pls advise, efficient way to get the the last enterd recordID after insert into command.
Thank you,
