Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• The conversion of the varchar value overflowed an int column

  the below script is return this error :The conversion of the varchar value '4103049600' overflowed …

  ikrami2000

  15 replies

  5 years, 11 months ago

  By: gagan

• Report runs forever.`

  Not sure why this report runs continously... Select distinct H.Customs_Entry_Num as [Entry Num] ,H.…

  jeffshelix

  3 replies

  5 years, 11 months ago

  By: ChrisM@Work

• Slow query vs. comments in the code

  I have query like this: 1.select into table2 from table1 2.select function(table2.field1) from tabl…

  everand76

  8 replies

  5 years, 11 months ago

  By: everand76

• SSIS Script task If conditon

  i have a variable value that coming from batch file as N and Y in the package i kept hfcol  as stri…

  mcfarlandparkway

  2 replies

  5 years, 11 months ago

  By: Thom A

• set datefirst question

  I'm trying to compare weeks based on the start date of the given week being a thursday. Meaning the…

  Snargables

  11 replies

  5 years, 11 months ago

  By: ScottPletcher

• Record counts from the table

  Hi, I need to count the different total number of records from the table as table has column which …

  pdsqsql

  15 replies

  5 years, 11 months ago

  By: Steve Collins

• Case when then

  I have a simple case: I have to assign value to a variable depending on type. Here is my simplified…

  SQL Guy 1

  5 replies

  5 years, 12 months ago

  By: SQL Guy 1

• Convert varchar to numeric

  I have a variable with this format C(5) wish is separate with : like a time format 16:00... the des…

  Pedrosoa

  1 replies

  5 years, 12 months ago

  By: Phil Parkin

• A bit of mathematics...

  Hi all, I'm just doing some work on my own bank statements imported from CSV.   Two salient columns…

  JaybeeSQL

  3 replies

  6 years ago

  By: Sumathi

• NOOB question with Case statement

  hi here i am again with a noob question again: i'm trying to do this: case  when columnA <> 0…

  nrdroque

  12 replies

  6 years ago

  By: MVDBA (Mike Vessey)

• Need Help: On Query with Case Statement

  Hi, As part of development task I have to write a SQL logic for the below 6 scenarios, I have achie…

  windows_mss

  3 replies

  6 years ago

  By: michael.cole 47030

• how to rollback transaction explicitly

  By forcibily i tried to fail insert statement (Insert into dbo.student) by entering 1/0 value into …

  mcfarlandparkway

  7 replies

  6 years ago

  By: Steve Collins

• TSQL assistance to reduce output of the query

  Hi Experts, Wondered if someone with TSQL knowledge can let me know how I can amend the below TSQL …

  Buddy84

  2 replies

  6 years ago

  By: Buddy84

• Is it possible to compare columns' content?

  I have a table of objects. Each of them has various references, e.g. from reference 1 to reference …

  BOR15K

  3 replies

  6 years ago

  By: BOR15K

• Using SELECT LEFT and WHERE IN in the same SELECT Statement.

  Greetings ~ I'm trying to get the following query to work in SQL 2014 [Code] SELECT LEFT(AKey, 3) A…

  MarkW.Rhythm1

  10 replies

  6 years ago

  By: ScottPletcher