SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• not able to attach Database. getting file path error

  TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed…

  siri_rmsi

  8 replies

  11 years, 5 months ago

  By: Sean Lange

• Need help evaluating my data import procedure. - Noy Hadar

  I am new to php and sql, but learning fast. I'm trying to understand the behavior of the db when i…

  noy2014

  1 replies

  11 years, 5 months ago

  By: CKX

• ORDER BY in a view

  Hi, I'll keep this as short as possible. I've read many of the posts re: order by in a view (searc…

  Scott In Sydney

  5 replies

  11 years, 5 months ago

  By: Scott In Sydney

• Flatten table and count number of occurrences per empid

  Hi all, I have a table that contains multiple activities by empid and I need to rollup counts on ea…

  caoneill

  3 replies

  11 years, 5 months ago

  By: Eric M Russell

• UPDATE THE IDENTITY FIELD OF EXISTING RECORDS

  Hello, I am trying to update the existing identity field as I want to increment the values and impo…

  duncanlarry

  1 replies

  11 years, 5 months ago

  By: Sean Lange

• Pivot over multiple columns using the 1.1, 1.2, 2.1, 2.2 sequence

  I am using the following stored procedure which is then used in a tableadapter. My problem is that…

  LHendren

  4 replies

  11 years, 5 months ago

  By: LHendren

• Help with Max Date/Time and IsNull

  I'm trying to write a view that pulls a column with Null values, but also uses the MAX function to …

  Lavery

  9 replies

  11 years, 5 months ago

  By: mthurber

• Trying to get Null values while also using MAX

  I'm trying to write a view that pulls a column with Null values, but also uses the MAX function to …

  Lavery

  7 replies

  11 years, 5 months ago

  By: mthurber

• Trying to parameterise code executed by sp_executesql

  I'm trying to parameterise code executed by sp_executesql. It's not a stored procedure, I've just …

  Scott In Sydney

  2 replies

  11 years, 5 months ago

  By: Grant Fritchey

• This Query is Filling up TEMPDB

  I am very new to SQL server Querying. I see the following Query causing my tempdb's to fill up dra…

  JeepHound

  6 replies

  11 years, 5 months ago

  By: JeepHound

• Monthly data

  I am trying to bring in data for last 6 months . However , there is data only for May and June so t…

  sharonsql2013

  1 replies

  11 years, 5 months ago

  By: Luis Cazares

• Regarding sql profiler

  Is there any thing oracle sql developer same like sql profiler.. I have trace action of front end i…

  selpoivre

  2 replies

  11 years, 5 months ago

  By: Grant Fritchey

• Function Calls two other functions - If, else - then used in View - Is it OK or can it be improved

  This function is in a view - linked to MS Access that uses a query to pass one ID_Well at a time, t…

  Mile Higher Than Sea Level

  11 replies

  11 years, 5 months ago

  By: Lynn Pettis

• Counting rows from last date

  Im trying to count the number of rows with a PSIOutcome of 0 starting from the last month by Divisi…

  boehnc

  1 replies

  11 years, 5 months ago

  By: Luis Cazares

• Order of IN operator

  select empid from consumer where empid in (2323,1236,5623) I want result would be of same order as …

  selpoivre

  7 replies

  11 years, 5 months ago

  By: Luis Cazares