T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 months ago

  By: J39L4753

• Help needed getting summary by weeks of current month

  When pulling data, I need to summarize totals by Week of the current month. e.g. if the 1st of the …

  iluvmyelement

  5 replies

  14 years, 5 months ago

  By: drew.allen

• Doubling of value when source has two lines

  I have a query when run will return an incorrect value for the "Gross Profit" field. This is happe…

  Ralph L. Wahlert

  1 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• question about SQL

  I have 3 tables. One is SiteSchool, one is School, the other is Site. The 3 tables are as below, my…

  sqlfriend

  6 replies

  14 years, 5 months ago

  By: sqlfriend

• Database Free Space Sp_spaceused

  Hi Guys I have the following code EXEC sp_msforeachdb @command1="use ? exec sp_spaceused" Is there…

  SQLSACT

  37 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us