T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Best data type to store hindi fonts

  I am using Hindi fonts in windows application. I have setted down the font of text box as hindi fon…

  gaurav-404321

  1 replies

  15 years, 4 months ago

  By: Paul White

• Cast Float to Char with Natural Rounding

  Hi, I have columns of float data type that I have to convert to char. With a natural cast, any big …

  irobertson

  11 replies

  15 years, 4 months ago

  By: Jeff Moden

• create user and reset passwd stored procedures

  Hello, I'm having issues creating two stored procs. I would like to create one that creates and res…

  ColeTrain

  1 replies

  15 years, 4 months ago

  By: Perry Whittle

• Pivot with Sub Pivot Problem

  Hi All I had created this in Crystal reports 2008 but can't export it to excel so I am trying to cr…

  Northern Monkey

  2 replies

  15 years, 4 months ago

  By: Jeff Moden

• The value of variable is disappearing in stored procedure

  Hi!!! The variable is initialized in a stored procedure with the value present in a table. It is di…

  chaturvedi.garima

  6 replies

  15 years, 4 months ago

  By: Jeff Moden

• problem with one to many relationship

  hi all, I am presently working on a solution to the following problem: Table 1: index1 (primary key…

  harshalnag

  5 replies

  15 years, 4 months ago

  By: nigel.

• list possible values for the DATA_TYPE column in INFORMATION_SCHEMA.COLUMNS view

  The INFORMATION.SCHEMA.COLUMNS view has a column called DATA_TYPE. BOL doesn't list all the potenti…

  Bill Nicolich

  3 replies

  15 years, 4 months ago

  By: Bill Nicolich

• Do I need a cursor?

  I work for a telemarketing company and I have a process that loads telemarketing agent records ever…

  ninel

  5 replies

  15 years, 4 months ago

  By: ninel

• Help with sp_msforeachtable 'sp_spaceused "?"'

  Hi, I am trying something along the lines of the following: declare@SERVER_DB1 VARCHAR (100) set …

  Jinx-640161

  3 replies

  15 years, 4 months ago

  By: Jinx-640161

• How to get the previous ID from this query

  hi i have the following query UPDATE AVR_Curr SET PrevTransactionID = (SELECT max(AVR.Transactio…

  Nomvula

  2 replies

  15 years, 4 months ago

  By: Nomvula

• CXPACKET wait_type on every thread in session_id

  Hi, I am monitoring the session_id of a large query which denormalises data into a large single tab…

  jonwolds

  8 replies

  15 years, 4 months ago

  By: jrstern

• Help with query to find all BLOB columns that have an index.

  I'm looking for a query that would show me all BLOB columns that are indexed so I can plan for offl…

  toddrharrison

  15 replies

  15 years, 4 months ago

  By: SQLRNNR

• Table to Table with SUM

  Hi, I have a table - Table 1 which has the following fields - [Fault] [varchar](20) NULL, [Occurred…

  AlanPBates

  6 replies

  15 years, 4 months ago

  By: Lowell

• xp_cmdshell says executing but nothing happens

  xp_cmdshell is enabled I run the following and it says executing but nothing actually happens it ju…

  sunshine-587009

  8 replies

  15 years, 4 months ago

  By: sunshine-587009

• Running total query

  I got part of the following idea off a post I saw on Joe Selko's blog... sorry, can't remember the …

  ta.bu.shi.da.yu

  3 replies

  15 years, 4 months ago

  By: ta.bu.shi.da.yu