Topics
Started by
Posts
Last post
Hi All, I've a question regarding a problem that I’m facing. I need to get the orders that were pla…
13 replies
Hi All, I've a question regarding a problem that I’m facing. I need to get the orders that were pla…
1 replies
Hi, Please find the below query INSERT INTO tbl_employee (EmpNo,CompanyID,MngrID,DateOfFiled,DateO…
4 replies
Hi, I am a newbie in sql server.I have came across various article on internet which shows how to i…
11 replies
DISCLAIMER I did not write this code Assume that #InstitutionChild is just a temp lookup table file…
12 replies
select run_date, server_name, database_name, table_name, rows from table_rows as a where run_date &…
2 replies
I have a simple SPoc: ALTER PROCEDURE [dbo].[TestSPR] @P1 int AS BEGIN SET NOCOUNT ON; DECLAR…
11 replies
Hey, Can you please provide some on idea on group the common word? Example: Code Desc A1 …
13 replies
I've been having a look at a project that is underperforming when selecting from a view, and notice…
4 replies
Hi All, I'd like to perform a rolling monthly analysis. Let's say I have a sales table and if a cli…
10 replies
Hey guys, So I have this view, and in creating this view, I want to pull all these invoices that we…
24 replies
I have this select statement: select a.active from sys_scd_profile a inner join sys_scd_profile_act…
4 replies
Hi all, We have a software application that allows our users to group records based on a column whi…
3 replies
Hi I have a CTE statement i want to select from, I know there is the option of using multiple CTEs …
2 replies
Hello; the below sql statement was executed in the 2008r2 server under SA credentials SELECT * INTO…
2 replies
Viewing 15 topics - 5,386 through 5,400 (of 10,635 total)
You must be logged in to create new topics.