Development

• Topics

  Started by

  Posts

  Last post

• Join problem when convert joins with non ansi to ANSI format

  --First Query SELECT DISTINCT branch.branch_no, branch.branch_name, site.site_no FROM site, cust…

  girishk

  7 replies

  13 years, 5 months ago

  By: mrmkhokhar

• How do i drop identity for a Column

  Hi guys, I have a table Devices and i am copying the structure of the table to temp table for furth…

  patelmohamad

  12 replies

  13 years, 5 months ago

  By: John Mitchell-245523

• sql server 2005

  can you help me please Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be…

  eboucicaut

  2 replies

  13 years, 5 months ago

  By: eboucicaut

• Adding Primary key column to existing table

  I have a table with 10000 records. The table does not have any primary key constraint. Now i want …

  phareesh

  5 replies

  13 years, 5 months ago

  By: jemish.dave

• Get last record within group of dates

  Hi! I am needing some assistance with a date query. I have data that looks like this: Date column …

  Tammy Robinson

  7 replies

  13 years, 5 months ago

  By: Tammy Robinson

• Create Job

  could you help me please. Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "SQLNCLI" for …

  eboucicaut

  1 replies

  13 years, 5 months ago

  By: Sean Lange

• Syntax help on how to change a column from asc to desc?

  Syntax help on how to change a column from asc to desc? I need to do this across all our tables our…

  D-SQL

  13 replies

  13 years, 5 months ago

  By: Gail Shaw

• sql

  what is insteadof trigger in tsql?

  asranantha

  3 replies

  13 years, 5 months ago

  By: Henrico Bekker

• Data tuning in SQL 2005

  Sir/s, I'm using SQL 2005 and our Database size is 6.18 GB now and currently I'm facing problem of …

  mukund.bklwh

  6 replies

  13 years, 5 months ago

  By: Lynn Pettis

• sql doubts

  Hi friends, i have small doubts in sql server.plz tell me the answers 1)why a table …

  asranantha

  4 replies

  13 years, 5 months ago

  By: Andy Hyslop

• Enabling Cascade Update on multiple FK joins between different columns in a data table, and the same reference table

  I am having difficulty enabling 'cascade update' between a reference table, (say - Job Status), and…

  Anthony Graham SHELLSHEAR

  1 replies

  13 years, 5 months ago

  By: timothy.oliver

• Pivot Data

  Hi All I would like to get some help / advise on how to do below - I have a table with all staff w…

  vani_r14

  6 replies

  13 years, 5 months ago

  By: Andre Guerreiro

• Split Values

  Hi all i have a requirement where one value has to be split into two if it meets a requirement. e…

  vani_r14

  5 replies

  13 years, 5 months ago

  By: spaghettidba

• rows into columns

  Hi Everybody! Looking for a solution that would create columns out of rows. Here's sample data: ---…

  justforgroups2004

  7 replies

  13 years, 5 months ago

  By: Cadavre

• SQL Query Help

  I have a table like this ChoiceId| ChoiceName |QuestionId 101655|3 Months | …

  dprasannain

  2 replies

  13 years, 5 months ago

  By: dprasannain