SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Having an issue wth a bcp string

  Hi, I have been trying to do this for a while now to get this and, and while I have done this befor…

  itmasterw 60042

  9 replies

  1 month, 3 weeks ago

  By: itmasterw 60042

• Setting up the identity key after creating a new table with data

  Hi everyone, I have a giant table 'A' with an identity key and also a foreign key that references t…

  rohitkocharda

  3 replies

  1 month, 3 weeks ago

  By: Phil Parkin

• XML Parse

  I would like to parse XML data which is in table. Declare @abc table ( id varchar(20), address xml)…

  hardikbeit

  1 replies

  1 month, 3 weeks ago

  By: Eddie Wuerch

• Convert date value

  Hi, I have a requirement to convert a date value like '7th March 2020'  to '2020-03-07'. However, …

  pwalter83

  3 replies

  1 month, 3 weeks ago

  By: Jeff Moden

• In varchar column add numbers and show strings

  Below is the sample data create table temp (userid int , rid varchar(10), value varchar(100)) inser…

  msbisqldeveloper

  3 replies

  1 month, 3 weeks ago

  By: msbisqldeveloper

• Dynamic Column update.

  I would like to update TASK_NXT_RUN_DT  column based on the script in column 2 dynamically. I have…

  koti.raavi

  1 replies

  2 months ago

  By: Phil Parkin

• Export results of a Stored Procedure to a PC Folder

  Hi Forum, I have a Stored Procedure that selects one record from a table. I want to select one row …

  Oscar_Boots

  9 replies

  2 months ago

  By: ETL

• Finding a range of date within a range of date

  I have a project that requires to display a list of patients within a specific period of dates but …

  rclazarito

  7 replies

  2 months ago

  By: rclazarito

• Finding error in nested stored procedure

  Hi, Hope everyone is keeping safe from covid-19. I need to find which particular procedure is givin…

  pwalter83

  5 replies

  2 months, 1 week ago

  By: hannes.malan

• search the value of a field as a substring of another field.

  Hi all, I have the following query: Select mx.vserie, mx.vfolio from data1 mx inner join data2 my…

  mig28mx

  2 replies

  2 months, 1 week ago

  By: Jeff Moden

• Adding another table to a query but only wanting the top 1 for each record

  I currently have query that gives me the results i needs BUT i am needing to add a new table/column…

  roy.tollison

  7 replies

  2 months, 1 week ago

  By: Jonathan AC Roberts

• Concatenating to a string

  I am trying to concatenate values into one string value and what i have so far is progress, but I w…

  DaveBriCam

  7 replies

  2 months, 2 weeks ago

  By: gvoshol 73146

• Quick query help

  Hi All, Need a quick query help. From sysaltfiles , I want to extract the characters excluding the …

  vsamantha35

  2 replies

  2 months, 3 weeks ago

  By: vsamantha35

• How to update a Tables with randum Null parameters

  Hi, I have a number of parameters (see below ) that come into a Stored procedure. In the applicatio…

  itmasterw 60042

  18 replies

  2 months, 3 weeks ago

  By: Jeffrey Williams

• Query not contained in either an aggregate function or the GROUP BY clause.

  Msg 8120, Level 16, State 1, Line 2 Column 'TimeReporting.dbo.TimeData.ID' is invalid in the select…

  stephen.aa

  3 replies

  3 months ago

  By: ScottPletcher