T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Using CAST or CONVERT to change data from string to datetime

  I am trying to take a field that has part of a date in it, so I have to parse it out as follows: SU…

  miles_lesperance

  9 replies

  11 years, 11 months ago

  By: miles_lesperance

• t-sql 2008 r2 call stored procedure & obtain specific results

  I have a few questions about the following t-sql 2008 r2 sql code listed below that is calling a st…

  wendy elizabeth

  3 replies

  11 years, 11 months ago

  By: a4apple

• Create Dynamics view

  I have view somthing like Create view All_employee AS SELECT Emp_Name, Emp_code FROM dbo.Empl…

  hitesh.15oct

  7 replies

  11 years, 11 months ago

  By: hitesh.15oct

• how to load data from flat file source into oledb destination by changing the data types in ssis

  i have an source file and i have to load it into the data base by changing datatype of the…

  vamsikrishnacheruku

  1 replies

  11 years, 11 months ago

  By: a4apple

• Union difficulty

  Hi All, I'm trying to take a portion of a stored procedure and perform a union with another table I…

  daniness

  13 replies

  11 years, 11 months ago

  By: Sean Lange

• First and Last Day Prior Month as Input Parameters

  I have to create a report and I want all activity for the previous month. I need to calculate the F…

  Welsh Corgi

  3 replies

  11 years, 11 months ago

  By: Jeff Moden

• How to count "Out of" for each row ?

  Good Morning All, I was looking for advice/help on how to count the number of values that exist in …

  shaun.harris1

  2 replies

  11 years, 11 months ago

  By: Sean Lange

• error with SP Execution

  Hi, I am having SP where I am pulling data from linked server. Previously its working fine but sudd…

  abhas

  4 replies

  11 years, 11 months ago

  By: abhas

• Selecting Data from table with multiple conditions on multiple columns

  Hi, I am facing a problem in writing the stored procedure for multiple search criteria. I am trying…

  surya.mekala

  4 replies

  11 years, 11 months ago

  By: ChrisM@Work

• convert column in qry1 and return unmatched

  I have a problem.... I have cpt codes in qry1 that need to be converted then match against qry2 and…

  brianconner

  1 replies

  11 years, 11 months ago

  By: Jeff Moden

• Eliminating duplicates while insert

  Hi, WITH cte_OrderProjectType AS ( select Orderid, min(TypeID) , min(CTType) , MIN(Area) from ta…

  PSB

  9 replies

  11 years, 11 months ago

  By: PSB

• Need help on T-SQL. May be Pivot Tables

  I've tables and data as following, GO /****** Object: Table [dbo].[CV] Script Date: 04/15/2014…

  Little Nick

  8 replies

  11 years, 11 months ago

  By: Sean Lange

• Set value based on previous row

  I am trying to code a rule at the moment which sets a value based on the value of the previous row.…

  aaa121

  6 replies

  11 years, 11 months ago

  By: David Burrows

• Convert the stored procedure to "Standard SQL Select"

  I have a very simple stored procedure to be used in Dundas Dashboard: ALTER proc [dbo].[ddGetCurre…

  halifaxdal

  24 replies

  11 years, 11 months ago

  By: halifaxdal

• Update table with multiline comments

  Hi All, How to update column with multiline coments. eg. I need to update Notification column in my…

  abhas

  4 replies

  11 years, 11 months ago

  By: abhas