SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Create Login?!

  manually created a user on the server and in the db - ts_admin. server role - sysadmin db roles - d…

  estuart

  5 replies

  14 years, 4 months ago

  By: Steve Jones - SSC Editor

• General - Point in the right Direction Pls!!!!

  I have an existing application - PowerBuilder 12.5 running on Sybase. All is good. I now have a cl…

  estuart

  1 replies

  14 years, 4 months ago

  By: KevinGurney

• Distinct combinations for a group

  Hi, I Have similar requirement. If anyone solve this, pls let me know. Explanation of the problem. …

  dinesh.spn

  1 replies

  14 years, 4 months ago

  By: Jason Selburg

• Generating Combination Numbers

  Hi friends, I have a scenario where the table values are ID First Second 162 142 122 26…

  varunfilim

  2 replies

  14 years, 4 months ago

  By: dinesh.spn

• guidance needed for troubleshooting an application timeout issue

  I would appreciate some assistance / guidance in troubleshooting an (ASP.NET) application time-out …

  kevinw1970

  6 replies

  14 years, 4 months ago

  By: Evil Kraig F

• Typical Constraints in a database

  Hello, I am in the financial domain and am setting up a staging area between databases in different…

  kanuri.sandeep

  3 replies

  14 years, 4 months ago

  By: kanuri.sandeep

• Date function in sql server 2005

  Hi Alll, We have requirement to calculate the last data of the corresponding week . Let me explain …

  getalok_akg

  8 replies

  14 years, 4 months ago

  By: Ajay.Kedar

• Inserting into an associative table

  Hi guys: I have 3 tables. Industry, IndustryAss(Associative table) and Company. I am modelling a ma…

  martintalero

  10 replies

  14 years, 4 months ago

  By: ChrisM@home

• Database Mail..create alert..troubleshooting..

  I must have tried everything, every step recommended via GOOGLE search referencing SHORT OF WRITING…

  ryan.rph

  2 replies

  14 years, 4 months ago

  By: Steve T

• Join local MSACCESS table is MUCH faster using view instead of stored procedure

  I am converting an Access db to SQL Server. In many cases I am a bit fuddled on the appropriate tim…

  pdanes2

  4 replies

  14 years, 4 months ago

  By: Dan W-960228

• Identifying hidden characters (pipes)

  Hi there At my firm we are currently having issues where users are copying and pasting information …

  jlivings

  4 replies

  14 years, 4 months ago

  By: jlivings

• Combine data from two databases on different servers

  Hi all, I was wondering how I can pull data from two different databases that sit on two different …

  db2mo

  5 replies

  14 years, 4 months ago

  By: Daniel Bowlin

• updating a table based on another table with concatenated results

  [X] [ID] [int] NOT NULL, [Type] [nvarchar] [Plannned] [nvarchar] [Y] [ID] [int] NOT NULL, [T…

  SQLTestUser

  1 replies

  14 years, 4 months ago

  By: bhupendra.patel

• Multipart identifier cannot be bound error on update

  update permanentCM SET X.Validate = (Select Y.Comment where X.Id = Y.problemId) where exists (Sel…

  SQLTestUser

  1 replies

  14 years, 4 months ago

  By: sixthzenz

• Troubleshooting User's Permissions

  Looking for someone to point me in the right direction. We have recently switched to using Active D…

  Bruce Hendry

  2 replies

  14 years, 4 months ago

  By: Bruce Hendry