Programming SQL
in [Microsoft SQL Server]
|
Partition, sum and....? I have a table where each record is a newspaper article, having this structure: idArticle dateArticle idNewspaper (relationed with other table) idArgument (relationed with other table) title timesRead (times the article has been read). I want to select for each article title, the sum of timesRead for all th... 13 Mar 2010 14:15
stored procedure syntax? Andrew wrote: ALTER PROCEDURE [dbo].[UpdateInvitation] -- Add the parameters for the stored procedure here @SentToUserId INT ,@SentToEmail VARCHAR(50) ,@SentByUserName VARCHAR ,@SentByEmail VARCHAR ,@SentDateTime SMALLDATETIME ,@ViewRate SMALLINT ,@CategoryName VARCHAR ... 12 Mar 2010 20:43
Questions and answers Does anybody knows where can I get some kind of questions and answers for practicing with the Adventureworks database? thanks, alex. ... 12 Mar 2010 18:27
(Advance Programming) Parameter Returned as Value Hi, I wish some body could Help Me, I have being loocking for a solution for 2 days. I need to make a simple Query to check if the parameter values are in a Table. I want the Query to return "Founds" and "Not Founds". For Example: Table Definition: TName CREATE TABLE [dbo].[TName] ( [IdName] [bigi... 12 Mar 2010 16:13
Help with FOR XML I have been reading the FOR XML documentation, and looking at samples on the 'Net. I am trying to produce a string of XML, for testing, that looks like this (slightly edited the values), but I can't quite get there. Declare @IdList XML Set @IdList = '<ArrayOfString> <string>C4DEB399-C9AF-DE11-B9B2-009999999... 12 Mar 2010 20:43
Varbinary - Word Documents I store word documents as var binary and use FullText search to look inside the word documents. The FullText search returns the Id's/Title's of these documents but how is it possible to get a sentence from inside the word document where the search word is a match? An example of this is in sharepoint, when you ... 12 Mar 2010 23:59
Transformation of data into columns Hi, I have the data from a flattened spreadsheet in a table in the following form: f1 f2 f3 period to: Scheme1 Scheme2 31/01/2005 Net Gross 28/02/2005 Net ... 15 Mar 2010 21:52
varbinary(max) field in sql server 2005 problems CREATE TABLE Upload ( uploadid INT IDENTITY(1,1) PRIMARY KEY, cssid INT NOT NULL FOREIGN KEY REFERENCES CourseSemSub(cssid), teacherid VARCHAR(10) NOT NULL FOREIGN KEY REFERENCES Teacher(teacherid), description VARCHAR(40), video VARBINARY(MAX) NOT NULL ) Unable to create above table , i want to make video fi... 14 Mar 2010 01:15
Update Trigger Hey guys, whats up?? I am not new to SQL but I am trying to create an Update trigger for the first time. I have found several links to Update triggers but they seemed to confuse me more than anything. So, here's what I'm trying to do. I have a table called, "MattersQLegalAssistant" (Table 1)that has a field call... 13 Mar 2010 14:15 |