Topics
Started by
Posts
Last post
I find myself in a situation where I have a table in which I need all the fields but it is also sup…
5 replies
I'm new to native compiled stored procedure and I'm getting an error during a simple store procedur…
1 replies
OK, I know this sounds a bit wonky, but I have a client that has a very large database (about 2 TB)…
6 replies
Hello, I am having issues with this query. I have a table which has a UserID and a datetime stamp. …
13 replies
Hi! Could someone please help me create a query all extended events and their status in all servers…
2 replies
I want to check if current database is EMP then i have to define var at package level set def…
1 replies
I have a table getcode where it has countrycode,statecode, citycode and zipcode columns there are o…
5 replies
we have json getting stored in one of the tables and how can we search inside the json.
5 replies
Hi, I need to differentiate when a user is internal or external., So I have an existing query below…
3 replies
Hi I need to do a query that when finds a seq_number with more than one day (day0 to day d62) retur…
5 replies
Hi Experts, Need some tsql help. create table #temptbl ( c1 varchar(100)) insert into #temptblsel…
5 replies
select SUM(c_amount) from Transactionswhere s_credit_tran_type = 'cash' and b_cancel = 0 and b_cred…
11 replies
ALTER TABLE [dbo].[emp] ADD [ID] INT IDENTITY(0000001, 1) SELECT IR.JournalSource, …
2 replies
Hello, I have a query that I would like to just group by the (LastInteractiveDate - by day) but not…
2 replies
I have 2 tables one is dbo.emptemp and another is dbo.empI am trying to join these two tables and s…
4 replies
Viewing 15 topics - 1,591 through 1,605 (of 3,067 total)
You must be logged in to create new topics.