Help needed with code

Question

Post reply

Help needed with code

Viewing 11 posts - 31 through 40 (of 40 total)

You must be logged in to reply to this topic. Login to reply

pwalter83 SSChampion Points: 14571 More actions · Answer 1

pwalter83

SSChampion

Points: 14571

December 22, 2010 at 10:04 am

#1265603

I have attached all the relevant documents which are being used for this query. Would that be enough ?

pwalter83 SSChampion Points: 14571 More actions · Answer 2

pwalter83

SSChampion

Points: 14571

December 22, 2010 at 10:05 am

#1265605

What format do you want me to convert the spreadsheets then ?

WayneS SSC Guru Points: 95405 More actions · Answer 3

pwalter83 (12/22/2010)

What format do you want me to convert the spreadsheets then ?

CREATE TABLE <YourTableName> (Your Column list);

ALTER TABLE to show PK/FK/UQ constraints.

CREATE INDEX to show any indexes on the table.

INSERT INTO <YourTableName> sample data

repeat for all involved tables.

Test all of these yourself to ensure that they actually do run and set things up properly.

Then, for the sample data provided, show the expected results.

The easier it is for us (remember - we're unpaid volunteers helping out here!) to just copy/paste an environment that has everything that we need, the faster we can work on it and get something (that has been TESTED against your sample data) out to you.

Thanks for trying! I know you're getting frustrated by it all, but since we're not being paid, why should we jump through the hoops just to help you out? Meet us half way, with what is asked for, and you'll get a lot of people that will help out. (There are a lot of people that read nearly every single post, but they also refuse to help out if the sample data isn't readily consumable (cut-and-paste) into SSMS to be able to start working immediately. I wouldn't be surprised if once you post the data this way, if several others jump in with suggestions!)

Edit: Also, please use the code="sql" IFCode shortcut to wrap around your code. It's in the box to the left of the window that you type all of this stuff in.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

LutzM SSC Guru Points: 107049 More actions · Answer 4

pwalter83 (12/22/2010)

I have attached all the relevant documents which are being used for this query. Would that be enough ?

Here's a short SQL puzzle for you:

SELECT @answer = result FROM "Did you actually read the article/link we asked you to read?"



SELECT

 CASE

  WHEN @answer = "yes" THEN "What specifically is unclear so you can't follow it?"

  WHEN @answer = "no"  THEN "Is there any specific reason for you not to read that article/link?"

  ELSE "Please make a decision."

END

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

LutzM SSC Guru Points: 107049 More actions · Answer 5

Paul,

it seems like you're not really interested in helping us help you.

Instead of providing the information we asked for multiple times you decide to open new threads with the very same incomplete information (for anyone who's interested: just check the post history...).

This issue you brought up about a week ago could have been resolved almost immediately with just a little effort on your side (read an article and react accordingly).

Before I start seeing some kind of parallelism to feeding a troll I'm going to leave this thread for someone else.

Side note: As a last resort you could always hire a consultant to fix the issue for you. That person would at least be able to see the table structure and some sample data in a ready to use format.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

pwalter83 SSChampion Points: 14571 More actions · Answer 6

Hi Wayne,

Thanks a lot for your suggestions. The question I want to ask is-

I need to assign a value to a column called 'tradelane' for each unique BL_ID in the NCV_BL_DHL_TEMP

table. This column will be part of a newly created table called- DHL_TEMP

Please find the the table structure for the 2 tables that I am using below along with the sample data code:

First one is the DHL_TRADE_ASSIGNMENT table-

-----------------------------------------------------------------

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[DHL_TRADE_ASSIGNMENT](

[COUNTRY_CD] [nvarchar](20) NOT NULL,

[COUNTRY_DSC] [nvarchar](50) NULL,

[REGION_TRADE] [nvarchar](50) NULL,

[SUB_REGION] [nvarchar](50) NULL,

UNIQUE NONCLUSTERED

(

[COUNTRY_CD] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

-----------------------------------------------------------------------

Sample data for DHL_TRADE_ASSIGNMENT-

-----------------------------------------------------------------------