| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I have 3 tables and would like to have all data exists on table 1 even
does not exist in table 2 and tbale 3 are there any way to have left
outer...
iccsi
|
10-07-2011 01:29 PM
iccsi  | 3 | 41 |
| | | Right now I'm using the query below to find missing numbers in a
sequence. I'd like to create a new query that returns the SUM of how
many are...
JMac
|
10-05-2011 09:23 AM
Daigoro | 4 | 38 |
| | | SQL Server Error 'There are no rows in the current fetch buffer'
We are storing/updateting binary data (~125kb) from a file into column
of type...
ThomasD
|
10-04-2011 04:21 PM
Erland Sommarskog | 3 | 54 |
| | | When I submit this SQL statement:
CREATE TYPE AcctList AS TABLE (acct_num varchar(25))
I get an error message:
Incorrect syntax near the keyword...
Joe
|
10-04-2011 12:13 PM
Jeroen Mostert | 1 | 53 |
| | | I have following 2 tables
table A
MyID, MyData
1 Data1
2 Data2
table B
iccsi
|
10-04-2011 02:16 AM
Erland Sommarskog | 1 | 43 |
| | | Joomla is a influential yet easy to use open source content management system to build websites. It is one of the most popular web site software...
Amy Thomas
|
10-03-2011 11:48 PM
Amy Thomas | 0 | 49 |
| | | How do I count a column that is NULL without CASE. I was looking at NULLIF
and ISNULL, they can't seem to do the job.
Thanks
Sorry about double...
Phil Hunt
|
10-03-2011 11:09 AM
Bob Barrows | 5 | 40 |
| | | Hi,
I want to get a list of table names in one server/database. Say I want
to get a list of table names in WorkDB database on ABC server. Could
you...
Michael
|
10-03-2011 04:45 AM
Tuan Anh Nguyen | 9 | 58 |
| | | How do I count a column that is NULL ?
Thanks
Phil Hunt
|
10-02-2011 12:52 PM
Hugo Kornelis | 1 | 49 |
| | | I use SQL Analyzer to create and alter the stored proedures for SQL
server 2000.
I just realized that the rights I give user role lost after I run...
iccsi
|
09-30-2011 04:34 PM
Erland Sommarskog | 1 | 35 |
| | | Table2 ID Status
789 4
789 4
1374
1374
1374
1940 15
Phil Hunt
|
09-30-2011 02:43 PM
Phil Hunt | 3 | 36 |
| | | in a folder I have 30+ .sql files containing scripts to modify a
database
I know that opening the script(s) will load them into sms where they
can be...
Roger
|
09-30-2011 04:43 AM
Hugo Kornelis | 4 | 32 |
| | | Hello,
I'm trying to export all the tables and stored procedures script to a
file, but it seems like Managament Studio (2008 R2 SP1) gets stuck...
Daigoro
|
09-29-2011 10:16 AM
Daigoro | 6 | 34 |
| | | I just migrate my MS Access applications to MS SQL Server 2000 backend
and still using MS Access as front end.
I just realized that there is an...
iccsi
|
09-28-2011 02:59 PM
Hugo Kornelis | 1 | 23 |
 | | Hi,
