SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Start with function

  I have a list of records in a table of Locations, Africa, ASIA, Europa, America and would like to s…

  omlac

  3 replies

  13 years, 11 months ago

  By: spaghettidba

• I Have Some Problem in this Query

  SELECT C.Clstr_Nm,C.CH_typ, Sum(C.MTD_TRCDMA) 'MTD_TRCDMA', SUM(C.LMTD_TRCDMA)'LMTD_TRCDMA', '%Grow…

  sabareeswaran.sundram

  3 replies

  13 years, 11 months ago

  By: LutzM

• COPY ALL THE ROW'S VALUE ONLY FROM EXISTING COLUMN (NVARCHAR) TO ANOTHER EXISTING COLUMN (NTEXT) IN SQL 2005

  Hi everyone, I am new in sql server and I am using SQL SERVER 2005 WITH svc 4 iNSTALLED ON IT. I ha…

  grahamrd

  6 replies

  13 years, 11 months ago

  By: grahamrd

• Positions of Nullable columns

  Hi I realise that this might not be the brightest of questions, but a while back I remember hearing…

  BinaryDigit

  3 replies

  13 years, 11 months ago

  By: Ron McCullough

• How do I import this data?!

  Hi guys, I am struggling to get a data set into SQL (See link below) I have imported from various s…

  methexis

  17 replies

  13 years, 11 months ago

  By: Orlando Colamatteo

• Error loading files from temporary folder - see below

  SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot resolve …

  mohamed.mono

  2 replies

  13 years, 12 months ago

  By: Steve Jones - SSC Editor

• Applying SQL 2005 SP2 to 2-Node Cluster Failing

  Hi, Not a "Newbie" but definitely new to this issue. A year or so ago, a third party vendor se…

  watson_mike

  5 replies

  14 years ago

  By: homebrew01

• A design question

  According to my boss, the design that I created is too complicated, but I think its fine. I was won…

  meichner

  19 replies

  14 years ago

  By: meichner

• Full Text Catalogs

  I am new to full text searching so this my be a simple one... I have ran across an issue when our a…

  DBloc

  2 replies

  14 years ago

  By: DBloc

• Shrinking Log files

  Hello, I've been shrinking log files (first by truncating the log and then shrink via management st…

  nocode99

  5 replies

  14 years ago

  By: Ninja's_RGR'us

• Could Not Configure Mirroring between Principal and Mirror Servers

  Hi, I am trying to configure mirroring between principal and mirror servers without witness server.…

  Praveen Kumar, Kotha

  6 replies

  14 years ago

  By: prithvi.m

• Query Help

  I Have table with 3 fields. EmployeeID,CheckDate,CheckAmount I need to run a query by check date th…

  nfpacct

  13 replies

  14 years ago

  By: andre_soliz

• Row Merge with a Twist

  Hi, Server: MSSQL 2008 R2 I need to merge data from 2 fields into a single row. The problem is the …

  zaleeu

  7 replies

  14 years ago

  By: Ninja's_RGR'us

• Shredding XML

  Hi, I'm new to working with XML data in SQL Server and i'm having some trouble getting the results …

  s_osborne2

  3 replies

  14 years ago

  By: s_osborne2

• Invalid-object-name-mytemptable

  I am new to SQL Server so please forgive the crudity of the code. I am trying to insert dates from …

  stuartmarshall

  3 replies

  14 years ago

  By: stuartmarshall