SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• selecting data and putting it in email @body

  Hi guys! I´ve a table with several records; CREATE TABLE [dbo].[correosaclientes]( [cliente] [varc…

  igngua

  5 replies

  14 years, 8 months ago

  By: igngua

• Subquery

  Current Query: USE [AssetLending] GO /****** Object: View [dbo].[AssetsWithCurrentTrans] Scrip…

  Jim

  3 replies

  14 years, 8 months ago

  By: Jim

• (ask) query SQL about my stock list of items

  Hi all, I am a Newbi DBA and I have a case in my job. the case look like this; i have a table of my…

  kurniawan.kumala

  21 replies

  14 years, 8 months ago

  By: Dave Ballantyne

• Constantly polling SQL query to day and time for a weekly report

  Hi, Complete beginner to SQL but what I am after is a query for a SCADA system. The "WHERE" clause…

  brett.y

  4 replies

  14 years, 8 months ago

  By: brett.y

• Where does the Schema Design Fit in?

  I am a new DBA with no mentor, not even 8months into this job. I am a mechanic by trade and have be…

  Mrfixit1170

  7 replies

  14 years, 8 months ago

  By: Mrfixit1170

• T-SQL DATEDIFF problem

  Hi Guys can you please help me on this. If I use like: PRINT DATEDIFF(month,'2010-06-07 00:00:00.00…

  abd_wad

  4 replies

  14 years, 8 months ago

  By: GSquared

• Edit a datetime field

  I maintain a database in our hospital of data collected from different pieces of equipment. I have …

  eyejay

  6 replies

  14 years, 8 months ago

  By: spaghettidba

• How to do UNPIVOT with dynamic column names within a FUNCTION

  Hi, I have a problem and I hope you can help me. I need to use UNPIVOT inside a user defined functi…

  nemesis52

  7 replies

  14 years, 8 months ago

  By: Jeff Moden

• Select only upper case data in field

  If I have in a field ANBDS ABV DD !DF @DSF DF:FF HgJJ How can I get only: ANBDS ABV DD HGJJ I know …

  Digs

  2 replies

  14 years, 8 months ago

  By: Digs

• Table designed check for FAST SELECT Speed

  CREATE TABLE [dbo].[DIM_Data_OHLC]( [RecID] [int] IDENTITY(1,1) NOT NULL, [Symbol] [varchar](10) …

  Digs

  3 replies

  14 years, 8 months ago

  By: LutzM

• Deny user to start and stop SQL services

  Hi, Recently in our team a new developer has joined I was given a task of allocating creating the u…

  RaviShankar1234

  6 replies

  14 years, 9 months ago

  By: Geoff A

• Concatenate row values

  Hi! I´ve the table USE [labmanager2] GO /****** Object: Table [dbo].[DESTINATARIO] Script Date:…

  igngua

  1 replies

  14 years, 9 months ago

  By: GSquared

• DDL Trigger

  we have maintenance plan that is executed as job everynight at 1:30 am. This maintenance plan has u…

  RaviShankar1234

  3 replies

  14 years, 9 months ago

  By: RaviShankar1234

• Add variable to @body in msdb.dbo.sp_send_dbmail

  Hi ! I´m setting up a trigger to execute msdb.dbo.sp_send_dbmail. The mailing is working also the t…

  igngua

  3 replies

  14 years, 9 months ago

  By: igngua

• New Stored Procedure

  I know this is more complex than it has to be. I'm doing it this way to learn stored procedures and…

  Jim

  5 replies

  14 years, 9 months ago

  By: spaghettidba