Topics
Started by
Posts
Last post
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
Hello everyone, First of all, I hate working with dates, hahaha, hum... I checked all the topics re…
20 replies
Hi , Suppose i have 100 stored procedures. Now i want to search for 'abc' in all the 100 Stored Pr…
4 replies
Hi All, I need to count the total sales prior's 4 weekend when user give the weekend date. I have s…
4 replies
Viewing 15 topics - 5,401 through 5,415 (of 10,644 total)
You must be logged in to create new topics.