T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Convert VChar(100) to GUID in a stored proc

  I have a classic asp page that is accessed via different pages. In some situations the: Request.Que…

  Faye Fouladi

  1 replies

  16 years, 4 months ago

  By: Gail Shaw

• Convert VChar(100) to GUID in a stored proc

  I have a classic asp page that is accessed via different pages. In some situations the: Request.Que…

  Faye Fouladi

  1 replies

  16 years, 4 months ago

  By: Gail Shaw

• bcp and literals

  Hi all, I'm trying to use bcp to export results of a query, the problem is the database uses a col…

  thombaugh

  2 replies

  16 years, 4 months ago

  By: thombaugh

• Pattern matching in TSql

  Hi, This is regarding pattern matching in Tsql Query I have table with the following columns and co…

  naveenreddy.84

  8 replies

  16 years, 4 months ago

  By: Nabha

• Hourly Group By

  Hi, I having a table Sales with the following columns: a. SalesDT (datetime) b. SalesAmt (float) c.…

  setlan1983

  20 replies

  16 years, 4 months ago

  By: Jeff Moden

• Extracting XML data and constructing query string

  Hi Guys REQUIREMENT: we have to compare the selected values and display filtered data to the client…

  neens_1602

  2 replies

  16 years, 4 months ago

  By: neens_1602

• SQL Server not evaluating WHERE before Casting?

  I have encountered some odd behavior in SQL Server 2005 which is messing with my ability to get som…

  gary.wood

  13 replies

  16 years, 4 months ago

  By: The Dixie Flatline

• script to create indexes existing in a database

  Hi I want a script to get 'create statement' for all indexes existing in a database with out using …

  pmadhavapeddi22

  3 replies

  16 years, 4 months ago

  By: Lowell

• Merge Multipal views into one

  Hi have a number of views that collect data from a number of tables. Small example, I need to get p…

  albertvanwyk

  3 replies

  16 years, 4 months ago

  By: dbo.benyos

• find the position of the charcter in delimited string

  D/A, Pls help..to find the position of the character. Comma should be replaced with "*" and psotion…

  gugan_ta

  26 replies

  16 years, 4 months ago

  By: The Dixie Flatline

• no of rows in all tables in a single query

  Hi Consider the below query to get table_name,column_name,data_type,and constraint_name, I want to…

  pmadhavapeddi22

  1 replies

  16 years, 4 months ago

  By: dbo.benyos

• FIFO

  HI, I want to implement FIFO logic in Inventory Ageing report For example As of Date i hve remainin…

  Motz

  1 replies

  16 years, 4 months ago

  By: drew.allen

• UDF error on executing scalar function on linked server

  So I have an inline table function and a scalar function on a remote server that I am trying to exe…

  J.O.

  3 replies

  16 years, 4 months ago

  By: J.O.

• Convert for hh:mm:ss

  Is there a built in function / expression in 2005 reporting services that will allow you to convert…

  Bob Boursaw

  5 replies

  16 years, 4 months ago

  By: Bob Pinella

• SortOrder - differnt results on two different SQL servers that are different patch levels

  So a query runs on SQL Server A and it returns in the "proper" and expected order, it runs on Serve…

  Maxer

  9 replies

  16 years, 4 months ago

  By: Matt Miller (4)