Topics
Started by
Posts
Last post
Hello, I have a dataset of route data (this is just a single route) like below: CREATE TABLE [dbo].…
7 replies
I want to query a table that has a datetime column ([CreateDateTime]) and get the week number for…
21 replies
i try to understand why my procedure do not respect the loop in batches of 10 until the end. i …
7 replies
Hello, I have come across this peculiar problem. This stp is called every begin of the day of the a…
8 replies
Hi, Not sure if this is possible. I'm looking to insert a new row into a temp table if a field on t…
6 replies
Hi all We've got some tables where the field order is .... odd. We designed the tables but, …
21 replies
hello, my query is select * into #TmpA from tblA (nolock). tblA contains 116000000 records. This qu…
12 replies
When ASCII(Column) is null, what does it represent? Is this some kind of special/control characters…
5 replies
Hello, Converting file name MMDDYYYY.txt to a Date Field but CONVERT or CAST do not seem to work pe…
14 replies
Hi everyone, I have a XML file in which data looks like this: <ArrayOfHomeModel xmlns:i="http://…
15 replies
Hello experts, Could someone point me to some ideas about troubleshooting this error that I am gett…
5 replies
Hello, I need to setup a Stored Procedure to run on the first Monday of each month that is not a ho…
22 replies
We have several tables with system_versioning set to on. There is a requirement now to produce a so…
2 replies
When Running a stored procedure how i can track which records got created, updated and deleted as a…
1 replies
Hello everyone, Was looking for some feedback before I make a DB object change. So, I have a part…
4 replies
Viewing 15 topics - 91 through 105 (of 3,062 total)
You must be logged in to create new topics.