Topics
Started by
Posts
Last post
declare @YYMMDD DATETIME set @YYMMDD='2020-09-23 00:00:00.000' select CONVERT(VARCHAR(6), '2020-09-…
5 replies
hi all, good day I've write the below script to get the difference between two times for this examp…
5 replies
deleted duplicate post This topic was modified 4 years, 11 months ago by mtz676. This…
1 replies
hello, i have a customer table and than a customer group group table which is basically grouping cu…
2 replies
what kind of situation can I use "option (fast 1)" when I execute a Select/update/delete statem…
6 replies
Hi All, Recently, we observed the tempdb has grown out of proportion and filled up all the disk spa…
4 replies
0 I keep getting the error The package execution returned DTSER_FAILURE (1) when executing my job o…
3 replies
Hi, Attached, I exported a CSV file from a multipoint record from sql server database. select Shap…
1 replies
By: lpro
Hi All, I have a SELECT query which is taking more 8 mins. Can you please help me in making the que…
10 replies
Hello - I have a stored procedure that has a multi-valued parameter that is optional. I cannot get…
10 replies
The two main tables are EquipWorkOrder and EquipWorkOrderHrs. I have two columns that I need to piv…
8 replies
Hi team, I was asked to provide metrics on different attributes at customer level for the period of…
1 replies
Hello: I think I might be close here, but I need to return 0 if there is division by zero. SELECT …
6 replies
Hi, I have a table as you can see in codes below. Can you please help me with generating the last c…
11 replies
So as not to hijack an unrelated thread I started a new topic. This is a continuation of a discussi…
12 replies
Viewing 15 topics - 151 through 165 (of 4,984 total)
You must be logged in to create new topics.