T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• how to separate value columns my matching two flag

  Hi SQL gurus, I have a table below; FLAG1 | FLAG2 | YEAR | PERIOD | AMOUNT ---------------…

  yingchai

  12 replies

  13 years, 12 months ago

  By: yingchai

• Update table on a different server using linked server queries.

  Hi All, I am updating a table TabX on DBX of ServerX from ServerY with a stored procedure using li…

  anand_vanam

  3 replies

  13 years, 12 months ago

  By: Mark Anderson-446267

• how do you create place values for columns that may not have values in them

  Currently, my sql statement retrieves values for only two of possibly four values, therefore it cre…

  xenophilia

  2 replies

  13 years, 12 months ago

  By: xenophilia

• Cursor help

  Hi guys I need to calculate a patient’s length of stay for every nurse station that patient has bee…

  piotrka

  15 replies

  13 years, 12 months ago

  By: CapnHector

• Create script to split databases into 5 groups based on database size

  The background for this is that I am trying to create a table that gives a list of all databases in…

  pamozer

  10 replies

  13 years, 12 months ago

  By: Jeff Moden

• Date Format to String

  Hello Everyone I know this is simple to most, but I cannot seem to get this correct. I am having is…

  AndrewSQLDBA

  8 replies

  13 years, 12 months ago

  By: Sean Lange

• error

  hi exp(sum(log(CASE WHEN field = 0.0 THEN 1 WHEN field IS NULL THEN 1 WHEN field= -100 THEN 1 ELSE …

  hbtkp

  2 replies

  13 years, 12 months ago

  By: SQLRNNR

• Query to pull different grade level students

  How can I write one query to limit records? Schoolname, Grade Pathfinder K South Shore 2 Whittier K…

  sqlfriend

  5 replies

  13 years, 12 months ago

  By: sqlfriend

• floating error

  hi i am using 1 expression in my tsql and getting error like Arithmetic overflow error converting …

  hbtkp

  10 replies

  13 years, 12 months ago

  By: Lowell

• Alternate to context based search

  Hi, I have a proc like this: CREATE PROCEDURE GetSearchText @Filter VARCHAR (50), @Context VARCHAR …

  Sathishk

  7 replies

  14 years ago

  By: Chuck Hoffman-291200

• Enumerate single row to multiple rows

  I am having a table A with two columns RoomID and BedCount. The purpose of the application is to al…

  logicwonder

  3 replies

  14 years ago

  By: logicwonder

• Group Current and Previous Month of 22-Work-Day-Dates By a "Group Number"

  I need to group together each work-day date for both the current month and the previous month. Furt…

  Scott Solice

  12 replies

  14 years ago

  By: Scott Solice

• Transaction Count after Execute error

  I'm trying to troubleshoot a stored procedure error and not having much luck so far. I have a proce…

  Jason Whitish

  7 replies

  14 years ago

  By: Orlando Colamatteo

• Getting the Distinct group of records in one single record

  In my below query, if the data from the 1st column (DepartureTime) up-to-the 2nd last column (Valid…

  sbj1411

  11 replies

  14 years ago

  By: sbj1411

• Shifting values to the left

  Hi, does anyone know of an easy/direct way of doing this? I have three address fields: addr1, addr2…

  Mike Scalise

  17 replies

  14 years ago

  By: drew.allen