Topics
Started by
Posts
Last post
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
Hi all experts, Just happen to read about CTE. What i can understand from the stuff given on intern…
5 replies
I am having a problem identifying the node position that contains a particular element in a piece o…
14 replies
In a sql server 2008 r2 database, I am going to increase the size of a field in a particular table …
1 replies
Hi, Today I was asked what the fastest way was to find out if a set of date ranges intersect. To cl…
12 replies
In a sql server 2008 r2 database, I am changing the size of a column called NOTES from varchar(500)…
7 replies
What is partition Function and what is the used(need) of partition function?
1 replies
How do I remove nulls from case statements with date fields . For example in the else clause when b…
3 replies
Viewing 15 topics - 5,401 through 5,415 (of 10,647 total)
You must be logged in to create new topics.