T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to delete few records and insert the same records in another table in one statement in SQL 2008

  I HAVE TO DELETE FEW RECORDS FROM A TABLE BASED ON SOME CONDITIONS AND INSERT THE SAME DELETED RECO…

  sandeep1188

  2 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• problem with dynamic sql

  Hi. My stored procedure is below: createPROCEDURE [dbo].[Insert_Dinamik] @baslik nvarchar(max)=null…

  sa.ordekci

  4 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Parse String to find a letter...

  Hi All, One of the columns of my table include strings like below, ----A375475960dkgjfkfkgjfkvkl!…

  apat

  13 replies

  14 years, 10 months ago

  By: Jeff Moden

• Julian-Format Dates

  The boss wants to be able to SUM dates. In the mainframe world, this would have been possible with…

  imani_technology

  12 replies

  14 years, 10 months ago

  By: Michael Valentine Jones

• Need TSQL to get record count by time intervals..

  So, basically, have this ticketing system and need a script to return records (count) by shift. Sa…

  sql_jr

  10 replies

  14 years, 10 months ago

  By: Sean Lange

• Access extent and page information of an object

  Hi, Few things I would like to know (assuming table is not partitioned): 1. Can I access extent or …

  abygaikwad17

  10 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Length command with trailing spaces?

  How can I get the length of a field including trailing spaces? Trying to see if my data was inputte…

  Sean Grebey-262535

  3 replies

  14 years, 10 months ago

  By: SQLRNNR

• Query Question

  I have a table that includes user IDs and permissions for people within a department. I'm trying to…

  Mike Scalise

  10 replies

  14 years, 10 months ago

  By: ColdCoffee

• Vertical Data To Horizontal

  Here's an example data set (pipe delimited) that I'm trying to take from vertical to horizontal. I …

  jarid.lawson

  3 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• HOW TO ALTER /RENAME TABLE NAME WITH TSQL CODE?

  HOW DO I CHANGE THE TABLE NAME WITH TSQL CODE? THANKS

  invaliddba

  2 replies

  14 years, 10 months ago

  By: jarid.lawson

• Set sqlcmd :SetVar scripting variable to a T-SQL variable

  Hi, Is there any way to set a sqlcmd :SetVar scripting variable to a T-SQL variable. I have someth…

  MrAkki

  1 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Rounding numbers

  Its a Friday and my brain is having a slow day. I am trying to work on a formula that will calculat…

  sperry-750868

  11 replies

  14 years, 10 months ago

  By: sperry-750868

• Understanding partitioning, using joins and indexes?

  Hi All I'm new to partitioning and need a bit of assistance. Here are the basics: 1. I've partition…

  xrapidx

  7 replies

  14 years, 10 months ago

  By: xrapidx

• Update statment Help

  Hi Guys, Update help, Here is my data ID# VALUE C-1234NULL M-3456NULL After I run update…

  rocky_498

  12 replies

  14 years, 10 months ago

  By: GSquared

• Need help tweaking a random query

  I need to get random samples for auditing our customer service agents. Specifically, I need a quer…

  Sector7G

  5 replies

  14 years, 10 months ago

  By: ChrisM@home