SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Help on translating to TSQL

  I need help translating this code into T-SQL Code: * * PARAMETERS: * tcAction = "E"ncrypt/"D"e…

  mike 57299

  4 replies

  15 years, 5 months ago

  By: Toby White

• how to get only latest date and other columns from table

  Hi, Table id name date 123 a 2/3/2010 124 b …

  shyam.oec

  2 replies

  15 years, 5 months ago

  By: Koncentrix

• CTE Issue

  I'm trying to create a query that utilizes a CTE. Here is what I have so far: use cu_hds; With Dia…

  bwagner 90365

  7 replies

  15 years, 5 months ago

  By: SQLRNNR

• Splitting a single row into 2

  I have written an SQL that outputs a whole lot of data into a rather unwieldy format. As it stands…

  hmink 90250

  9 replies

  15 years, 5 months ago

  By: hmink 90250

• format rtf column into plain text

  Hi, is there a way to format an RTF column in my database into plain text. kind regards, Bryan

  bryan van ritter

  6 replies

  15 years, 5 months ago

  By: bryan van ritter

• Subtract one result set from another

  Hi all, Very newbie seeking assistance.... I have a table with a list of employees and a table with…

  JoelyB

  9 replies

  15 years, 5 months ago

  By: JoelyB

• Access Last function to SQL Server

  Okay... I'm stuck. 🙁 Does anyone know how to get around / convert an Access Last function to SQL Se…

  stewsterl

  3 replies

  15 years, 5 months ago

  By: Paul White

• A thank you for all who assisted me today and in the past weeks

  I really appreciate this Forum. Thank you again for your help! Kind regards, RonKin:-)

  RonKin

  2 replies

  15 years, 5 months ago

  By: SQLRNNR

• How do I tell if a server is cluster aware?

  I do not have a SQL Server Test Cluster. I have no one where I work to assist me. I am currently r…

  RonKin

  8 replies

  15 years, 5 months ago

  By: RonKin

• Instance Name on SQL Server 2005 Setup

  When I get to Instance Name on SQL Server 2005 Setup and choose Named Instance; SQLCLUSTER2 and cli…

  RonKin

  3 replies

  15 years, 5 months ago

  By: eko indriyawan

• how to code if not exists(then set identity and then insert

  Hi, I am very new to SQL SErver. Have been coding ORacle and want some help with this. What I am ba…

  anushaun

  4 replies

  15 years, 5 months ago

  By: Jeff Moden

• How do I delete the SQL Server Configuration Manager?

  All SQL Server 2005 objects have been removed via Control Panel. Microsoft SQL Server 2005 key has …

  RonKin

  9 replies

  15 years, 5 months ago

  By: SQLRNNR

• Databse mail sending blank mails

  Hi, I have a 2 step SQL Server job. Both these steps send DB mail (basically the query o/p) on succ…

  vihi.koyott

  5 replies

  15 years, 5 months ago

  By: RBarryYoung

• How do I delete SQL Server Cluster Manager

  All SQL Server 2005 objects have been removed via Control Panel. Microsoft SQL Server 2005 key has …

  RonKin

  1 replies

  15 years, 5 months ago

  By: RonKin

• Trigger runs with manual insert, but not when apps does insert on table

  Hi All... I used to work with SQL a LONG time ago (R:Base running on DOS!). With a lot of help from…

  gpglang

  6 replies

  15 years, 5 months ago

  By: Ken McKelvey