SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Function

  Hi   What is wrong in the below query. It is saying Target invalid column name . I have writte…

  jsshivalik

  1 replies

  8 years ago

  By: Jonathan AC Roberts

• Query

  Hi I have below code . I want record should be inserted only in tblTest if No_ value in test e…

  jsshivalik

  3 replies

  8 years ago

  By: C DBA Lockhart

• Issue in IF EXISTS

  Hi, We are facing a strange problem in our stp. The query is as below IF EXISTS (SELECT 1 FROM tbl_…

  saum70

  4 replies

  8 years ago

  By: saum70

• Index space

  Hi Guys  I just created an index ( with only 1 key column ) in testserver , index space…

  WhiteLotus

  4 replies

  8 years ago

  By: Jeff Moden

• How to do a basic loop in SQL

  Hi all,I have a need to read every record in a table and compare a name in that table to another na…

  barry.nielson

  14 replies

  8 years ago

  By: Jeff Moden

• Remote scan on local server

  Hi all, I was running the below query on our server (there are not linked/remote servers; this is t…

  scarr030

  1 replies

  8 years ago

  By: Eddie Wuerch

• Query

  Hi   I have below data  Table1 No DocumentNo Location Qty Pri…

  jsshivalik

  1 replies

  8 years ago

  By: laurie-789651

• relational calculus

  I'm solving a problem using tuple relational calculus ( TRC) in DBMS. ProblemFind the name of all t…

  spectra

  5 replies

  8 years ago

  By: spectra

• I am struggling with selecting specific information out of a strings

  So I have a feed from my sales order entry system.  the first section of the string is the com…

  randyetheridge

  17 replies

  8 years ago

  By: Jeff Moden

• Convert VBA to SQL Stored Procedure

  Hi all,I have been working with some VBA code to determine the percentage difference between two st…

  barry.nielson

  1 replies

  8 years ago

  By: DesNorton

• I need to parse and change the field identifier

  I need to join a table to another table. In order to do so I need to change "-" to a "." so my tabl…

  randyetheridge

  2 replies

  8 years ago

  By: randyetheridge

• How to get info on what a process/SPID is doing when you have DBO access only on SQL 2008R2

  I'm spoiled by having admin access to SQL Server so I'm at a loss on how to get SQL info (i,e, what…

  YSLGuru

  1 replies

  8 years ago

  By: Sue_H

• MS SQL SERVER slow query when using in Visual Studio

  I've been doing some timings on running stored procedures using VS and MS Server Mgmnt Studio. I ru…

  Tallboy

  1 replies

  8 years ago

  By: Grant Fritchey

• How to return multiple error values when validating multiple fields

  Hello,  I am working on a Stored Procedure to validate user registration for username, email, …

  rjjh78

  2 replies

  8 years ago

  By: rjjh78

• dbms query cost merge-sort

  Can anyone please explain the red marker line in above. I find it difficult to understand. This is …

  spectra

  1 replies

  8 years ago

  By: Jonathan AC Roberts