Topics
Started by
Posts
Last post
The issue is the ability to substitute the library name in the SET @list = statement. -- from…
4 replies
I want to do something like this in sql. I have a table in sql with startDate and enddate. I …
3 replies
I have business logic for date comparisons that go beyond the typical DATEDIFF functionality. …
58 replies
Hi All, Which query performs faster given each table has 30-40 columns and each table has huge data…
6 replies
Greetings, I am a Systems Engineer turned DBA. I am starting to understand the basics of this new j…
4 replies
Hi all,I have like this CREATE TABLE dbo.[IpRange] ( [IpRangeid] [BIGINT] IDENTITY…
7 replies
I have a situation where I am thinking of using EXISTS or NOT EXISTS function.I have a scenario whe…
4 replies
Every morning I manually used Tasks SQL Import to populate my table using excel file as my source o…
8 replies
Hello everyone, I am new to TSQL development and well to be honest programming itself. Al…
7 replies
I am trying to compare two tables columns to make sure both are matching. I have done the basic row…
17 replies
Dear All, Please help me to sort out it I have reporttable where the fault report date and complete…
4 replies
This is the query which app uses and it takes 30 seconds. select * from tablename FOR XML AUTO, E…
6 replies
Hello, I have troubles with this query: SELECT id, SUM(repayment) as suma, DATEADD(S, -1, DATEADD(…
1 replies
I have a table with two columns: Employee, Superior with their names in it. Now, I need to cr…
4 replies
I'm out of ideas, and I need help. Here's the set-up: I have a stored procedure that c…
8 replies
Viewing 15 topics - 2,716 through 2,730 (of 3,018 total)
You must be logged in to create new topics.