Development

• Topics

  Started by

  Posts

  Last post

• How to write Update query for this scenario

  RowIdENameProjectTime partHours Worked[14 Jan][15 Jan][16 Jan] 1Emp 1Project 114/1/20107…

  kak.mca

  2 replies

  12 years, 10 months ago

  By: Luis Cazares

• simple update statement

  DECLARE @lClub_group_joined_test varchar(20) SELECT @lClub_group_joined_test = club_grou…

  dallas13

  3 replies

  12 years, 10 months ago

  By: Kingston Dhasian

• UDF AND Stored Procedures

  Hi Guys, I know, the question is Funny, but i want to know the details of stored procedures and UDF…

  patelmohamad

  6 replies

  12 years, 10 months ago

  By: TheSQLGuru

• Search Issue

  I have a table with string column called keywords please find the sample data IDKeyWords 1abc…

  ningaraju.n

  1 replies

  12 years, 11 months ago

  By: John Mitchell-245523

• Query to return the rows with values

  --Sample script CREATE TABLE Professor ( ProfID INT , DeptID INT , ProfName VARCHAR(100) , Cour…

  Durai Samuel

  1 replies

  12 years, 11 months ago

  By: Andy Hyslop

• Reset the Number by Column Value using ROW_NUMBER() OVER (PARTITION BY Field)

  Hi Guys Need your help /* SELECT IDENTITY(BIGINT ,1 ,1) AS RowID ,CAST( '' AS DATETIME) AS Today…

  patelmohamad

  5 replies

  12 years, 11 months ago

  By: patelmohamad

• Deplying CLR Stored procedure

  HI, How can i deploy the CLR Stored procedure to production i.e., different server. thanks, 🙂

  SQL*

  2 replies

  12 years, 11 months ago

  By: Lowell

• XML in SQL Server

  I have a table like below. valuexml_1 1+2<root><s>1</s><s>2</s><…

  MB-1081964

  1 replies

  12 years, 11 months ago

  By: Mark Cowne

• trapping inconsistently linked queries(I posted this request in BI section which might not be the correct one for this, so am posting it again here)

  (I posted this request in BI section which might not be the correct one for this, so am posting it …

  rshekdar

  1 replies

  12 years, 11 months ago

  By: andrew gothard

• sp_send_dbmail attachement EXCEL file has error

  Hi All, Need you help on below. I am generating the excel file and send email using "sp_send_dbmail…

  sunilk.net

  1 replies

  12 years, 11 months ago

  By: Orlando Colamatteo

• condition

  I have a table with 2 columns. plan_type and signles (Y and N -- only 2 values). If plan_type = sta…

  dallas13

  4 replies

  12 years, 11 months ago

  By: dallas13

• Removing trailing spaces in a table column

  Hi I am having trouble removing trailing spaces in a table column (query phrase). so far i have tr…

  Jayanth_Kurup

  6 replies

  12 years, 11 months ago

  By: piyush.varma

• sqlmail timout connection pool

  I am using an SQL Job to call a stored procedure which queries the database to get some email addre…

  lwheeler

  3 replies

  12 years, 11 months ago

  By: lwheeler

• Sorting multiple columns in various sort directions in a case statement

  Hello all, I am trying to implement server side processing for jQuery DataTables so I need to be ab…

  Barry Couch

  13 replies

  12 years, 11 months ago

  By: Orlando Colamatteo

• Enforce Where clause on every update statement

  Hi!! Today I had a problem with an important table on my database. Someone updated all rows in that…

  rpfelgueiras

  10 replies

  12 years, 11 months ago

  By: SqlServerPass