T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Data Type Comparison TSQL

  I have 3 tables with following columns Table A ID int Value varchar(max) Example Data 1 3,620.00 2 …

  LOOKUP_BI-756009

  14 replies

  14 years, 8 months ago

  By: TheSQLGuru

• can't use column in aggregate or group by - but need it to calc qty

  I've created a view in SQL 2008 with the sql code below. The problem column is i.QTY I need the per…

  TC-416047

  6 replies

  14 years, 8 months ago

  By: LutzM

• Convert Military date to standard

  I have a date in the following format, how do I convert it to standard date format: 2011-03-01 13:1…

  ramadesai108

  8 replies

  14 years, 8 months ago

  By: Orlando Colamatteo

• How replace

  Hi everybody, I has created a user function that replace any digit that don't been letter or number…

  Lisset

  9 replies

  14 years, 8 months ago

  By: Jeff Moden

• Script to generate a SQL table from a table structure (from the field names)

  I have a Customer table comprised of columns CustName, Addr1, Addr2, City, State , Zip, and YTDPurc…

  GaMusicMan

  4 replies

  14 years, 8 months ago

  By: SQLRNNR

• Find missing records

  Hi All Can somebody possibly provide some advice to help with a problem I have please? I have a tab…

  AlfredEnewman

  2 replies

  14 years, 8 months ago

  By: AlfredEnewman

• Non-Deterministic UDF and Persisted Columns

  Hi - I've been searching everywhere to find a solution for this problem -- not even sure if its rea…

  kramaswamy

  6 replies

  14 years, 8 months ago

  By: Mike Tutor

• sql for building dynamic columns and rows from 2 tables.

  Table 1: SortSeqID ColumnHeader 1 ‘ColA,ColB,ColC’ 2 ‘ColA,ColB,ColC,C…

  npranj

  2 replies

  14 years, 8 months ago

  By: npranj

• Urgent-------Export all tables in a schema to multiple textfiles in a pipe delimited format

  Friends, Please help me! I have 3 schemas in a database and each schema has about 300 tables.Busine…

  santu4bth

  5 replies

  14 years, 8 months ago

  By: Jeff Moden

• datetime => how to have complete date with 00:00:00.000

  Hi, i work with sql server 2005 and i 'm a beginner I have a table with a column datetime. in this …

  bernardchristophe

  16 replies

  14 years, 8 months ago

  By: Jeff Moden

• Generate records based on field value in DB table's records

  Hi everyone, I have the following issue: [Customer Name][Financial Year][No of Years][Total Valu…

  Adelphi

  4 replies

  14 years, 8 months ago

  By: Jeff Moden

• How can I Pass a Table variable in Stored Procedure?

  Hi All, I need to pass a table variable in a stored procedure. Is it possible or not? Actually, My …

  IN_Sandeep

  20 replies

  14 years, 8 months ago

  By: joshgeake

• JOIN WITH IN AND LIKE

  :ermm: I just cant figure out this. I have 3 tables as such Table A Name Gender City Jo M St Lina F…

  LOOKUP_BI-756009

  5 replies

  14 years, 8 months ago

  By: LOOKUP_BI-756009

• Rows to Columns (bit more advance)

  Hi guys, I did ask this question before BUT this time it's harder (else I could have done it lol) I…

  renvilo

  2 replies

  14 years, 8 months ago

  By: renvilo

• sp_executesql giving error inside stored procedure

  Hi All, I have created a dynamic statement using sp_executesql but i am getting below error on exec…

  shatrughna

  2 replies

  14 years, 8 months ago

  By: shatrughna