Topics
Started by
Posts
Last post
Hi I need to pass the varchar string in dynamic sql. e.g. I have declare @val = 'Sam,Joe' I need t…
2 replies
Well I'm not sure where even to start with this one. I have a table of transactions for a given pie…
3 replies
Hi Friends, I was trying to eliminate 0's & 9's for a validation and not successful in it. Bas…
6 replies
I need to replace some values in a column (varchar(max)) and I want to avoid cursors. I have a tabl…
5 replies
CREATE TABLE test( ITEM VARCHAR(30), QUANTITY numeric(38,5) ) INSERT INTO TEST SELECT 'RMA2052', 8.…
4 replies
Hi folks, I am trying to match up pairs of records in a dataset that denote times at which people l…
3 replies
--View1 CREATE VIEW dbo.VW_ReportSOSlipDetail AS SELECT dbo.Tbl_DemandIssue.BatchNo, dbo.VW_AllItem…
6 replies
I should get data from Time column of temptime table where the time which does not come inside any …
6 replies
Hi, I have a table with DateTimeIn, DateTimeOut, TotalAmount columns. I want to get the following r…
2 replies
I'm trying to create a stored procedure that will take a datetime variable, strip out the month, an…
3 replies
Hi, I have a sql 2005 table (Table_A) that contains the following values (with column headers) DEl_…
3 replies
Hi, I'm trying to export a column which is a NVARCHAR(MAX) into a text file, the column is very lar…
6 replies
Dear All, I got a task to calculate blanded benchmark value, Based on return calculated for client…
9 replies
Hello Everyone; I have 2 SQL Server (one is 2008 the other 2005 - both Standard Versions) I need to…
1 replies
I got this Query here in the scripts forum. It lists all the roles a user is in. What I also need…
2 replies
Viewing 15 topics - 3,496 through 3,510 (of 12,234 total)
You must be logged in to create new topics.