|
About the Transact-SQL category
|
|
0
|
1869
|
May 7, 2015
|
|
Use sp_Send_DBMail with Variable
|
|
1
|
13
|
December 8, 2022
|
|
Is there a function in SQL that does the same as the Excel forecast.ets function?
|
|
1
|
30
|
December 7, 2022
|
|
SSIS Error The type of the value (DBNull) being assigned to variable "User::FileName" differs from the current variable type (String)
|
|
7
|
50
|
December 7, 2022
|
|
SUM values based on values of another column
|
|
2
|
33
|
December 6, 2022
|
|
How to apply inclusion and exclusion from the same table in SQL criteria?
|
|
24
|
134
|
December 6, 2022
|
|
Conversion failed when converting date and/or time from character string
|
|
7
|
48
|
December 5, 2022
|
|
SQL Insert Into Multiple Records based on Serial Number
|
|
3
|
58
|
December 5, 2022
|
|
Need info on ISNULL
|
|
8
|
78
|
December 5, 2022
|
|
SQL Server XML to Table value
|
|
2
|
61
|
December 4, 2022
|
|
Report generation speed
|
|
7
|
89
|
December 3, 2022
|
|
UPDATE Failing on value not in WHERE clause
|
|
3
|
52
|
December 1, 2022
|
|
Help with query for Aging report
|
|
14
|
105
|
November 29, 2022
|
|
Select Unique Parent IDs based on values of child IDs
|
|
4
|
40
|
November 29, 2022
|
|
Problem attaching a sql database to a vb,net app
|
|
0
|
28
|
November 28, 2022
|
|
Iteration or loop trough select result
|
|
8
|
60
|
November 27, 2022
|
|
Division of two int values, result always 0
|
|
3
|
68
|
November 27, 2022
|
|
Count number of times an unknown substring appears in string
|
|
1
|
35
|
November 26, 2022
|
|
Convert date to year when join tables
|
|
2
|
48
|
November 25, 2022
|
|
[SQL] - Separate timestamps on several lines
|
|
3
|
65
|
November 25, 2022
|
|
How many days / hours / minutes a record is in a particular state
|
|
1
|
49
|
November 23, 2022
|
|
Query help
|
|
6
|
63
|
November 23, 2022
|
|
How to apply exclusions criteria when 2 tables are linked by one to many relationship?
|
|
7
|
64
|
November 18, 2022
|
|
Learning to use PATINDEX, but getting unexpected matches
|
|
3
|
44
|
November 17, 2022
|
|
Hierarchy with Aggregation
|
|
3
|
71
|
November 14, 2022
|
|
How can I refine my query in a best way with optimum results (for large database)
|
|
6
|
94
|
November 11, 2022
|
|
Special characters in an SQL query
|
|
1
|
51
|
November 10, 2022
|
|
Meaning of the sql query below PLEASE I NEED HELP AM DOING AN INVESTIGATION ON A TRANSATION AND WE SAW THIS QUERY ON A LOG
|
|
3
|
87
|
November 10, 2022
|
|
Create Flag Based on Info in Two Different Columns
|
|
5
|
98
|
November 8, 2022
|
|
How to update a table every month using EOMONTH function
|
|
3
|
80
|
November 8, 2022
|
