Viewing 15 posts - 13,441 through 13,455 (of 15,381 total)
Fred, your explanation is still unclear. Can you post ddl (create table scripts), sample data (insert statements) and the desired output based on your sample data? The question is very...
November 29, 2011 at 10:45 am
Fred, please don't cross post. it just fragments your responses. The reason nobody has answered your question is because you have not provided enough information about what you are trying...
November 29, 2011 at 10:42 am
Faye Fouladi (11/29/2011)
Decalare @WebServiceGetResults XML = NULL
DECLARE @BroadViewData TABLE
(
FundingBedId INT,
EpisodeId INT,
EpisodePackageFormatId INT,
EpisodePackageId INT
)
:With StagingData AS
(
SELECT
NULLIF(T.Item.value('TABID[1]', 'VARCHAR(MAX)'), '') AS TABID,
...
November 29, 2011 at 10:40 am
Yes it does. You need to create a single query as a new dataset that contains the information you want.
--edit. I didn't notice until this last post that this was...
November 29, 2011 at 9:47 am
You are welcome. The query Jason put together is probably the same thing I would have come up with but I figured that the article was worth a read either...
November 29, 2011 at 9:40 am
Well you have a couple choices. The first would be to write a query that joins the two tables (that would be my suggestion). However since you are in .Net...
November 29, 2011 at 9:34 am
Gail has a great blog post on this type of query. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D
November 29, 2011 at 9:15 am
It sounds like all you need is to join two tables. It is hard to say because there are no details in your post. When you say Dataset do you...
November 29, 2011 at 9:10 am
ashkan siroos (11/29/2011)
Dear Sean LangeThanks for reply, If there is no other way, I will use joins... thanks alot...:(
Well if the function itself is fairly simple you may...
November 29, 2011 at 8:42 am
subbareddy542 (11/29/2011)
create function split(@par varchar(max)returns table
declare @t table(id varchar(max))
declare @val varchar(100)
begin
while charindex(',',@par)>1
begin
set @val=substring(@val,1,(charindex(',',@par)-1))
insert into @t1 values(@val)
set @par=substring(@par,(charindex(',',@par)+1),len(@par))
end
insert into @t1 values(@par)
return @t1
end
-----------
example
select split('a,b,c')
o/p
----------
a
b
c
Read the link in my signature or...
November 29, 2011 at 8:39 am
Read the link in my signature for Jeff Moden's splitter. It is super fast and easy to use.
November 29, 2011 at 7:19 am
How complicated is the function? could you just remove the function entirely?
November 29, 2011 at 7:16 am
razmage (11/28/2011)
Grant Fritchey (11/28/2011)
So these are queries and not stored procedures? If they're stored procs you can use the dependency DMOs, sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities.
Hi Grant. No these are queries and...
November 28, 2011 at 2:52 pm
razmage (11/28/2011)
I'm currently trying to when given a query in an NVARCHAR to determine through T-SQL which objects (tables, columns, sproc, functions, etc) the SQL statement touches.
I'm hoping...
November 28, 2011 at 10:57 am
SQL_By_Chance (11/28/2011)
November 28, 2011 at 10:52 am
Viewing 15 posts - 13,441 through 13,455 (of 15,381 total)