SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• List value based on another field value - Query question

  I have employee table and its contact info. I need to list basic information about employee such as…

  lsalih

  8 replies

  11 years, 5 months ago

  By: lsalih

• Update Part of a SQL field with charindex

  Hello, I have a field and the data is in the format below: 12-FLA-2-02 I am trying to update just t…

  duncanlarry

  5 replies

  11 years, 5 months ago

  By: Sachin Nandanwar

• Row_Number With Partition keep min record of partition when count > 1

  I have a query that is bringing back something like this. if there is only one row for a given city…

  Lee Hopkins

  6 replies

  11 years, 6 months ago

  By: Lynn Pettis

• Log shipping error

  Hi All, I have scheduled job for log shipping every 24 hours at midnight. First day it was running …

  arooj300

  27 replies

  11 years, 6 months ago

  By: Beatrix Kiddo

• Create UDF (Function) with one parameter - returns True/False from VBA code

  I have written a Rule Engine in MS Access (client) that uses linked tables with SQL Server Native C…

  Mile Higher Than Sea Level

  7 replies

  11 years, 6 months ago

  By: Mile Higher Than Sea Level

• Renaming default instance

  I just installed SQL Server Express 2014 and changed default instance name to MSSQLSERVER. Is this …

  Senchi

  4 replies

  11 years, 6 months ago

  By: paul.knibbs

• Renaming a server running SQL 2008

  We are adding a new server and moving some database apps off an existing server, leaving just one d…

  harrietf

  2 replies

  11 years, 6 months ago

  By: samalex

• Storing range of varchar values into variable for future filtering in query

  Hi, I have a simple query in which I'm retrieving all sales orders of a certain type. SELECT * FR…

  tarr94

  2 replies

  11 years, 6 months ago

  By: Grant Fritchey

• Datetime format

  Hi all, Declare @date datetime= '18-06-2014 11:38:46.050' select cast(@date as varchar) Message: Th…

  kapil_kk

  2 replies

  11 years, 6 months ago

  By: Gail Shaw

• how to load multiple flat file

  how to load all files in a directory in ssis with different delimiter ? I have tried this using For…

  vignesh.ms

  2 replies

  11 years, 6 months ago

  By: Koen Verbeeck

• CTE Incorrect Syntax

  Hey guys, I am trying to create a CTE, but I get an error message saying Incorrect syntax. Please t…

  crazy_new

  8 replies

  11 years, 6 months ago

  By: Sean Lange

• How to join to a comma delimited list

  Hi all, I have a table: id pallet color 1 a red,blue 2 b yellow and fun…

  RightOnTarget

  5 replies

  11 years, 6 months ago

  By: Jeff Moden

• Trace user in sql server

  Hi All, Can anyone please help me to trace the user , if someone has deleted the records or table f…

  arooj300

  5 replies

  11 years, 6 months ago

  By: Grant Fritchey

• Trigger failing

  Hi all, I have a trigger on insert to fire a stored procedure. As soon as a new transaction comes i…

  crazy_new

  21 replies

  11 years, 6 months ago

  By: crazy_new

• Help with Visual Studio, email subscription

  Hi all, I was briefly shown Visual Studio a couple of weeks ago by an analyst who has left the orga…

  alicesql

  1 replies

  11 years, 6 months ago

  By: alicesql