T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• noob tsql confusion!

  Hi all, trying to learn tsql so thought i would try and make a data dictionary for my class in db …

  Staggerlee

  4 replies

  14 years, 8 months ago

  By: Jeff Moden

• Optimizing SP

  Hi, I have a question regarding SQL Server stored procedures. Imagining that there is procedure to …

  RMiranda

  8 replies

  14 years, 8 months ago

  By: RMiranda

• Convert column in multiple rows to a single csv column

  Hey all, I need to return a single csv column for [sys].[dm_db_index_physical_stats]'s [alloc_unit_…

  Adam Bean

  5 replies

  14 years, 8 months ago

  By: Adam Bean

• Date manipulation and pivottable in excel

  Hello, I'm trying to set something up and can't for the life of me figure out what to do. I have a…

  Stephen crocker

  6 replies

  14 years, 8 months ago

  By: drew.allen

• Select on Sysjobs

  I need to create a report about the SQL Agent Jobs. The information I need is the Job name, Status …

  itpcpro

  2 replies

  14 years, 8 months ago

  By: RTaylor2208

• Help - Reading data from row by row - without using cursor?

  Hi, Table Name - EnergyMeter Filed Name - Meter_Id Total Records - 6 using stored procedure - how c…

  SQL Galaxy

  2 replies

  14 years, 8 months ago

  By: Jeff Moden

• Convert varchar to binary or vice versa

  Hi, How can i convert a binary to varchar datatype or a varchar to binary data type.

  tripri

  1 replies

  14 years, 8 months ago

  By: GSquared

• Retrieve Time from DateTime (2005)

  I'm after a way to strip out the date from a smalldatetime column, but still store it as smalldatet…

  kuopaz

  2 replies

  14 years, 8 months ago

  By: Cadavre

• Dynamically data was not loading into a table.

  Hi Team, Using below script Loading data into a table but 1st time data was loading perfectly when …

  shiv-356842

  1 replies

  14 years, 8 months ago

  By: shiv-356842

• replacing values in one column with null values

  I have a table in my sql server 2005 database where I need to replace all the values in one particu…

  Jpotucek

  7 replies

  14 years, 8 months ago

  By: Ron McCullough

• Return NULL values as output, if there is no matching records for a select query

  I need to return NULL values as output, if there is no matching records for a select query. Any ide…

  Sanz

  2 replies

  14 years, 8 months ago

  By: goofbauer

• Select top five rows for each key value

  The attached is a brief example of a file extracted(Top 5.xls). The data definition is: 1. Key - Id…

  Howard C. BAchtel-438731

  9 replies

  14 years, 8 months ago

  By: Howard C. BAchtel-438731

• Retrieving status from history

  The database I'm working with is an order database. It stores order status in a history table whose…

  goofbauer

  4 replies

  14 years, 8 months ago

  By: goofbauer

• Ado recordset does not return value from varchar(MAX) field

  Some records in this field have len = 22000. When I run the query (Select Summary From MyTbl Where …

  valeryk2000

  5 replies

  14 years, 8 months ago

  By: valeryk2000

• Database Replication

  I am using a Database on a Server that I don't have much access through (Its held via an external c…

  J39L4753

  4 replies

  14 years, 8 months ago

  By: J39L4753