SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Sql Server on Linux?

  Is it possible to run SQL server on Linux? I've heard rumors of such a product but nothing definite…

  ggmar

  8 replies

  7 years, 3 months ago

  By: Steve Jones - SSC Editor

• SQl 2005 Could not locate entry in sysdatabases for database 'dbo'

  I am trying to create a stored procedure that has 5 steps in it. the procedure is failing at step 3…

  vba317

  11 replies

  7 years, 5 months ago

  By: Arsh

• Calculated Query Help

  Hi, I am struggling to grasp on how to calculate in SQL where there is a fixed Qty in stock and min…

  gazy007

  27 replies

  7 years, 9 months ago

  By: Greg Edwards-268690

• ETL job consuming all tempdb space and failing

  Good morning experts, There is a ETL job that has been running fine since 2014. The job did not get…

  coolchaitu

  4 replies

  7 years, 10 months ago

  By: Phil Parkin

• returning transactions from the last 12 whole months

  Hi, I'm trying to write a query to return all transactions with a transaction date from within the …

  john.dixon 58151

  5 replies

  8 years, 2 months ago

  By: john.dixon 58151

• Splitting data into two columns

  In address_field I have street name together with house number all in one line.Something like : …

  Senchi

  4 replies

  8 years, 2 months ago

  By: Senchi

• BCP via batch file - Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file

  Hi, I have a csv file - output from a sybase database which is column delimited with a ',' whne I t…

  rob_nye

  4 replies

  8 years, 2 months ago

  By: Jeff Moden

• Random 64 Characters alphanumeric String

  I need to create a random 64 alphanumeric string every time a new row is added to a SQL 2005 databa…

  AFIFM

  19 replies

  8 years, 3 months ago

  By: Eirikur Eiriksson

• splitting long sentence into multiple lines

  I am new to MS Sql. I am trying to find a function which will split a long sentence into multiple s…

  T.S.Giridharan-371646

  10 replies

  8 years, 4 months ago

  By: alexis.c.cesar

• How to get the first day of any month

  Hi Folks, How to get the first ay of any month, Normally we will concatenate '01' TO DATE FU…

  lefrancisco1

  4 replies

  8 years, 4 months ago

  By: Saravanan_tvr

• Calling Stored Procedure issue in Excel 2013

  Hi All, I'm very new to SQL please bear with me.. I have a stored procedure that does what I expect…

  timelse27

  8 replies

  8 years, 6 months ago

  By: gand 29575

• Trigger doesn't work when data is enter through SSIS package

  I have the following trigger, it works when I manually input into the table but if I run a SSIS pac…

  smac

  5 replies

  8 years, 6 months ago

  By: Christian Erasmus

• Series of numbers with required pair of Digits - SQL

  Hi Everyone, I need to compile/generate a series of 7 digits on a specific criteria where 6 digits/…

  Rehan Ahmad

  6 replies

  8 years, 6 months ago

  By: Jeff Moden

• BCP using xp_cmdshell

  I'm using SQL Server 2005 Express and I'm trying to run this: declare @sql varchar(8000) select @sq…

  mattennevor

  11 replies

  8 years, 8 months ago

  By: abeljda 60974

• Using round, isnull, and sum in the same select

  Is this possible? I wish to sum the column, round it, and also account for null values in a single …

  David Hall-426383

  1 replies

  8 years, 9 months ago

  By: Luis Cazares