Topics
Started by
Posts
Last post
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
I executed a script with many commits in in. However, while executing the script together i got a …
5 replies
Hey all, I'm hoping someone has dealt with this before. I have a SQL Job that uses a command line t…
1 replies
Viewing 15 topics - 5,881 through 5,895 (of 12,230 total)
You must be logged in to create new topics.