Topics
Started by
Posts
Last post
In t-sql 2008 r2, I would like to know how to select a specific string in a varchar(50) field. The …
6 replies
Can someone please give me advise on a better way to write the following? SELECT a.BoxId, b.field1 …
12 replies
Hello Everyone I found some duplicate data as I was going thru the logic of a data pump. The entire…
4 replies
Hi, I trying to do AVG function in SQL and seems it does wrong calculation. Data : -1, -1, 0 If we…
2 replies
Helllo, Can somebody help me? I have a table with 5000 rows history about working and retired time.…
7 replies
Hi Friends, i m creating web application for state and dist wise map i ve the tables like create …
4 replies
Hi, I've a small issue working out how to remove the trailing chars from the end of a percentage ca…
8 replies
Hi All, I have one table say A and in which 4 columns are there. Out of 4 , one columns stores the …
7 replies
Hello Everyone, I need to pull a report from a table which gives me daily totals, I'm asked to get …
31 replies
Hi, I'm sending report based on below DB Mail query from mentioned data format table. But i'm get…
5 replies
I have 6 tables in a query and need to get records from tables like TBL_A,TBL_B and Rest of the 4 t…
3 replies
This query takes 2 mins to execute, Please suggesr if we can improve more on performance SELECT P…
10 replies
Hi, I've table and data as follow, declare @tAccount table ( isLocked bit, LastLockoutDate datetim…
3 replies
Hi All, I have this query SELECT 'Type'[Type] ,CASE WHEN code='09' THEN SUM(Amt/100) ELSE 0 END …
18 replies
Hello All, See code and desired results below. Given a groups of stores one of which is deemed the …
4 replies
Viewing 15 topics - 2,161 through 2,175 (of 10,647 total)
You must be logged in to create new topics.