General

• Topics

  Started by

  Posts

  Last post

• SQL Server Registration

  i create a server group and new registration of another sql server how can i update the table to th…

  thermo_ll

  5 replies

  15 years, 5 months ago

  By: thermo_ll

• crystal report question

  I have a Crystal Report with the subreport and main report both use the same sql Storedprocedure. i…

  ron5

  6 replies

  15 years, 5 months ago

  By: ron5

• SQL in code vs. stored procedures

  So, way back when I was coding ASP.NET, I was in the habit of embedding SQL code (for example, "sel…

  Ray K

  18 replies

  15 years, 5 months ago

  By: Ewan Hampson

• Database query-SQL Server 2005

  Hi, I am learning SQL and could use help. I have an intranet web site (ASP.NET) with VB.NET as the …

  inliten

  4 replies

  15 years, 5 months ago

  By: JeevaIn

• "OR" statement in JOIN query

  I've got a LEFT OUTER JOIN I'm trying to do on a table, where I want to match on two different crit…

  Pete T-366679

  6 replies

  15 years, 5 months ago

  By: ChrisM@Work

• trimming trailing spaces and zeros from a string

  how would I trim trailing spaces and zeros from a string like this ? "345.2300" to get "345.23 and …

  dvamartin

  10 replies

  15 years, 5 months ago

  By: goinjm

• Need a SQL to select the last 60 days from current date

  I want to select the last 60 days transactions from current date. please help how to select?

  purushotham.k9

  13 replies

  15 years, 6 months ago

  By: Jeff Moden

• Inserting Next Row

  Will the following code work if I want to take new data from an existing table, insert it into anot…

  technette

  20 replies

  15 years, 6 months ago

  By: technette

• Order by with 0 at the bottom

  Hello everyone. I'm new to the forum and a beginner in SQL too... Hope someone have an answer for m…

  mymystify

  2 replies

  15 years, 6 months ago

  By: Dave Ballantyne

• Having a switch to disallow duplicate rows. Would it be a useful feature?

  I think Codd may have been the first to suggest that SQL ought to have a software setting that allo…

  sqlvogel

  4 replies

  15 years, 6 months ago

  By: RBarryYoung

• Cannot Insert duplicate key row

  Hi All I need some assistance with a cursor, I'm pulling data from another server/table and inserti…

  smthembu

  2 replies

  15 years, 6 months ago

  By: smthembu

• Simple and fast front end for user to execute a stored procedure after keying a variable

  Hi. Let me start by saying I am not an application programmer. I've also searched long an hard for…

  Robin_D

  6 replies

  15 years, 6 months ago

  By: Robin_D

• Business Days/Hours Calculations

  I am trying to calculate a follow up date based on business days. I also need to take into conside…

  SueStill

  6 replies

  15 years, 7 months ago

  By: QuestionBoy

• TOAD for SQL Server "Class not registered" Error

  I have downloaded the freeware TOAD for SQL Server from Quest's website.  When I run the execu…

  Lisa Tracy

  1 replies

  15 years, 7 months ago

  By: Mahmud Akhtar Qureshi

• sql server 2005 SP2 / Sp3

  I have a SQL Job that I run on SQL Server 2005 SP2 that fails with the following error: Executed as…

  Kevi322000

  3 replies

  15 years, 7 months ago

  By: Steve Jones - SSC Editor