SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Calling a stored procedure from inside another SQL select statement

  Hi All, I have a stored procedure for SSRS report. I would like to call this stored procedure insid…

  ITU_dk2012

  11 replies

  10 years ago

  By: math martinez

• Deciphering a job description

  Not sure what 'multiple environments (D/T/Q/P)' means. Here's the lead line from the job descriptio…

  rtrim(ltrim(' '))

  2 replies

  10 years ago

  By: rtrim(ltrim(' '))

• File retrieval (FTP or Copy)

  I have a text file that contains a list of document paths, would anyone have a script that would ru…

  Newbie36037

  1 replies

  10 years ago

  By: Steve Jones - SSC Editor

• SSIS script to create folders

  I need to create a package to do the following the package will have 3 input parameters 1) Startdat…

  Newbie36037

  11 replies

  10 years ago

  By: Newbie36037

• SSIS - Creating sub folders

  What would be the best way to achieve the following, would it be a script task For each document ty…

  Newbie36037

  2 replies

  10 years ago

  By: Newbie36037

• query to total data in one table and associate to ID in another table

  Hi Guys, I am a sysadmin being asked to collect data from sql DBs on our app servers. Each app serv…

  sqlizcool

  3 replies

  10 years ago

  By: Sean Lange

• subquery with unexpected result

  I am working with a query, having 2 subqueries. The main query and the 2 subqueries each call the s…

  cajun_sql

  1 replies

  10 years ago

  By: Sean Lange

• Insert statement - Max(FIELD)+1 how to deal with if MAX(FIELD) = NULL

  Hello, I have an insert statement similar to: insert into dbo.CHILD (ChildMotherID, ChildNo) values…

  chetta

  1 replies

  10 years ago

  By: Eirikur Eiriksson

• Updating XML colums

  I have a number of records in a table which contain an xml field. I need to update a specific piece…

  Newbie36037

  3 replies

  10 years ago

  By: Eirikur Eiriksson

• Training

  I've been using SS, off and on, more on in the last 10 years, in one way or another since version 4…

  DSNOSPAM

  8 replies

  10 years, 1 month ago

  By: Grant Fritchey

• Header and details query

  Hi All! I have a query, which delivers all my headlines: Select D.name as institution,RTRIM(B.per_f…

  Edvard Korsbæk

  3 replies

  10 years, 1 month ago

  By: ChrisM@Work

• Using Stuff

  I am trying to get the 3 rows in the below in one line. with all 3 names separated by "," create t…

  sharonsql2013

  10 replies

  10 years, 1 month ago

  By: Lynn Pettis

• error:"The role 'DatabaseMailUserRole' does not exist in the current database

  I have a user in one of my databases that I wish to give permissions to send database mail. I have …

  KoldCoffee

  3 replies

  10 years, 1 month ago

  By: jigging.tech

• SQL connection issue

  Hello, I have a virtual server machine that has multiple SQL instances installed (2 x 2008 R2, 1 x …

  andrei.vizitiu

  9 replies

  10 years, 1 month ago

  By: HanShi

• Runtime-Error: SQL-Server does not exist

  Hello, We are experiencing some strange errors within our MS Windows Server 2008R2 network. There a…

  Scarabee

  3 replies

  10 years, 1 month ago

  By: Scarabee