SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Show emplty output with 0

  Hi, I have a sql query that gets the count of exams held in each month. In every month there can be…

  karthik82.vk

  6 replies

  11 years, 2 months ago

  By: ChrisM@Work

• update table from variable table column

  Hello, I am trying to use a stored procedure to update a column in a sql table using the value fro…

  itortu

  2 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Case statement

  Hello, I have a bit of trouble getting values into one alias field, my code is below. I am trying t…

  cbrammer1219

  15 replies

  11 years, 2 months ago

  By: Phil Parkin

• FreeText Query - Contains

  Hello friends, I am looking to filter the query using the free text predicate Contains for one of t…

  B T-460322

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Create XML file from AS400 stored procedure returning multiple datasets

  Hi.. Here is the problem. I have a store procedure in MC400 which I can call from SSMS using the be…

  vinaygambhir

  3 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• ELMAH_LogError: How to update TimeUtc with GetDate() Eastern Time

  CREATE PROCEDURE [dbo].[ELMAH_LogError] ( @ErrorId UNIQUEIDENTIFIER, @Application NVARCHAR(…

  TBIG

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Report never stops loading, Out of Memory Error

  I have a report that uses three tables from a database. As long as I only use two of the tables, it…

  mballentine

  6 replies

  11 years, 2 months ago

  By: Alan Burstein

• ISNULL with two data sources in SSIS

  I'm sorry if this is not the best spot for this question, but I couldn't find an forum that looked …

  robert.wiglesworth

  3 replies

  11 years, 2 months ago

  By: Jack Corbett

• Database Permissions

  Hi I work in a world of PCI and change control as as such we need a distinction between prod and d…

  Andy Hyslop

  1 replies

  11 years, 2 months ago

  By: Jack Corbett

• Summing Logical Reads Each Day for a Server

  We would like to benchmark our logical reads daily to show our improvement as we tune the queries o…

  john.petrey

  3 replies

  11 years, 2 months ago

  By: john.petrey

• OPTION (FAST x) and trace flag 8722

  Hi there, I have searched a long time and still haven't found the answer to my problem. Our Dynamic…

  Nelson 2.0

  3 replies

  11 years, 2 months ago

  By: Nelson 2.0

• How to BCP in >8000 byte binary records from a flat-file to a varchar(max) table???

  Example: I have a 1,081,202,178 byte binary file consisting of 86,349 records, each 12,522 bytes in…

  gil.jeffer

  1 replies

  11 years, 2 months ago

  By: ScottPletcher

• Why is my query wrong?

  I am trying to correct linenumbers in a certain entry (because I deleted a part of it) and created …

  marc.eilander 13301

  8 replies

  11 years, 2 months ago

  By: ScottPletcher

• SSIS: Make Excel Visible In Script Task During SQL Server Agent Job Run

  I am wondering if I can show the Excel window when the SQL server agent job runs. The SSIS package …

  chrisjamesb

  2 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• I'm new to SQL development..

  Hi There, I'm new to SQL development.. please assist me something that every developer must know &#…

  squvi.87

  5 replies

  11 years, 2 months ago

  By: Koen Verbeeck