Topics
Started by
Posts
Last post
hi all how to sort non clustered indexes ? any suggestion on this
18 replies
Hi all, Recently i any idea for fixing this ?
3 replies
If someone can give me a hand on how to most efficiently modify the attached SQL without a cursor (…
2 replies
Afternoon All, i am stumped on a lag function which i need some advice/guidance on how i could solv…
5 replies
Hello All, I have a requirement to dump the below data from .txt file into SQL Table using Bulk Ins…
3 replies
We are doing some refactoring of our database, and we are redefining a status column in a parent ta…
5 replies
I would like to ask if anyone would be able to help out with this. I would be more than happy to up…
14 replies
How do I assign row values to variables? Let’s say I have a table with one column called Values wit…
8 replies
have the following 2 tables: declare @Policy table ( AccountNum nvarchar(5), PolicyNum nvarchar(20)…
4 replies
I have 3TB database and MDF is 2TB, how to create secondary file?
4 replies
I need to do a report for all available flavors sold in different regions. However I only want to c…
2 replies
I'm trying to create a stored proc using both a function and a view. I'm getting an "invalid column…
6 replies
Hi, I am trying to automate some manual process where i have to read some attributes and insert the…
2 replies
I currenlty have a stored procedure which puts together a table which quite a clot of complicated r…
3 replies
I have this script below: How can I take out the sub-query in this? select datepart(yyyy, D.Date)…
2 replies
Viewing 15 topics - 2,206 through 2,220 (of 4,984 total)
You must be logged in to create new topics.