SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• conversion from access to sql server..

  i try to convert from access database to MSSQL Server but there's an error the error msg is "Attach…

  john_edman24

  1 replies

  12 years, 4 months ago

  By: Sean Lange

• How to select an single rows to multiple columns

  I am Ramanathan and working in SQL SERVER 2008….Please help me Table1 Location--Field A1 A2 A3 B1 B…

  ramanathan.raman88

  1 replies

  12 years, 4 months ago

  By: Ant-Green

• Sleeping Process...

  Hi, Can anyone get back to me with tips regarding this. I am gettign connection pool error while u…

  bytezone

  3 replies

  12 years, 4 months ago

  By: Gail Shaw

• Some Help getting started with MDX

  I have a measure circ that should roll up along some dimensions but there are three dimensions wher…

  BRIAN.ZWILLING

  3 replies

  12 years, 4 months ago

  By: swapp

• Random String on Record Creation

  I want to create a random string each time a new record is ceated in the database. I have the SQL c…

  AFIFM

  13 replies

  12 years, 5 months ago

  By: Lynn Pettis

• many to many join and union all

  I'm having a hard time with this query this afternoon. I have 3 tables cash, revenue, expense. I …

  wtolbert

  15 replies

  12 years, 5 months ago

  By: wtolbert

• Analyst seeking wisdoms while learning the platform

  Im a business/financial/data analyst who wishes to make a transition to a BI solutions development/…

  vega805

  11 replies

  12 years, 5 months ago

  By: Sean Lange

• Calling SQL Stored Procedure from C# code

  Hi guys, Looking for some assistance with an MS CRM environment. Basically there is a stored proced…

  angelinemarren

  1 replies

  12 years, 5 months ago

  By: angelinemarren

• Fixing reference to the object

  Hello, I have swapped the names for multiple tables using sp_rename. The SPs and views which were a…

  Knowledge Hunter

  1 replies

  12 years, 5 months ago

  By: Knowledge Hunter

• Linked Servers Error

  MSSQL Server A: MSSQL2000 - set to Windows Authentication mode MSSQL Server B: MSSQL2000 - set to S…

  MSSQL_NOOB

  5 replies

  12 years, 5 months ago

  By: handkot

• Microsoft Certified Solutions Associate (MCSA)

  Hi, I want to do MCSA exam. Do any dump available for this? Please let me know. Thanks, Anandh

  sanandh87

  2 replies

  12 years, 6 months ago

  By: Gail Shaw

• lock table during index creation

  Hi, I need to create 2 indexes on a large table (~200 million records). I wanted to lock the entir…

  sqlblue

  6 replies

  12 years, 7 months ago

  By: Gail Shaw

• Count duplicate occurances in relational tables

  I am fairly new to SQL and pressed for time. I don't think this is difficult to do but I can't seem…

  dean-hodgson

  4 replies

  12 years, 8 months ago

  By: dean-hodgson

• query to count repating alphabet in a string

  declare @asd varchar(20) set @asd ='asdaaaadffa'

  saltpepo

  11 replies

  12 years, 8 months ago

  By: Dwain Camps

• The log for database 'DBNAME' is not available.

  Hello, I have a database problem since yesterday. -------------------------------------------------…

  dtraian

  2 replies

  12 years, 8 months ago

  By: dtraian