Topics
Started by
Posts
Last post
Hi all i am trying to create indexed view as follow: create vew v1 with schemabinding as ( if ((sel…
14 replies
I know how to get the smallest value for a group using MIN and GROUP BY, but what if I want to get…
27 replies
I have an XML untyped column in my table with data like this: <Appointment/> <Date&g…
2 replies
If anyone can help I would be very grateful Here is what i need, to pull a random person from a si…
1 replies
Here is my sample data: 1;a;b;c;; 2;d;e;f;; 3;g;h;i;; 4;j;k;l;; 5;m;n;o;; 6;p;q;r;; Here is my samp…
2 replies
Hi folks, How can you know, from the information_schema.columns view, if a column is identity or no…
3 replies
Hi guys, I'm new at this forum =P I'm having problems with the new FOR XML PATH feature. I'm trying…
2 replies
I have a query like this: Select import.productid, import.clientid, ....., Coalesce(industry.produc…
4 replies
Hello, I have SQL Server 2005 Express (Server1) at work and SQL Server 2005 Express (Server2) on my…
4 replies
CREATE PROCEDURE sp_GetTasks @colname nvarchar(50), @colvalue int AS BEGIN SELECT * FROM Tasks …
11 replies
Requirement: There is a product table and prodcutpackage table. Each package id is also a product…
11 replies
I am using the following code SELECT userid, username, billed,SUM(grossamt) FROM EMNCommon WHERE (t…
1 replies
i have table a with two columns.. Testtable vai1 int vai2 varchar(50) values vai1 =1 vai2= 1234,578…
5 replies
Hi, I have a table as: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Questio…
7 replies
I wrote this view a while back whose only purpose is to add a single field from anther table that w…
11 replies
Viewing 15 topics - 7,756 through 7,770 (of 12,230 total)
You must be logged in to create new topics.