Topics
Started by
Posts
Last post
i have table a with two columns.. Testtable vai1 int pk vai2 varchar(50) i want to get the max val…
7 replies
Hello, I need to update the values in a field to make them consistent. Current Values ColumnName AB…
8 replies
I am getting the following error even though I have setup to compatibility to 80. Msg 4147, Level 1…
4 replies
i have a table with testtable var1 int pk, prize_id int prize_encrypt varbinary i am storing encry…
1 replies
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
By: GSquared
I have a query like this: Select import.productid, import.clientid, ....., Coalesce(industry.produc…
4 replies
By: Tony++
Hello, I have SQL Server 2005 Express (Server1) at work and SQL Server 2005 Express (Server2) on my…
4 replies
By: _simon_
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
Viewing 15 topics - 7,756 through 7,770 (of 12,234 total)
You must be logged in to create new topics.