SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Dyn SQL - Need results to show when count is 0 group by datetime

  So the guys in charge of this place made some interesting requests and pegged me as the person to d…

  Gohloum

  15 replies

  14 years ago

  By: Cadavre

• How can I find user permissions on stored proce thatdures

  Hi Is there a way I can query to see the user permissions for all the stored procedures? I know I c…

  jdbrown239

  2 replies

  14 years ago

  By: jeetsingh.cs

• Grant Permission to a table with restriction to data

  Is it possible to grant access to specific columns in a table with restriction to the data with a w…

  Jan Sorenson

  7 replies

  14 years ago

  By: jeetsingh.cs

• bulk import help please

  Hi all, I need to be able to import foreight language data into sql server 2K8R2 from csv file. Her…

  RightOnTarget

  11 replies

  14 years ago

  By: RightOnTarget

• Convert DD-Mon-YYYY to DD/MM/YYYY

  I need to convert dt_of_birth [varchar] (15) which is in the format DD-Mon-YYYY to DD/MM/YYYY dt_of…

  arthi.anan

  2 replies

  14 years ago

  By: ACinAZ

• Simple Select Table output (Pivot ?)

  Declare @test-2 Table (First Nvarchar(10), Last Nvarchar(10)) Insert into @test-2 (First, Last) v…

  mfink

  3 replies

  14 years ago

  By: Luis Cazares

• Editing Stored Procedures in SQL 2005?

  Ok, so I am a little late ... Migrating a db server from MS SQL Server 2000 to 2005. In SQL 2000 …

  britinusa

  3 replies

  14 years ago

  By: Lowell

• Stored procedure to split and insert values into tables

  I have an empty employee table and employee_details table. The temp table which i created say it ha…

  arthi.anan

  12 replies

  14 years ago

  By: Sean Lange

• Create and populate a Zip file

  I have a small program that runs every day from my client machine that creates a new zip folder on …

  Jim

  11 replies

  14 years ago

  By: P Jones

• select top 1 in subquery returns multiple records

  Hi I have two tables: table contact1: obviously contact information table contsupp: a catch-all for…

  ksharpe

  27 replies

  14 years ago

  By: RonWeyforth

• How to select data (two columns) from table based on a composite unique value and insert in another table?

  I have a table CustomerMaster and the two fields in it - CustomerID and Source - give me unique val…

  SQL_beginner1

  1 replies

  14 years ago

  By: Gazareth

• Adding a composite record to 2 tables

  I need to add records to a DB on SQL Server 2005. Each composite record represents a project in the…

  agabb

  4 replies

  14 years ago

  By: Gazareth

• Trying to get started with Full Text Searching

  This is all new to me, we normally don't do much programming here and I've not had much luck gettin…

  n.heyen

  2 replies

  14 years ago

  By: n.heyen

• SSIS failure constraints

  hello all... i have created an SSIS package which works beautifully until i come to the final task,…

  danawexler

  3 replies

  14 years ago

  By: danawexler

• Upgraded SQL Server 2005 to SQL Server 2008, but it still reports 2005

  I upgraded my SS2k5 instance to SS2k8 using the standard upgrade process from MS, but the instance …

  Jim

  31 replies

  14 years ago

  By: Vegard Hagen