Topics
Started by
Posts
Last post
In our stored procedures we have (nolock) hints everywhere in a code. Can I replace them all with a…
7 replies
there is a parameter in stored procedure, and this parameter is table variable, How to get all the …
4 replies
By: DesNorton
Hi I wrote this query and I want the result to be cumulated by period so period 1 result is 1 and p…
1 replies
By: Thom A
Hello SQL friends, I have a char(75) column with values like the following: 05200005400000000000000…
5 replies
Ok, I've written a bit of code and it's horrible and looks terribly inefficient and long winded but…
6 replies
Hi all Looking for some help with the below and massively appreciate any help We have a Sales and R…
2 replies
Hello, i just have a simple select statement, and i get the max value from one table that i use to …
2 replies
By: Siten0308
I am trying to develop a pivot table. Please see the attached image for required output. I am unabl…
1 replies
Following with a user complain about SQL timeout I bumped into one issue with a view. I ran the Obj…
6 replies
Hi All, I have table A that has 2 columns(col 1,col2). I would like a create trigger that collects …
2 replies
I want to number weeks from April to September for every year, such that week 1 starts 1st of April…
6 replies
By: DesNorton
Hello Evening please see below code for sample data CREATE TABLE PHONENOS (CustID Varchar(10), Mobi…
3 replies
Hi I have a requirement to calculate the start and end of the working Month, The criteria is that i…
59 replies
Hi All, I want to compare data of current period with previous period. sample table n data is below…
3 replies
Is there a way to populate the email addresses for a sql agent job or do i have to hard code them?
1 replies
Viewing 15 topics - 301 through 315 (of 3,067 total)
You must be logged in to create new topics.