SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Datime from Source into Month_Year and Day Column

  This is my SSIS exercise I have a DATETIME column, what I want is to get the Month and Year from " …

  Citiinvestor

  4 replies

  16 years ago

  By: dan-839063

• Find string in another string during select

  Hi Everyone, This probably has a simple answer that I just can't see now- I have 2 tables with cour…

  bc_ed

  7 replies

  16 years ago

  By: Carleton

• Database schema design

  Hi all. I just need a little advice on database design, as I have been tasked to produce a schema t…

  sql_lock

  3 replies

  16 years ago

  By: Carleton

• Need help on self referenced table's query

  Can someone give me a query string on how to get the following output on my self-referenced categor…

  jasondeocampo

  6 replies

  16 years ago

  By: jasondeocampo

• Script Help

  We have a table that stores the user permissions to specific programs, USER_PGM_AUTHORITY. The tabl…

  bpowers

  11 replies

  16 years ago

  By: bpowers

• Blocking Stored Procedures

  Our company has had many consultants come in over the last few years and apparently one of them wro…

  cindy.hutchins

  5 replies

  16 years ago

  By: cindy.hutchins

• working with single quote ' in sql

  I have 16 digit credit number exporting to excel through asp.net page. when I export to excel it sh…

  reach2sam

  2 replies

  16 years ago

  By: reach2sam

• Reindexing

  I ran a script to reindex all the tables in my database such as sp_MSforeachtable"DBCC DBREINDEX("…

  frank.pron

  2 replies

  16 years ago

  By: Rudyx - the Doctor

• Store a value in an int column with leading zero?

  I have a SAP character-based code that reads 044. When I pass that value to SAP it has to be 044 n…

  MissyDaisy

  3 replies

  16 years ago

  By: PaulB-TheOneAndOnly

• Duplicate Information in my database

  A glitch in my GUI Interface inserted multiple lines into a warehouse table in my database. is the…

  cindy.hutchins

  8 replies

  16 years ago

  By: Nabha

• Nested SELECT to CSV in resultset? Help please?

  I have a select statement that I would like to contain the pipe delimited result set as a row. Bas…

  scott detweiler

  10 replies

  16 years ago

  By: Adam Gojdas

• Execute StoreProcedure paramters

  Hi, I would like to execute the parameters of the storeprocedure. bcz I would like to know what the…

  reach2sam

  3 replies

  16 years ago

  By: PaulB-TheOneAndOnly

• Ensuring a procedure does not get run twice at the same time

  Hi, I'm not sure how to progress with this problem. I've got a procedure that takes a small but not…

  Zadjil

  3 replies

  16 years ago

  By: Zadjil

• Change Default Schema for a Session (not a user)

  I would like to change the default schema programatically for the session the code is running in, i…

  Carleton

  2 replies

  16 years ago

  By: Carleton

• Examples of a template to documenting your scripts.

  Hello, My manager wants me to go through every one's script and put them in one format. Then I wil…

  WebTechie

  4 replies

  16 years ago

  By: WebTechie