I have a stored procedure that executes multiple statements (including calls
to other procedures). I'd like to have @@ROWCOUNT to be set to a...
bogdan
|
09-23-2011 04:15 PM
Erland Sommarskog | 59 | 89 |
| | | I schedule a DTS package to transfer data over night.
The job failed.
I tried to execute the packages manually which works, but it fails
when I...
iccsi
|
09-22-2011 02:59 PM
iccsi | 0 | 19 |
| | | I have one table that I'm running the following query against to find
missing sequential numbers in the 'CSN' column.
SELECT start, stop
FROM ...
JMac
|
09-22-2011 10:56 AM
JMac | 7 | 21 |
| | | Hi everyone,
I have three tables:
Regions
-----------------------------------------------
RegionID | ParentRegionID |...
R. K. Wijayaratne
|
09-21-2011 08:49 PM
R. K. Wijayaratne | 5 | 10 |
| | | Does SSMS have express and standard version?
I wanted to access the server and create data transfer packages, it
seems that express version does not...
iccsi
|
09-20-2011 06:49 PM
Bob Barrows | 5 | 11 |
| | | Does SSMS have express and standard version?
I wanted to access the server and create data transfer packages, it
seems that express version does not...
iccsi
|
09-20-2011 01:25 PM
iccsi | 0 | 11 |
| | | Does SSMS have express and standard version?
I wanted to access the server and create data transfer packages, it
seems that express version does not...
iccsi
|
09-20-2011 01:25 PM
iccsi | 0 | 7 |
| | | Does SSMS have express and standard version?
I wanted to access the server and create data transfer packages, it
seems that express version does not...
iccsi
|
09-20-2011 01:25 PM
iccsi | 0 | 7 |
| | | Does SSMS have express and standard version?
I wanted to access the server and create data transfer packages, it
seems that express version does not...
iccsi
|
09-20-2011 01:25 PM
iccsi | 0 | 12 |
| | | Big Bertha Thing gyro
Cosmic Ray Series
Possible Real World System Constructs
http://www.bigberthathing.com/gyro.html
Access page JPG 12K...
Tony Lance
|
09-19-2011 01:27 PM
Tony Lance | 0 | 15 |
| | | Hello all,
I have a partitioned view (MYVIEW), containing the union of some dozen
tables. My goal is to be able to perform updates/deletes in chunks,...
Daigoro
|
09-19-2011 08:57 AM
Daigoro | 2 | 12 |
| | | I would like to scripts user's rights from one database using SQL
2000.
I got users and roles, but it does not include the rights for the
users and...
iccsi
|
09-17-2011 08:03 PM
iccsi | 4 | 12 |
| | | According to http://technet.microsoft.com/en-us/library/ms187526.aspx
,
"SQL Server does not align the index with the table if you specify...
M Bourgon
|
09-17-2011 11:53 AM
Erland Sommarskog | 2 | 14 |
| | | Howdy, all. Have been futzing with this, I swear I've done it before
but can't reproduce it now.
I have a non-partitioned table, and want to flip it...
M Bourgon
|
09-17-2011 05:06 AM
Erland Sommarskog | 1 | 11 |
| | | In Python and other dynamic languages, there is often the need to bind an ODBC SQL Parameter for a NULL value. In dynamic languages, there is a...
mkleehammer
|
09-14-2011 05:15 PM
Erland Sommarskog | 4 | 12 |
| | | I am thinking to migrate my database from SQL 2000 to 2008.
I just wander can I have Enterprise Manager and SQL Server Management
Studio at same...
iccsi
|
09-13-2011 02:34 PM
Erland Sommarskog | 1 | 11 |
| | | After doing nothing but SSIS packages for nearly a year, I must
confess that my T-SQL skills have gotten rusty. I'm trying to create a
function...
imani_technology_spam@yahoo.com
|
09-09-2011 11:40 AM
--CELKO-- | 3 | 13 |
| | | I have following data and would like to have differnet date range.
MyDate MyData
1/1/2011 A
1/5/2011 B
1/3/2011 A
1/3/2011 B
I have 2...
iccsi
|
09-06-2011 09:21 PM
iccsi | 2 | 12 |
| | | I’ve got a table, with an itemType field
The value of this field is 1-6, and I’ve created 6 views based on this
field, returning the same data set...
Roger
|
09-02-2011 04:15 PM
Hugo Kornelis | 3 | 11 |
| | | I have a developer with an app that inserts status messages into a
table with an identity columns and a datetime column. However as of
today rather...
david
|
09-01-2011 05:12 PM
Erland Sommarskog | 1 | 13 |
| | | Hello
I'm trying to solve the following problem:
I have a Job table and a JobActions table and would like to join both
and select the next action...
Klaus Fischer
|
08-25-2011 06:37 AM
Bob Barrows | 3 | 11 |
| | | For some reason, I need to modify and delete the index.
It takes a long time to process.
I just wonder may I delete an index or modify indexes?
If...
iccsi
|
08-24-2011 02:28 AM
Erland Sommarskog | 6 | 10 |
| | | If I have a table with the following data:
BookCode, DateRead, RatingGiven
0001, 2011/04/18, 60
0001, 2011/03/04, 80
0001, 2011/02/08, 65
0002,...
luisdev
|
08-24-2011 12:40 AM
luisdev | 9 | 10 |
| | | Big Bertha Thing Halfrail
Cosmic Ray Series
Possible Real World System Constructs
http://www.bigberthathing.com/halfrail.html
Access page JPG 22K...
Tony Lance
|
08-20-2011 03:05 PM
Tony Lance | 0 | 13 |
| | | I'm "analysing" an open source web application to understand how it
works so that I can contribute some code to it. When I want to see
what database...
luisdev
|
08-19-2011 04:44 PM
Erland Sommarskog | 3 | 13 |
| | | SQL Server 2005 express.
To automate the backup process, I am using SQLCMD along with windows
schedulers to do log/differential/full backup. At...
JJ
|
08-19-2011 02:05 PM
rpresser | 12 | 56 |
| | | Hi,
We are trying to send some attachements using 'sp_send_dbmail' and
have no luck. Finally found a fix , downloaded the hotfix thing. But
not...
Learner
|
08-18-2011 04:06 PM
Erland Sommarskog | 1 | 17 |
| | | I have a series of points and I wish to create lines in a geography column
from them. I can see how to create a point by supplying the...
Charles
|
08-17-2011 07:21 PM
Charles | 2 | 10 |
| | | I have a datetime field which contains data like following:
03:15:00 PM
04:25:00 PM
I have a query and would like to query on this field like...
iccsi
|
08-16-2011 04:03 PM
Erland Sommarskog | 2 | 10 |
| | | I need a string build from a table, I just wonder is the function best
choice?
the table is like following:
ID Data
1 Data1
2 Data2
3 ...
iccsi
|
08-16-2011 01:43 PM
iccsi | 2 | 11 |
| | | How do I convert a "YYYY/MM/DD" date into a unix timestamp? Using the
DATEDIFF function in the second INSERT below does not seem to work.
CREATE...
luisdev
|
08-15-2011 02:32 PM
luisdev | 2 | 12 |
| | | Hello,
I am trying to produce a daily stock balance statement.
I need 1st column to show all dates between @start and @end. Below I
have pasted the...
Andy
|
08-08-2011 02:38 PM
Andy | 3 | 9 |
| | | I have a customer table in 2 databases (say DBA and DBB) and both have
the same number of records in the table.
How can I set the Level on DBB to be...
fniles
|
08-08-2011 07:26 AM
Erland Sommarskog | 1 | 12 |
| | | Hello,
I am trying to make a query to populate a report in SSRS.
The report needs to show 1 row for every day between @start @end and show the...
Andy79
|
08-07-2011 04:50 AM
Andy79 | 0 | 13 |
| | | I want to call an oracle sp from my SQL2005 box. I have a linked server
configured with RPC , and my syntax so far is
Declare @V_Output...
Paul
|
08-06-2011 02:58 AM
Paul | 4 | 10 |
| | | I have table which has about 100 columns, and many of them are
nvarchar(4000). The database is SQL2005 (so, no sparsed columns).
The table is...
simon
|
08-05-2011 02:22 AM
Erland Sommarskog | 10 | 24 |
