SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• SQL loop never stops even if I define loop number

  Hi, I have a temporary table, filled from an csv file, then this table values will be inserted in o…

  benkraiemchedlia

  7 replies

  8 years, 9 months ago

  By: Luis Cazares

• Issue with description text

  When will most of the time this error comes?'String or binary data would be truncated'

  mcfarlandparkway

  3 replies

  8 years, 9 months ago

  By: Sue_H

• unable to find the error

  DECLARE @databases table(  RowID INT not null IDENTITY(1,1) PRIMARY KEY,  Name &nbs…

  @Patrick123

  3 replies

  8 years, 9 months ago

  By: Sue_H

• Roll from lowest level child to it's subsequent parent

  Hi, I want to roll Duration field from it's lowest level to it's immediate level parents , then fro…

  PSB

  6 replies

  8 years, 9 months ago

  By: jcelko212 32090

• Conversion script runs for long time unless carved up, not sure why.

  Hi, I'll keep this brief. We have a data conversion script written by one of the data team. It basi…

  NicHopper

  4 replies

  8 years, 9 months ago

  By: Jeff Moden

• How to “step through” a list of values creating a record for each value

  Hi, using SQL server 2012. I need to run this code and somehow STEP through a list of different "ID…

  mpsqlsercen

  16 replies

  8 years, 9 months ago

  By: Jeff Moden

• backup/restore singe table (Export table?)

  Hi all! I have this pretty simple table in two different DB's, lets call them DB1 and DB2, places o…

  Edvard Korsbæk

  10 replies

  8 years, 9 months ago

  By: Henrico Bekker

• How can I get the waits for each database?

  Hello all,I need to create a report that gets me the waits, time and percentage at database level f…

  ricardo_chicas

  5 replies

  8 years, 9 months ago

  By: ScottPletcher

• Any way to audit seeding changes?

  I am able to see the results of seeding changes if I audit a table's insertion IDs by putting a tri…

  Mindy Hreczuck

  1 replies

  8 years, 9 months ago

  By: Eric M Russell

• how to convert varchar value to datetime

  SELECT MAX(CASE code WHEN 'sdt' THEN convert(datetime,Cval) ELSE NULL END) as MinDate, MAX(CASE c…

  mcfarlandparkway

  3 replies

  8 years, 9 months ago

  By: Jeff Moden

• Find Matching People in table based on similar values

  Hello All,I'm trying to find a method that will run on Data-sets of 100K rows to a million efficien…

  thomashohner

  10 replies

  8 years, 9 months ago

  By: jcelko212 32090

• transpose like function

  I have a record set of article numbers with corresponding specification parameters.ArticleNumber | …

  OJDev

  7 replies

  8 years, 9 months ago

  By: Jeff Moden

• how to use throw in following situation.

  hi,  -- i want to use throw iin following way , and it is working but the problem is it showin…

  rajemessage 14195

  3 replies

  8 years, 9 months ago

  By: Phil Parkin

• Convert first column in row without duplicate values, and second column in rows

  Hi, I have a table with 2 columns : questions, answers. The same questions can be answered by …

  benkraiemchedlia

  18 replies

  8 years, 9 months ago

  By: Y.B.

• how to get image type in nvarchar to be excuted in exec/sp_execute command

  HI, CREATE TABLE #T(I IMAGE)INSERT INTO #T VALUES(CAST(N'CREATE PROCEDURE SP1@I IMAGEASBEGINSELECT …

  rajemessage 14195

  4 replies

  8 years, 9 months ago

  By: sgmunson