T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Select statement that needs to use custom grouping

  I hope I can explain this issue I am having well enough for everyone to understand it. Here it goes…

  Daniel Tuma

  5 replies

  10 years ago

  By: Jeff Moden

• Need to calculate PS1 time and Ps2 time from two tables

  Hi All, I have 2 tables as defined below. I want to calculate PS1time and Ps2 time. Table 1 O_IDP…

  rsrvas

  3 replies

  10 years ago

  By: Eirikur Eiriksson

• Help Needed in cross logic Query

  Hi, Below is my sample data to play with, Declare @Store table(id int primary key identity(1,1),Sto…

  KGJ-Dev

  8 replies

  10 years ago

  By: KGJ-Dev

• SQL - Need to add a flag when certain conditions are met

  Hi Folks, I have a table where when an employee works LEAVE1 and LEAVE2 paycodes on the same day th…

  DiabloSlayer

  2 replies

  10 years ago

  By: amurjani

• Row into Multiple Column

  Need help !!! Create table control_Total ( Filename varchar(1000) ) insert into control_Total value…

  sqlenthu_11

  7 replies

  10 years ago

  By: AMIT GUPTA-263376

• [T-SQL] Question involving Job,Cursors, SP and DBMail

  Hi all, and nice to be part of this forum I hope I can assist and be assisted when needed. Require…

  alexnf

  3 replies

  10 years ago

  By: alexnf

• T sql help (database size track)

  Hello gurus, I am trying to capture 'AdventureWorks' Database size every week. I have created a 'DB…

  Tac11

  6 replies

  10 years ago

  By: Tac11

• Get list of all the tables used in multiple SQL scripts

  Hi All, I am trying to figure out an automated way to get a list of all the tables used in a set of…

  myjobsinus

  10 replies

  10 years ago

  By: myjobsinus

• Add Total Row For Each Name

  I have a field in a table which was VERY poorly designed, but that is a matter for another day. Lo…

  JoseMenendez

  6 replies

  10 years ago

  By: WayneS

• select statement with derived order status

  Here is my requirement Table 1 Order order ID, Sales order ID order date, order type Table 2 Order …

  reddysrinu

  3 replies

  10 years ago

  By: Luis Cazares

• Update statement: use the in clause or run simple update 500 times

  I have to do updates via web app. Stuck with time out: Update mytable set col1= 'some va…

  chandrika5

  4 replies

  10 years ago

  By: ScottPletcher

• Another SQL question, hopefull simple one

  Hello Everyone, I have been trying to get minimum in punch time for IN_PUNCH column and maximum out…

  DiabloSlayer

  8 replies

  10 years ago

  By: Jeff Moden

• Need to keep a running total of OnHandQty Minus OrderQty

  I have been tasked with writing a report that shows all open orders for an item and their quantitie…

  ducksql@gmail.com

  8 replies

  10 years ago

  By: Jeff Moden

• Syntax Errors when Re-Creating Procedure

  Hello, We regularly restore a database from one environment to another. The destination environment…

  Like2SQL

  11 replies

  10 years ago

  By: Like2SQL

• Rebuild Index after Transaction log backup

  Hello Masters of SQL, i have a little problem with my Query, i try to create script which Rebuild o…

  GKR 52789

  1 replies

  10 years ago

  By: ScottPletcher