| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | On Jan 31, 5:03*pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
Hi Erland and Bob,
Thanks both a bundle for your responses. Looks...
pbd22
|
02-01-2012 05:54 PM
Erland Sommarskog  | 2 | 4 |
| | | I know it is legacy database, but i have been looking how can i get
Input data
Col1, col2
1, 'nebraska'
1, 'boston'
2, 'new york'
3,...
bradbury9
|
02-01-2012 09:27 AM
bradbury9 | 2 | 3 |
| | | I have SQL Server 2008
If I look in the Sql Server Configuration Manager I can see that I have two
instances of SQL server.
These are :
SQL...
Tony
|
11-23-2011 05:50 AM
Tony | 0 | 2 |
| | | Hello!
I just wonder about this Windows authentication. If I connect to SQLServer
by using Microsoft SQL Management Studio I can see that under...
Tony
|
11-23-2011 04:51 AM
Tony | 0 | 1 |
| | | Dear Sir/Madam
I have a MySQL database with lot of tables .
and I want to disable all the constraints from all the table at the
same time .How can i...
harish saharan
|
11-23-2011 03:56 AM
Erland Sommarskog | 1 | 2 |
| | | Dear Sir/Madam
I have a MySQL database with lot of tables .
and I want to disable all the constraints from all the table at the
same time .How can i...
harish saharan
|
11-23-2011 02:51 AM
harish saharan | 0 | 1 |
| | | Hello!
I have SQL Server 2008
If I look in the Sql Server Configuration Manager I can see that I have two
instances of SQL server.
These are :
SQL...
Tony
|
11-18-2011 09:58 AM
Tony | 4 | 5 |
| | | What are these IP addresses in the properties of TCP/IP in configuration
Manager of SQL Server 2005 Standard? How do I know what to type here?
The...
sql464
|
11-18-2011 06:15 AM
Erland Sommarskog | 3 | 4 |
| | | Hello!
I have a full sql server 2008 installed on vista but I just want to know if
this installation is a named instance or
a default instance of...
Tony
|
11-15-2011 02:43 PM
Bob Barrows | 1 | 2 |
| | | Hello!
I do the following.
1.Right click on Data Connection in Server Explorer and choose Add
connection
2. In the Data Source I select Microsoft...
Tony
|
11-15-2011 09:15 AM
Bob Barrows | 3 | 4 |
| | | i have two tables.
one table - tbl_attempted issue has number field with the following
values.
number field record values - 1, 3, 4, 5
the other...
John Kim
|
11-11-2011 05:40 PM
Erland Sommarskog | 2 | 3 |
| | | I run online based study guides program. I email out new issues every
week, mon / wed / friday.
I have new sign ups every week. and each of these...
John Kim
|
11-11-2011 08:20 AM
John Kim | 3 | 4 |
| | | Hi,
I have a problem with one of my queries which is never finished within
the timout. I've tried to optimize my query with indizes but...
Joachim082
|
11-11-2011 03:34 AM
Erland Sommarskog | 1 | 2 |
| | | I run online based study guides program. I email out new issues every
week, mon / wed / friday.
I have new sign ups every week. and each of these...
John Kim
|
11-10-2011 08:48 AM
John Kim | 2 | 3 |
| | | Hello,
I am using MS SQL server 2008 on windows 7 platform.
I have tried every method available on internet to enable the SQL
server intellisence(...
arvind
|
11-10-2011 07:32 AM
Erland Sommarskog | 4 | 5 |
| | | I run online based study guides program. I email out new issues every
week, mon / wed / friday.
I have new sign ups every week. and each of these...
John Kim
|
11-10-2011 03:45 AM
John Kim | 0 | 1 |
| | | Hello,
I am using MS SQL server 2008 on windows 7 platform.
I have tried every method available on internet to enable the SQL
server intellisence(...
arvind
|
11-08-2011 10:41 AM
arvind | 0 | 1 |
| | | Now you can pass IT Exam with high scores
Hi friends,
Now you can pass your IT certification exam in first attempt with high
scores by using the...
miss salwa
|
11-04-2011 01:16 PM
miss salwa | 0 | 1 |
| | | I have a two tables, Stock and Bin, with Stock having one to Bin's many. Stock has fields Number and Desc1 and Bin has Number, Warehouse, and Units....
srgebauer@gmail.com
|
11-03-2011 03:31 PM
srgebauer@gmail.com | 2 | 3 |
| | | Hi!
Has anyone worked with Analysis Service?
http://msdn.microsoft.com/us-en/library/ms167487.aspx
I see this tutorial, can anyone help me?
s
Bruno Costa
|
11-03-2011 11:49 AM
Bruno Costa | 0 | 1 |
| | | I just recently started looking into MS SQL Server 2005/8
replication. We have a vendor product where the data is purged at
time N. The vendor...
Mark D Powell
|
11-02-2011 10:09 AM
Erland Sommarskog | 6 | 7 |
| | | Transact SQL apparently supports one-sided critera,
such as the "a.SEL=15" in (1) below. in the join
expression. I would expect that both (1) and...
Fred.
|
11-02-2011 09:10 AM
Bob Barrows | 2 | 3 |
| | | I have and SPROC that calls the below via a cursor so parameters can
be based from a table.
When in run it in SSMS it gives the desired results....
JAW
|
11-01-2011 04:17 PM
Erland Sommarskog | 4 | 5 |
| | | Hello ALL
It gives me immense pleasure to announce new batch for Linux. This
shall lead to certification RHCE (Red Hat Certified Engineer)
We shall...
umesh
|
10-31-2011 09:53 AM
umesh | 0 | 1 |
| | | A client provided me with a web site that I do not need any login or
anything, I just visit the http sit and ot will open the dialogbox to
save or...
Spero
|
10-31-2011 03:14 AM
Erland Sommarskog | 1 | 2 |
| | | I am trying to get the utl_raw.cast_from_number function to pass data to
a 3rd party application. I am kind of confused as to how it gets
converted...
NewtoOrcl
|
10-27-2011 05:41 PM
NewtoOrcl | 3 | 4 |
| | | Any idea what kind of obfuscation MS supports for SQL deployments for
the current generation of SQL Server (2008)?
I am interested in developing a...
Mad Scientist Jr
|
10-26-2011 05:57 PM
Erland Sommarskog | 1 | 2 |
| | | Top research and analyst firm, Gartner, has added fuel to the argument
that Mobile Business Intelligence (BI) is set to become the primary
method for...
Jan
|
10-23-2011 08:51 AM
Jan | 0 | 1 |
| | | Hi,
Good day.
We are looking for SQL Server Lead Developer- Charlotte, NC – 6+
Months Contract Position
US Citizen and Green Card holders...
Vikram Pandian
|
10-19-2011 03:02 PM
Vikram Pandian | 0 | 1 |
| | | Yellowfin, the leader in easy-to-use Business Intelligence (BI), has
been recognized in Gartner’s annual Who’s Who in Mobile BI report. The
2011...
Jan
|
10-18-2011 08:39 AM
Jan | 0 | 1 |
| | | Hello all
Let me take this opportunity to Introduce myself as Umesh Jadhav Open
Source Technology Consultant and running Spark technology...
umesh
|
10-14-2011 04:11 AM
umesh | 0 | 1 |
| | | Hi all
Im trying to consume a webservice with SSIS 2005 and Ive hit a bit of
a hurdle.
After supplying the WSDL and choosing the service on the...
Simon Scott
|
10-14-2011 03:45 AM
Simon Scott | 3 | 4 |
| | | reservastrancoso (AT) gmail (DOT) com
reservastrancoso @ gmail.com
(reservastrancoso (AT) gmail (DOT) com)
Pousadas em Trancoso, agencia virtual em...
pousadas trancoso reservas bahia
|
10-13-2011 12:26 AM
pousadas trancoso reservas bahia | 0 | 1 |
| | | Dear SQLers:
I have a Windows 7 box. I installed Denali on it, and I just
installed SQL Server 2008 Express SP 3, presumably 64-bit thoughI was
not...
Gene Wirchenko
|
10-09-2011 11:00 PM
Gene Wirchenko | 2 | 3 |
| | | Article Link
http://www.yellowfinbi.com/YFCommunityNews-Benefits-of-Mobile-Business-Intelligence-Part-Two-108062
Brief
Aberdeen Group on Mobile...
Jan
|
10-06-2011 06:43 AM
Jan | 0 | 1 |
| | | I try to generall supply real DDL and sample data, but the problem I
have only shows up in certain cases, with SELECTS against very large
tables and...
bill
|
10-05-2011 02:23 AM
bill | 6 | 7 |
| | | I'm new to the spatial functionality of MS SQL Server 2008.
I have a table tblPoints with about 3000 point coorodinates and
another table tblLines...
Harry B.
|
10-04-2011 05:06 PM
Erland Sommarskog | 1 | 2 |
| | | In the studio query design, I can join any tables up. Now I understand Inner
Join is associative. But if there is an Outer join in the mix, how does...
Phil Hunt
|
10-03-2011 05:34 PM
Erland Sommarskog | 1 | 2 |
| | | Hi All,
i need to declare and set a global variable that is specific to the
session, each time app logs in to the sqlserver.
for instance,
i have...
Ender KaradaÄŸ
|
10-03-2011 05:14 PM
Erland Sommarskog | 8 | 9 |
| | | 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 12:09 PM
Bob Barrows | 5 | 6 |
| | | My Question is now:
1) Does a SELECT Statement ALWAYS return a result set?
2) Is there a way I can tell by looking at the code which...
Tony C.
|
10-02-2011 04:31 PM
Tony C. | 8 | 9 |
| | | How do I count a column that is NULL ?
Thanks
Phil Hunt
|
10-02-2011 01:52 PM
Hugo Kornelis | 1 | 2 |
| | | Hi,
I'm trying to understand a large storedprocedure with multiple
select statments like around 15 or so. I'm a little new to multiple
result...
Tony C.
|
10-02-2011 09:29 AM
Tony C. | 2 | 3 |
| | | Table2 ID Status
789 4
789 4
1374
1374
1374
1940 15
Phil Hunt
|
09-30-2011 03:43 PM
Phil Hunt | 3 | 4 |
| | | I am working on an SPROC that I want to pass dynamic SQL to purge
tables. Using SELECT to ...
JAW
|
09-30-2011 03:33 PM
Hugo Kornelis | 1 | 2 |
| | | Good Morning All
I'm trying to create a simple connection string to a SQL 2000 server using
the old "SQL Server" driver - not the Native Client, but...
Matthew Wells
|
09-29-2011 05:13 PM
Erland Sommarskog | 3 | 4 |
| | | The integration of Web 2.0 and social media style features into
Business Intelligence (BI) applications – and other corporate
technologies and...
Jan
|
09-29-2011 07:39 AM
Jan | 0 | 1 |
| | | I will be creating a web application where upload and modification of
documents will be an important part of the application. Specifically,
users...
Bill E. Hollywood, FL
|
09-27-2011 06:01 PM
Bill E. Hollywood, FL | 4 | 5 |
| | | I would like to upgrade a desktop from Windows 7 to Server 2008 and
host SQL instances on it in my home Workgroup network. But before I do
that, I am...
Joe Cool
|
09-25-2011 07:14 PM
Joe Cool | 3 | 4 |
| | | Before I even get started, let me apologize for the length of this post. In
two sentences - I'm asking if someone wants to give some (free) counsel...
Kurt Dicus
|
09-20-2011 04:11 AM
Kurt Dicus | 0 | 1 |
