Topics
Started by
Posts
Last post
Hi Folks I have a stored proc that contains an update which utilizes a case statement to populate v…
15 replies
Hello, why are there more decimal positions here PRINT cast(111 as decimal(38,35)) / 23 --> 4.8…
2 replies
Hello everyone I need some help with this one. I have a field which contains something like prj(561…
13 replies
Hi, I keep getting requests to increase the width of a varchar colum every now and then. I want to…
6 replies
Hi, I'm trying to use the User-Defined Table Type and having a couple of issues. 1. Transactions s…
7 replies
I have data in the following format OrderID ItemName UnitPrice Quanity 1 …
3 replies
I have a master table and i need to import the rows into the parent and child table. Master table n…
2 replies
Here is my problem:- declare @test-2 as varchar(32) declare @test2 as varchar(32) set @test-2='to…
4 replies
Hi, I have a dataset that I need to search for a maximum value of a specified index. Example of d…
3 replies
Hello, I have this t-sql code which will get some table stats on one database at a time, I was wond…
1 replies
ALTER procedure [dbo].[sp_debit_credit] as begin SET NOCOUNT ON DECLARE @DEBIT_ID INT DECLARE …
4 replies
I have a query that is performing index seek on a large table and taking about 5 minutes, is it pos…
13 replies
Hello All, Hope to get an idea what I can do to improve the following, please: 1. I have a simple J…
29 replies
In VBA, CLng(Now) will return the integer portion of a date CLng(Now) returns 41928, CDate(41928) t…
3 replies
hi all, im pretty new to sql server how do i achieve the below result for given data. enrollno d…
2 replies
Viewing 15 topics - 3,721 through 3,735 (of 4,984 total)
You must be logged in to create new topics.