Topics
Started by
Posts
Last post
I have been trying for days unsuccessfully trying to find a way to run a SQL query to read in data …
2 replies
Hi guys, can somebody please explain why I can't insert into temporary table from the linked serve…
8 replies
hi i have tabe a: id name version -------------- 1 a 1 2 a 2 3 a 3 4 b…
2 replies
Hello, I was in the middle of a production code move last night and I was trying to run in some new…
2 replies
Somewhat theoretical question, I suppose - which of these optimal to use when you're looking for al…
2 replies
Hi, I have a table with columns that stores some strings: ID col1 col2 1 aa bb 2 cd …
2 replies
Hi Gurus, I am creating DimTable and I got a situation where hierarchy is with postcode. But issue…
1 replies
Below is the code I am using to generate DimCustomer table. However, suburb column got few empty sp…
3 replies
Hi experts, I have always wanted to know this, What is the best way to write a tsql code for parame…
4 replies
I have a very un-normalized table and have been asked to add two columns, Trx_Volume_YTD and Trx_Vo…
1 replies
I'm pulling what's left of my hair out. Here is the problem: I need to retrieve data from mainframe…
2 replies
I have the following: SELECT [Date], uShiftID, Case_Code, SUM(coalesce(Case_Count,0)) AS Case_C…
3 replies
I did some quick search but no luck so far, here is my data in xml format, I need a function fnGetA…
10 replies
Sometimes the problem with being self taught in TSQL is knowing where to begin. If my search misse…
8 replies
I'm trying to execute a query using the Year function and it works if I just execute the query alon…
2 replies
Viewing 15 topics - 5,281 through 5,295 (of 12,231 total)
You must be logged in to create new topics.