T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help Required

  Hello Everyone. I need your suggestions on the following. I have a 3 Tables 1) Iss (IssID, subject,…

  a4apple

  13 replies

  13 years, 7 months ago

  By: Sean Lange

• Help Needed

  Hi, we are having one table (AA) with 3 columns Id,Polcinumber,date 1,s1234,04/09/2012 2,s2345,05/0…

  Diyas

  4 replies

  13 years, 7 months ago

  By: ChrisM@Work

• Facing Problem while executing bcp with stored Procedure having parameters

  Hi, I'm getting a error: BCP host file must contain atleast one column Below is my Code: bcp " exe…

  milandas56

  1 replies

  13 years, 7 months ago

  By: milandas56

• Practical used of database id

  Hi, Recently i came across something like databaseid. I search for it on internet but could not com…

  Shadab Shah

  5 replies

  13 years, 7 months ago

  By: Alan Burstein

• script for login enbled or disabled

  Hi, Can anyone help me out to get a script to know if a login is enabled or disabled.As in case of …

  stillconfused

  1 replies

  13 years, 7 months ago

  By: SQLRNNR

• SQL help

  I need some assistance in finding records from a table where a certain ID exists within close proxi…

  woody_rd

  12 replies

  13 years, 7 months ago

  By: Greg Snidow

• Deriving a new DATETIME field column from an existing DayOfMonth column

  I've three columns as FlightNumber(int), ScheduleDepartureDate(datetime), ActualArrivalDay(tinyint)…

  sql1411

  4 replies

  13 years, 7 months ago

  By: sql1411

• Query runs forever following database migration (2005 - 2008)

  Hi, I recently migrated a database which resided on our old 2005 server to our newer 2008 productio…

  DBANewbie

  4 replies

  13 years, 7 months ago

  By: DBANewbie

• Deleting duplicate record

  Hi, I have a table likeCreate table demo(nvarchar(20)) It has following recordsinsert into demo val…

  Shadab Shah

  21 replies

  13 years, 7 months ago

  By: Lynn Pettis

• Loading the distinct rows in the destination table fromt the source table with some logic

  Please take a look at the below details and let me know if anyone can help. I'm trying to write a s…

  sql1411

  8 replies

  13 years, 7 months ago

  By: sql1411

• How to find a Query in all stored procedure

  Hi, I have database with over 100 SP. Now i have a query which i am suppose to search in all SP. I …

  Shadab Shah

  30 replies

  13 years, 7 months ago

  By: Eugene Elutin

• CASE STATEMENTS

  I have two identical queries with only one filter difference between the two queries. Can anybody s…

  vivekkam

  4 replies

  13 years, 7 months ago

  By: Luis Cazares

• string manipulation - Need help !

  Hi All, Can anyone help me with below sql server 2005 and up: input string: BUILTIN\ADMINISTRATORS:…

  SQLQuest29

  13 replies

  13 years, 7 months ago

  By: Dwain Camps

• Fiscal Dates

  My company wants to create a Financial Calendar Table which contains only the Fiscal Dates. The req…

  rka

  7 replies

  13 years, 7 months ago

  By: Ron McCullough

• cursor error in a stored procedure.

  Hi All, i am trying to clean up my temp table sin tempdb database that are older than 24 hours. dur…

  BoobyB

  14 replies

  13 years, 7 months ago

  By: RBarryYoung