Search results for query: *

Have you tried running the script with out the comments? I'm not sure how you execute the query but if for some reason it is sent without carriage returns, it is executed as a long one line query. The comments would therefore comment out a lot of the code.

Wrong forum, but to answer your question you can indeed use ExecuteNonQuery to return values from the store procedure but you need to set the direction of your return parameters to returnParameter.Direction = ParameterDirection.ReturnValue. Alternatively you can use ExecuteReader which is used...

You're describing table valued parameters. It's a tried technique and a good solution for your requirements.

I think I understand you now. Does this work for you? create function [dbo].[fn_MTD_V1] ( @report_date datetime ) returns int as begin declare @days int declare @endmonth datetime set @endmonth = dateadd(d,-1,dateadd(mm,datediff(m,0,@report_Date)+1,0)) set @days = day(@endmonth) if...

Hi, How about the following? create function fn_MTD_V1 ( @report_date datetime, @calendar_id smallint ) returns int as begin declare @days int if (dbo.ABfn_IsNonWorkingDay(dateadd(d,-1,dateadd(mm, datediff(m,0,@report_date)+1,0)),@calendar_id) = 0) begin set @days = datediff(day...

Hi, any chance you can give sample of your data?

Hi, This what you're after?... declare @temp table (guid int, testid int, testtypeid int) insert into @temp select 1, 1, 1 insert into @temp select 2, 1, 1 insert into @temp select 3, 1, 2 insert into @temp select 5, 1, 3 insert into @temp select 6, 1, 3 insert into @temp select 7, 1, 4...

Hi, How about... declare @temp table (ERP_Line_Num varchar(3), Item varchar(10), Count int) insert into @temp select '001','0083104',null insert into @temp select '001','0210901',null insert into @temp select '002','0049703',null insert into @temp select '003','0049806',null...

What is your question?

How about... declare @temp table (id int, col varchar(50)) insert into @temp values (1, 'abc-1-a-2-01') insert into @temp values (2, 'efg-2-b-3-02') ;with cte as ( select t2.id, t3.split, ROW_NUMBER() over (partition by t2.id order by t2.id) as num from ( select *...

Hi, Will this work for you? ;with a as ( SELECT row_number() over (partition by tktnum order by tktnum) as idx, * FROM #XY123 ), b as ( select *, case when exists (select idx from a as a2 where a.tktnum = a2.tktnum and a.arrivalcty = a2.departcty and a2.idx < a.idx) then 1 else 0 end as...

This query is only giving me the 09/30/2013, I need the 09/30/2013 and 09/30/2014 paid thru." Your query looks correct. Why are you expecting 09/30/2014 when by your definition, it should only return 09/30/2013 when the current month is 11?

Great responses guys, thank you. I will take on board the use of a view, and look into applying an ordering on the addresses.

Hi, I have a database design question that I was hoping a DB professional could answer. Lets say I have the following one-to-many table relationship between an Account and its Addresses. create table account ( acctkey int, acctname varchar(100), active bit ) create table acctaddress...

Hi, I have a basic understanding of how fluent api's are used EF and how they define properties and relationships of the tables. My question is how do I go about defining a collection of entities that are soft linked. eg. Say I have a Contact table and a generic [MapTable]. [MapTable] MapID...

Hi, I can't seem to add region directives around CodeNamespaceImport. Is is possible to generate this code using CodeDom? namespace MyNamespace { #if POCKETPC using System.Data.SqlServerCe; #else using System.Data.SqlClient; #endif } Thanks Ryan

How about.. declare @temp table (owner char, year int, month int, day int, count int) insert into @temp values ('A',2010,1,1,5) insert into @temp values ('B',2010,1,1,6) insert into @temp values ('C',2010,1,1,8) insert into @temp values ('A',2010,1,2,4) insert into @temp values...

Try the following: declare @temp table (id int, data varchar(50), seq varchar(20)) insert into @temp (id,data) values (1, '5701_012345678_1000') insert into @temp (id,data) values (2, '6701_012345678_ABCDE') insert into @temp (id,data) values (3, '3102_012345678_4565465afdasfd') insert into...

How deep can the level records go? If only 3 as per your example then you could write a query for each level. Otherwise this is one of the few examples where a cursor could be utilised.

Hi, Try adding a rowid to the source table... with cteData (rowid, cnfrm_prod_grp_sub_prod_trans_type_assn_id, cnfrm_prod_grp_code, cnfrm_sub_prod_type_code, cnfrm_trans_type_code, parent_assn_id) as ( select ROW_NUMBER() over(order by (select 0)) as rowid...