T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Update a table will fire trigger or not???

  will a trigger will fire irrespective of updating the same value. scenario :- i m having a table. …

  ghanshyam.kundu

  1 replies

  15 years ago

  By: HowardW

• Create a view that only shows columns that arent completely empty

  Hi, A strange question but bear with me. I have a denormalised table that I am going to query, the …

  olibbhq

  3 replies

  15 years ago

  By: olibbhq

• Pass Variable values in Lookup transformation

  Hi All I have variable name SDO=(DIN or VDI) In lookup transformation i am using the query select d…

  rohit.kumar.barik

  1 replies

  15 years ago

  By: Evil Kraig F

• Merge Half an Hour slot data into Hour Slot Data

  Need to merge the data which in 30min data to near hour data. Eg: Data @ 12:30 should be sum with 1…

  SPtrt

  2 replies

  15 years ago

  By: SPtrt

• Group by problem

  Hello, I need to group a set of data like this: Name Date Work ----- ----------- -----…

  geckonido

  3 replies

  15 years ago

  By: geckonido

• Convert MySQL to MSSQL - need help

  I have a MySQL database that I run queries against from MSSQL 2008. There is a canned report in our…

  david.aldridge

  6 replies

  15 years ago

  By: david.aldridge

• substring,replace,charindex

  Dear gurus, Can someone help me to construct SQL using the above functions? I have this sample set …

  sha_azna

  1 replies

  15 years ago

  By: UMG Developer

• Delete Syntax Help

  Hi, Here is my sample data, In my source table i have more than 60k rows. Date 2/10/2006 2/10/06 …

  jscot91

  7 replies

  15 years ago

  By: UMG Developer

• TRUE & False case Carry

  Hi Experts, I have a Table which contain the data of TRUE & False, I am looking for the Value …

  Best_boy26

  8 replies

  15 years ago

  By: Best_boy26

• CDATA In TSQL Script

  I'm having trouble using CDATA in TSQL. SQL Server is complaining that it cannot parse my CDATA ite…

  BSavoie

  14 replies

  15 years ago

  By: BSavoie

• Query help for Week wise report of a given month and year

  I need to build a query to calculate the sum/total of a field and display the output like the follo…

  joshtheflame

  11 replies

  15 years ago

  By: kevin_nikolai

• Compatibility Check across multiple Modes

  This is an extension of this post... http://www.sqlservercentral.com/Forums/Topic1080578-392-1.aspx…

  SQL_Enthusiast

  5 replies

  15 years ago

  By: Orlando Colamatteo

• MAX() Problems & Questions

  Hey fellow SQL'ian's, I have a quandary. It appears that my code is not doing what I told it too..…

  SQL_Enthusiast

  6 replies

  15 years ago

  By: SQL_Enthusiast

• Updating column in a table with it's own column with Int to Datetime conversion

  HI everyone, I don't normally code, but our developers are quite bombarded. I'm trying to update a …

  sunshine-587009

  5 replies

  15 years ago

  By: sunshine-587009

• Long running query

  Hi, I am using SQL-2008 standard edition. I have a query that takes a lot of time to run(25 seconds…

  chandan_jha18

  8 replies

  15 years ago

  By: Grant Fritchey