Topics
Started by
Posts
Last post
Hi, See if you can figure this out, because I cannot. I have full rights as dba on a database. I ha…
16 replies
Hi, Please help me with this query. I want output in the below format. I know that this is not…
25 replies
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
Viewing 15 topics - 5,881 through 5,895 (of 12,234 total)
You must be logged in to create new topics.