T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Selecting year value from date field

  Hello all! I have a simple issue but couldn't resolve it yet. About four years ago I managed to bui…

  priest Ivan Delic

  2 replies

  11 years, 6 months ago

  By: priest Ivan Delic

• regarding validations in stored procedure

  Hi all, 1.I have input parameters like @age,@date, @time And @gender and output parameter was @paid…

  p.avinash689

  1 replies

  11 years, 6 months ago

  By: Stuart Davies

• spliting nested string

  Hi all, I want to split a string into table structure. my string looks like '1:1,3,5,7,4:56,43,58,5…

  Anamika

  11 replies

  11 years, 6 months ago

  By: Dwain Camps

• User scalar function returning null value

  Hi , I have a function which is returning the null, can some provide your inputs to get this sorted…

  Suresh Babu Palla

  11 replies

  11 years, 6 months ago

  By: John Mitchell-245523

• Help with conditional trigger

  Hi, I've created a trigger which copies data from table ENBRH to table AMBUDG if a specific column …

  boettger.andreas

  1 replies

  11 years, 6 months ago

  By: spaghettidba

• Insert into with Multiple select statements

  Hi All, I have a table with 10 number of columns, out of 10 five need to get the data from differen…

  Suresh Babu Palla

  6 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• ltrim rtrim Causing Floating Field to Round up??

  Hello - I have a Select query that pulls data from a view. In my Select query I have the line ltrim…

  david.ostrander

  5 replies

  11 years, 7 months ago

  By: ParulPrabu

• T-SQL

  How can I create a text file which will have the name of the value in a column which is unique for …

  mtz676

  19 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• regarding sql query

  i have 10 records in sql table . the records contains data as gender with male and female. please r…

  p.avinash689

  5 replies

  11 years, 7 months ago

  By: mister.magoo

• Cursors and EXEC sp_makewebtask

  I have a table with 10 columns. One of the column is NAME with 10 distinct names in it. Each NAME h…

  mtz676

  2 replies

  11 years, 7 months ago

  By: Jeff Moden

• distinct columns

  i have a table with no unique fields but and when i use distinct for column1 then it gives 3000 row…

  scottichrosaviakosmos

  5 replies

  11 years, 7 months ago

  By: Dwain Camps

• Top 1 not return null

  I want to select top 1 value either null or value from this query select top 1 column5 from table2 …

  Ali.M.Habib

  9 replies

  11 years, 7 months ago

  By: mister.magoo

• convert Row to column.

  Hi, How to convert row to column for the below eg. I used pivot to do this. But i am getting only …

  dpalani

  5 replies

  11 years, 7 months ago

  By: Sean Lange

• master.dbo.xp_cmdshell 'C:\WINDOWS\system32\notepad.exe'

  i want to be able to call a exe from mssql my program is call scramble.exe held in c:\test i have u…

  gerard flynn

  6 replies

  11 years, 7 months ago

  By: feleouet

• Unpivot SQL Query

  I have a table structure (tblmapping) like the following: TableName ColumnName ColumnValue Product …

  rs80

  1 replies

  11 years, 7 months ago

  By: Dwain Camps