SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Daily Count every nth hour

  Hello Gurus, I need your help in calculating count and average daily every hour starting 4:30 even…

  SQL_path

  4 replies

  11 years ago

  By: SQL_path

• Use row_number() as default value of table column

  Is it possible to use the row_number function as the default value of a table? I've searched all ov…

  sKreetz!

  12 replies

  11 years ago

  By: Eirikur Eiriksson

• Query table

  I am trying to query a table that has data stored week wise in columns like this .... SELECT [Name…

  sharonsql2013

  5 replies

  11 years ago

  By: sharonsql2013

• Column 'Basic_Data.School_Year' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

  Hello, I have the following query and I'm getting the following error. Msg 8120, Level 16, State 1,…

  Ashish Dutt

  6 replies

  11 years ago

  By: Eirikur Eiriksson

• accidentlly stored several t-log backup in 1 file.

  Greetings all. Coming from Oracle trying same logic on SQL Server (2008R2 in this case). Trying to…

  dvdzalm

  2 replies

  11 years ago

  By: dvdzalm

• Should I have a date column when one of the other colums contain a date

  I need to save a serial number. The serial number consist of a date and a sequential number, e. g. …

  andis59@gmail.com

  3 replies

  11 years ago

  By: andis59@gmail.com

• Can I change my clustered index from a primary key to an Identity field?

  I have a fairly large table of about 17 million rows and the people who originally designed the tab…

  dcadler

  6 replies

  11 years ago

  By: dcadler

• Query issue pulling data over ODBC connection

  Hello all, I'm not really sure what level of expertise folks may have in the ODBC realm here. If th…

  Herpington_McDerpington

  3 replies

  11 years ago

  By: Eirikur Eiriksson

• SQL Query....

  I need to run a compare and return differences. I am finding it tough to express the SQL query in a…

  James.Rivers

  5 replies

  11 years ago

  By: ChrisM@Work

• declare @str varchar(100)='My name is Shiva' --Need output like : Shiva is name My

  declare @str varchar(100)='My name is Shiva' --Need output like : Shiva is name My Thanks, Shiva N…

  Shiva N

  8 replies

  11 years ago

  By: Eirikur Eiriksson

• How to get DATETIME number?

  Hi! Table: CREATE TABLE [dbo].[Weight_table]( [Weight_id] [int] IDENTITY(1,1) NOT NULL, [dato] [d…

  Edvard Korsbæk

  7 replies

  11 years ago

  By: Jeff Moden

• Useful Tools/Add-Ins?

  Hello, I have been using SQL for a little while mostly querying for retrieving data. I am learning…

  mmullen 48200

  4 replies

  11 years ago

  By: CKX

• Using sp_send_dbmail with file attachments

  I have a question on using sp_send_dbmail with file attachments. I know that you use this format: …

  mmullen 48200

  1 replies

  11 years ago

  By: ZZartin

• Check format of String

  Hi All, I'm looking to put a script together to flag the format of a string as (true/False) example…

  DBayliss

  3 replies

  11 years ago

  By: DBayliss

• A better way to query data currently being done with a linked query in Access

  I have a view built in SQL that pulls all of our sales orders, items, descriptions, quantities, and…

  jirish

  4 replies

  11 years ago

  By: pietlinden