Topics
Started by
Posts
Last post
I have a column that is varchar(8) which holds a date as 20170609. I need to convert it to datetime…
11 replies
Hi All, Can someone help me with this SQL code..I was trying to de-duplicate the columns in my sele…
5 replies
Here is my query select st.Num1, st.Num2, st.Cd,count(*) as Empcount,Min(AMT) as Amountfrom emp st …
3 replies
hi, Q1)please explain "The fact that IIF is translated into CASE also has an impact on other aspec…
1 replies
I have data in this format and i need to pivot it. create table #temp(ID int, YDate int, DE v…
6 replies
I have data into field (SS)(DD)(GG) i want parse that field into 3 different column. Is Substring w…
16 replies
I'm in the middle of an index optimization project and beginning to think the way to compare querie…
8 replies
how to get lowest value fom the code column from the query.By looking at the below data i nee…
4 replies
Hi All, I have one table where there is a column that have email id's for more than 30000 users , u…
6 replies
I created a small table called "Department". Values are (DepartmentID which is autopopulated, Name,…
5 replies
I want to check, how many users are connected to any particular SQL Table and cube (SSAS). This wil…
24 replies
Hello Everyone, I am trying to work with this query to return the latest date (in this case it…
12 replies
Hi Experts,I am trying to write a query to join two table but so far no success with joining the se…
2 replies
This one has me a stumped and I admit my SQL skills are limited at best.If I have the sets of dupli…
2 replies
I have this table previously saved to the db from a pivot result baseyear__year1__count1__year2__co…
1 replies
Viewing 15 topics - 1,156 through 1,170 (of 4,984 total)
You must be logged in to create new topics.