Topics
Started by
Posts
Last post
view1 id bigint id2 int iddesc char(25) table1 id id2 amount count date select * from table1, …
4 replies
I'm trying to wrap my head around how to best do this. I would like a stored proc that would retur…
5 replies
Hi, I have a SP that returns a list of records according to users permissions. ALTER PROCEDURE [us…
8 replies
Hi I want to run a query to given a date return dates in 10 day interval here is the query WITH fe…
8 replies
Hi I am hoping for a little guidance from someone with more knowledge on subqueries than myself. I …
7 replies
Hi, below is how the data in my table currently looks like: Select dteStartDate, dteEndDate, txtCo…
11 replies
Hi guys, First time posting to this forum. I am having issues trying to delete from a table with ve…
12 replies
Hello, I´m trying to use CTE to find the very top parent within a table without any NULLs My test t…
16 replies
Hi all ! i have the following table structure : id(Identity) time action 1 …
5 replies
i have 1 udf which returns RETURNS TABLE how can i add into it
85 replies
I think that what I want is impossible to achieve with T-SQL alone. . . please tell me if it *is* p…
29 replies
Hello everyone 🙂 good site, very comprehensive, though after routing round I’m still having trouble…
6 replies
I tried to delete records in some tables. I got an error: The DELETE statement conflicted with the …
17 replies
Hi Guys, As a part of security audit reporting i need to find out all logins who have the dbo role …
1 replies
Hi, I have a table with 17 indexes... I execute a query to check the fragmentation level and get 16…
8 replies
Viewing 15 topics - 6,181 through 6,195 (of 10,647 total)
You must be logged in to create new topics.