Topics
Started by
Posts
Last post
when i compiling the following code, getting this error Msg 102, Level 15, State 1, Procedure fnGet…
4 replies
Can someone please help me 🙁 i want [totalpay] from TD2 to automatically calculate [TD1].[rate] * […
12 replies
I have created an indexed view as given below CREATE VIEW [dbo].[test] WITH SCHEMABINDING AS S…
6 replies
Users are reporting failures to insert rows in a table. The table is little used and was thought t…
2 replies
Hi All, From the below example, can you guy tell me why my case function is not working as per the …
4 replies
Hi everybody I have around 6 tables connected using one to many relationship I want to make a proce…
15 replies
Insert Into absorbentorder(ChalanNo,dpc) SELECT 'chalanno',items.item.value('.','varchar(150)') As …
2 replies
Hi my data is coming in as text into nvarchar as it read from a text file. declare @data_nv nva…
9 replies
I have a scenario where there is a linked server (A) that has two tables that I need to join, Accou…
10 replies
I have a temporary table with : ProductId,count(p.ProductId) AS cnt, p.Productname,p.productbrand W…
1 replies
Hi all, Below is the script which is built for SQL Server 2000 ( This can also be used for SQL Ser…
5 replies
I have a DB trigger that when a user updates their address in a table, it sends an email. It works…
10 replies
I have coded two sql select stmts that I though would be equivalent but have learned through observ…
4 replies
SELECT starttime AS Time_Period, SUM(incalls) AS [Inbound Calls], SUM(acdcalls) AS [ACD Calls], SUM…
6 replies
Hi all - I have an issue I've been fighting with and can't seem to come up with a solution. Basical…
5 replies
Viewing 15 topics - 5,881 through 5,895 (of 12,232 total)
You must be logged in to create new topics.