SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Update Trigger Loop?

  I have a simple Trigger (below) that updates a date value if a column value has changed. I need to …

  rtrim(ltrim(' '))

  3 replies

  14 years, 12 months ago

  By: rtrim(ltrim(' '))

• Bulk Insert with Format File

  Hi, Here is my Table: CREATE TABLE NewCDN ( [Agent] char(30), [Target_Id] char(7), [Performance] c…

  NoviceJatt

  2 replies

  14 years, 12 months ago

  By: NoviceJatt

• SSRS Data Source View

  Hello all. Just looking for some advice for a newbie to SSRS. Search as I might I've been unable to…

  prnuttall

  3 replies

  14 years, 12 months ago

  By: Toby White

• Multi-parent heirarchy query

  Hi All I'm using SQL 2005 and have a heirarchy structure in which a child could have multiple paren…

  james.mcallester

  7 replies

  14 years, 12 months ago

  By: Jeff Moden

• Backup report across servers

  Good morning, I have the following query that I would like to run from a central management server …

  PHXHoward

  1 replies

  15 years ago

  By: PHXHoward

• multipart identifier error message

  I am using sql 2008. This query is designed to get all patients that were readmitted within 30 days…

  bhutchin

  2 replies

  15 years ago

  By: ChrisM@Work

• Data Manipulation

  Hi, Im importing data from a Flat file using Bulk Insert. I have few rows in my Table which have n…

  NoviceJatt

  2 replies

  15 years ago

  By: NoviceJatt

• File Encoding in SQL Server Management Studio Save Results As ...

  I'm running a T-SQL query in Microsoft SQL Server Management Studio and saving the results to a tex…

  SQL Server Youngling

  2 replies

  15 years ago

  By: SQL Server Youngling

• Create Data Dictionary With Descriptions / I'm So Close

  We recently upgraded from 2000 to 2008. The SQL statement I used to create my version of a Data Dic…

  EdA ROC

  1 replies

  15 years ago

  By: EdA ROC

• Unable to access SQL DBEngines that have been moved to a new domain

  I have a new clean SBS 2003 R2 fully patched server. It has the same PC and Domain name as my previ…

  Coypu

  4 replies

  15 years ago

  By: Joie Andrew

• database mail without cursors?

  I'm a noob... so I have a dumb question. Say I have a table of "Studies" and a table of "Staff". …

  pietlinden

  12 replies

  15 years ago

  By: Jeff Moden

• SQL Instance checkings.

  Hey all, I have a random Question, Is there a way, I can run a T-SQL script from one sql server ins…

  gareth.thompson

  3 replies

  15 years ago

  By: Brian O'Leary

• How to take info in 1 field and seperate it into 2 fields

  I am trying to take info that is in 1 field and break it into 2.The problem is that the info in the…

  thejatrix32

  5 replies

  15 years ago

  By: steve-893342

• SQL-based assignment table

  I've got a problem similar to this contrived example: I need a function/code snippet/whatever to he…

  fmurphy

  1 replies

  15 years ago

  By: PaulB-TheOneAndOnly

• Need help with accessing information from a different server

  How can I go about accessing information from one server when i'm on a different one. I looked int…

  mbender

  6 replies

  15 years ago

  By: mbender