SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Complex View using repeating groups

  Hi, We are struggling with the development of a data view which allows us to group data into batche…

  jon.messer

  3 replies

  13 years ago

  By: ChrisM@Work

• need sequence in datetime

  I am creating a table and I want sequential date ..ist possible? create table daysinfo( COMM1 datet…

  Tiya

  3 replies

  13 years ago

  By: Bill Hansen

• Migrating/Converting SSIS Packages into Stored Procedures

  Hi everyone, I have seen many articles and posts related to migration of Stored Procedures into SSI…

  Bangaaram

  1 replies

  13 years, 1 month ago

  By: jnuqui

• dynamcally expanding columns

  I have an etl process that imports a "flat file". say, it has 2 columns and it is importing fine. …

  light_wt

  3 replies

  13 years, 1 month ago

  By: Edward Boyle-478467

• get results from 2 tables?

  I have a table which holds names and phone numbers and another table that records when they rang, I…

  mick burden

  6 replies

  13 years, 2 months ago

  By: mick burden

• Blowfish Encryption Toolkit on SS 2008 R2

  Hi, I have previously used the blowfish encryption toolkit quite happily in applications using SQL …

  nineteen-red

  5 replies

  13 years, 2 months ago

  By: Lowell

• How do I drop temp tables in Store Procedure?

  Here is the piece of code that is causing the issue: declare @VP_ATTUID varchar(20) declare @…

  ss5523

  7 replies

  13 years, 2 months ago

  By: ss5523

• Performance and Audit Logout

  I've been trying to diagnose some performance issues, I ran the SQL Profiler tool and upon rev…

  Burt

  3 replies

  13 years, 2 months ago

  By: andegre

• set implicit_transactions off permanently?

  I'm a noob just trying to gather information on these 3 minute blocked/blocking issues that we've b…

  bburke-781975

  2 replies

  13 years, 2 months ago

  By: Jeff Moden

• Problems w/Install of Service Pack 4

  I previously downloaded and attempted to instal MSSQL Service Pack4. It appears to go on its merry …

  Thomas Johnson-219652

  5 replies

  13 years, 2 months ago

  By: Asela-398517

• Get the Best out of the Database using Optimal Indexes

  This free webinar is presented by Pinal Dave a Microsoft Technology Evangelist (Database and BI) an…

  gopi 56209

  1 replies

  13 years, 3 months ago

  By: Gail Shaw

• Decimal data type

  All, I have a column configured as data type decimal, precision 10, scale 10. If I try to enter 1.0…

  as_1234

  3 replies

  13 years, 3 months ago

  By: as_1234

• Replication Questions and Issues

  I am somewhat of a new SQL 2000 DBA. Less than 6 months. I have a questing with regards to Replicat…

  jplum

  3 replies

  13 years, 4 months ago

  By: jplum

• Calling an Oracle Stored Procedure and Function

  Hi, I'm trying to call an oracle stored procedure and function via linkedServer but I seem to be ge…

  Brian Connolly

  1 replies

  13 years, 4 months ago

  By: SJanki

• group by/left outer join problem

  I was wondering whether anyone could spot why my 'group by' function is "incorrect Syntax" from the…

  annie.alexander

  3 replies

  13 years, 4 months ago

  By: SQLRNNR